How to reformat the OUTPUT of JOINKEYS operation.

ramsri · Active User Joined: 18 Oct 2008 Posts: 380 Location: India

Hi,

I am running below given job and got the expected results.

joseph murphy · New User Joined: 24 Nov 2008 Posts: 17 Location: USA

Hi,

Try this,

OUTFIL FILES=OUT,
OUTREC=(1:1,6,8:X,9:7,10,20:X,21:17,5)

Note:

REFORMAT FIELDS=(F2:5,6,13,10,23,5) for this reformat

LREC should be 25(SORTOUT file length)

Arun Raj · Posted: Fri Dec 12, 2008 4:13 pm

Ramsri,

You need to mention the positions in OUTREC/INREC based on the REFORMAT record and NOT the original file. Here your reformatted LRECL is just 21 and mentioning file positions beyond that would result in error.
You should be using a Sort card like this.

ramsri · Active User Joined: 18 Oct 2008 Posts: 380 Location: India

Wow......wonderful.....

Arun, I have made a note of what you suggested. That is very good tip to remember.

Thank you very much.

Bye.