Sort the input file and need to retrive only some fields

latheef · New User Joined: 25 Sep 2009 Posts: 13 Location: chennai

Hi,

I have a requirement. I have an input file length is 630 bytes.
I want to retrieve the following fields CURR-CARD-NO starting position is 546 length is X(19), BILL-CYCLE-DT starting position is 572 length is X(10) and SOLD-TO-AECB-IN starting position is 618 length is X(1) .

I need to create one output file having length 80 bytes. I want to retrieve the above three fields from input file and the remaining 50 bytes will be spaces in the out put record.

I need to do it through JCL only using SORT utility.

Thanks in advance.

karthikr44 · Posted: Tue Oct 27, 2009 11:40 am

Hi,

SORT FIELDS=COPY
OUTREC FIELDS=(546,19,572,10,618,1,49X)

Regards
R KARTHIK

latheef · New User Joined: 25 Sep 2009 Posts: 13 Location: chennai

Thanks KARTHIK.

gcicchet · Posted: Tue Oct 27, 2009 1:53 pm

Hi,

just being picky, shouldn't this

latheef · New User Joined: 25 Sep 2009 Posts: 13 Location: chennai

Yes. Thanks for the reply.