Need to reduce the size for selected records

Karthikeyan Subbarayan · New User Joined: 24 Feb 2008 Posts: 62 Location: Boston

My input file have different table values and my tabels are ZBCRI,EDADB,ZBCRW,ZAOXP in which the table ZBCRI one of the cloumn datatype has been reduced from CHAR(5) to CHAR(2) and the remaining table row's should be same in the output file. Can some one help me on this.

My input file looks

Skolusu · Posted: Wed Feb 24, 2010 10:59 pm

Karthikeyan Subbarayan,

You haven't mentioned the LRECL/RECFM of the input files. I assumed that your input is FB recfm and 80 bytes LRECL. The column that needs to be truncated is at pos 27 thru 31.

Karthikeyan Subbarayan · New User Joined: 24 Feb 2008 Posts: 62 Location: Boston

hi Skolusu,

my record format is VB and record length as 2000 and also in the example i show only few records but orginally the input file has bulk of records . So for SORTIN shall i use the input file name and also i need the out put file with the specified format

Skolusu · Posted: Thu Feb 25, 2010 12:18 am

Karthikeyan Subbarayan,

No. You cannot use the same control cards. You need to use different control cards.

What is the position and format of the table identifier (ZCBRI)? consider the RDW (4 bytes) when specifying the position.

What is the position and format of the field that needs to be truncated? consider the RDW (4 bytes) when specifying the position.