Need help in sequence number for removing column duplicates

jemonthomas · New User Joined: 24 Jul 2006 Posts: 35 Location: india

Hi.

I am trying to remove column duplicates by giving sequence number and reformatting based on that.

INREC BUILD=(1,8,X,10,119,X,131:SEQNUM,3,ZD,RESTART=(1,8))
SORT FIELDS=(1,8,CH,A)
OUTREC IFTHEN=(WHEN=(133,1,ZD,EQ,1),BUILD=(1,133)),
IFTHEN=(WHEN=(133,1,ZD,NE,1),OVERLAY=(1:9X,10:10,124))

This is the code I am using.The problem is that the sequence number is not coming properly so the result is not coming as expected.Could anyone help on this?

saiprasadh · Active User Joined: 20 Sep 2006 Posts: 154 Location: US

Hi jemonthomas,

As per you sort card the sequence number starts from 131 position but you are validating only 133 position . Please use below mentioned sort card and validate your result.

jemonthomas · New User Joined: 24 Jul 2006 Posts: 35 Location: india

Hi saiprasadh

Thanks.But still I am facing the same issue.The sequence number is getting restarted from 1 eventhough the key is not changed.I need to restart the sequence number only if the key is changed which is first 8 bytes.Could you please help on this?

Bill Woodger · Posted: Mon Jan 23, 2012 1:13 pm

If you are using INREC to put your sequence number on, then it is the unsorted file that you are using - which is the reason you notice something is not working. Change it so that it is with the OUTREC,

As saiprasadh has pointed out, you are not looking at the whole seqence number. This will cause you to think that every 10th record is a "new" sequence.

Skolusu · Posted: Mon Jan 23, 2012 9:48 pm

Jemonthomas,

As bill explained your INREC is processed before the SORT. So if your data is unsorted on the Key , then your Sequence number will not be correct.

Check this link which explains how DFSORT process the control cards.

DFSORT Processing

Use the following Control cards which will give you the desired results. I assumed that your input is FB 133 byte