Require help with sequence number

mohitsaini · New User Joined: 15 May 2006 Posts: 92

Hi,

Actually, my requirement is to put sequence number at a particular position based on record type. It is a variable lenght file.

TYPE --- Position for Sequnce number (8)
--------- -----------------------------
1644 --- 107
1240 --- 689
1540 --- 151
1740 --- 179

I tried doing it (only for 2 rec types) and below is my attempt:

Bill Woodger · Posted: Tue Apr 17, 2012 11:52 am

Every time you use SEQNUM it is a different one.

So, if you have SEQNUM on WHEN=INIT, inserted at the beginning of your records (because your records are variable) (unless there is an "unused" portion of the fixed part of the record you could re-use temporarily) and then with the WHEN=(condition) copy the added field to where you want it for that particular record-type.

After each record is processed, you have to "clean up" the now surplus SEQNUM, with BUILD,

nagaraj_bez · New User Joined: 09 Jun 2005 Posts: 10

Hi Mohitsaini,

Try the following steps.
Step-1: Number all records
Step-2: using overlay as u have tried, write the output record based on conditions.

Example:
input :
1234561240
1234561644
expected output :
add seq number in 7th position( before 1240) for 1240, 11th position(after 1644) for 1644 condition

123456000000011240
123456164400000002

Step1 o/p : (added seq number at starting 1-8 position)
000000011234561240
000000021234561644

Step2 o/p: based on condition
123456000000011240
123456164400000002

Skolusu · Posted: Tue Apr 17, 2012 9:49 pm

mohitsaini,

Use the following DFSORT JCL which will give you the desired results.

mohitsaini · New User Joined: 15 May 2006 Posts: 92

Thanks it is working . ..