Editing columns in the outrec statement

saranyak · New User Joined: 21 Jun 2007 Posts: 1 Location: Chennai

Hi,

I have two columns in an input file DEPT-OBJ-I PIC X(12) and
END-OH-RETL-A PIC S9(16)V9(02) COMP.

Even though DEPT-OBJ-I is X(12) it is not in a readable format.

How do I convert these two columns to readable format using outrec statement?

Thanks,
Jo

dick scherrer · Posted: Thu Jun 28, 2007 1:15 pm

Hello,

Look at the data in hex and post some samples here.

Depending on what is in the fields, there may be different syntax needed.

Frank Yaeger · Posted: Thu Jun 28, 2007 9:10 pm

Jo,

PIC X(12) is a 12-byte character field. We have no way of knowing what's in that field, so we can't tell you how to convert it. You have to show us what the data looks like.

PIC S9(16)V9(02) COMP - I think this is an 8-byte BI field. So you could use something like p,8,BI,TO=FS to convert it to a readable format.

For more information on converting numeric fields to other formats with DFSORT, see:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/2.4.7?DT=20060615173822

For more information on editing numeric fields with DFSORT, see:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CG20/2.4.8?DT=20060615173822