Selection based on part of char field
2 posters
Page 1 of 1
Selection based on part of char field
Is there a way to select only data where field A has a 'C' in position 12. The field is a 15A field.
Thanks in advance!
Raj
Thanks in advance!
Raj
rajkumar400- Posts : 59
Join date : 2010-12-25
search for a filed with a char C in 12th position
A R RECNAM PFILE(XYZ)*/
A NEWFLD 1A I SST(FIELDA 12 1) /* DECLARE A NEW FLD WITH ONE CHAR LEN */
A K KEYFLD
A S NEWFLD COMP(*EQ 'C') /* USING SELECT/OMIT PROCESS WE CAN DO IT
A NEWFLD 1A I SST(FIELDA 12 1) /* DECLARE A NEW FLD WITH ONE CHAR LEN */
A K KEYFLD
A S NEWFLD COMP(*EQ 'C') /* USING SELECT/OMIT PROCESS WE CAN DO IT
kushaalrathi- Posts : 12
Join date : 2010-12-26
Re: Selection based on part of char field
Thanks. It works.
Is there any otherway to do this?
Raj
Is there any otherway to do this?
Raj
rajkumar400- Posts : 59
Join date : 2010-12-25
Similar topics
» What is a field type? List the 3 field types
» How to get the record based on key
» Record Positioning
» Run Backup based on objects count
» What are the access paths on which Print file can be based on?
» How to get the record based on key
» Record Positioning
» Run Backup based on objects count
» What are the access paths on which Print file can be based on?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|