MVSFORUMS.com

[Frank Yaeger]

You were very close - you only missed one required change:

[eskaysem]

Thanks Frank for the reply. I just got another problem with it. There are a few reocrds in the dataset that have no change in the date fields for ex:
P1V1C1D1
P1V1C1D2
P2V1C1D1
P3V1C1D1
P3V1C1D2

now since, Key P2 doenot have another date(D2), he grouping is getting wrong. So we need to ignore those records.
So in this case my output should be like

File1:

P1V1C1D1
P3V1C1D1

File 2:
P1V1C1D2
P3V1C1D2


Please help me to get a logic to ignore any kind of records where the P* Key(12 byte wide) doenot have a break in the date key D*(2 byte number), then we need to ignore those records.
_________________
Thanks!,
Santosh Kulkarni

[Frank Yaeger]

If I understand you correctly, you want to remove records with a unique Px field (e.g. only one P2 record). You can use DFSORT/ICETOOL to put only the dup records in a temporary file and then use that temporary file as input to your existing COPY.

[eskaysem]

To elaborate it furthur I would say, there could be multiple P2 records, but can have same dates.
For ex:
P1V1C1D1
P1V1C1D2
P2V1C1D1
P2V1C2D1
P2V2C1D1
P3V1C1D1
P3V1C1D2

Since there is no variation on P2-D1 combination, we should see the above said result.

Thanks!
_________________
Thanks!,
Santosh Kulkarni