Selection based on part of char field
Page 1 of 1
Selection based on part of char field
Archana K Sun Jan 27, 2013 2:45 pm
Way to select only data where field A has a 'C' in position 12. The field is a 15A field.
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 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
Archana K- Posts : 76
Join date : 2013-01-27
Age : 32
Location : chennai
Similar topics» Run Backup based on objects count
» Sort a file based on a field whose position is not fixed
» Add library - System Part
» How to get the record based on key
» Field modification impact on other related objects
» Sort a file based on a field whose position is not fixed
» Add library - System Part
» How to get the record based on key
» Field modification impact on other related objects
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum|
|
|