Sequence number genaration, intial num from otr file

vasantha.gl · New User Joined: 23 Sep 2011 Posts: 12 Location: Chennai

I have a input file(File1) and I want to generate sequence number in a output file(File3)
Starting number to generate the sequence number i need to get from other file(File2).

Can any one help me out to resolve this issue.

xknight · Posted: Thu Mar 29, 2012 10:44 am

Hello,

vasantha.gl · New User Joined: 23 Sep 2011 Posts: 12 Location: Chennai

File 1 Layout RECFM=FB,LRECL=80
File 2 Layout RECFM=FB,LRECL=80 sequence number Start is present at 10 position
File 3 Layout RECFM=FB,LRECL=80 generate sequence number at 10 position
sEQUENCE NUMBER IS ZD(LENGTH 6)

In Brief :
(get the sequence number from File2(10th position) and generate the next sequence numbers in File3(10th position))

we can Ignore File1 in picture.

gcicchet · Posted: Thu Mar 29, 2012 11:42 am

Hi,

how many records are in file2 ?

Gerry

vasantha.gl · New User Joined: 23 Sep 2011 Posts: 12 Location: Chennai

There are 12 records in the file2. Need to take Last record(12th) 10th position and start generating the sequence number in file3 10th position.

gcicchet · Posted: Thu Mar 29, 2012 2:19 pm

Hi,

try this

vasantha.gl · New User Joined: 23 Sep 2011 Posts: 12 Location: Chennai

Yes, The above code is working. Thanks a lot for your support.

But I have a Last change in this.
How can I write generated sequence number into File3 in 89th position(STEP0200 step).

Thanks in Advance

vasantha.gl · New User Joined: 23 Sep 2011 Posts: 12 Location: Chennai

Thanks I got it.

By changing OUTREC to 86, i got what was expecting

gcicchet · Posted: Fri Mar 30, 2012 8:46 am

Hi,

this is another way of achieving the same, this time we extract the last record regardless of the number of records on input file.

Skolusu · Posted: Fri Mar 30, 2012 10:27 pm

gcicchet,

I would suggest using reporting features TRAILER1 to pick the last record instead of subset as it would need 2 passes of data to get the last record.