This is my first post. I do tried to search the topic i wanted to ask & didn't find exact thing i was looking. Here is my question.
I am using ICETOOL for a file which is having for example 5000 records out of which only 30 records are distinct. Rest all are repetitions. The file is variable length of 4092 & key is starting from 1 byte & 15 in length.
I want a new file to have all records which have repetition more than 139 characters. ICETOOL higher option works only till 99. After it ,gives max cc 0012. I have tried sorkwnn option & dynalloc option as well(which not shown in sample jcl below). None of them worked. So need assistance ...... Thank you in advance!!
"have all records which have repetition more than 139 characters"
Sorry I phrased it wrong .
Here is example what i mean
Input file (First 15 bytes only)
10 times repeated
140 times repeated.
So this record 123456789101112 should be in output file as it qualifies >139 repetitions.
I am not sure if you mean higher option can't work beyond 99. If yes, is there a any other way to get duplicates >139 in a another file.
Joined: 09 Mar 2011 Posts: 7312 Location: Inside the Matrix
A COPY operation in a plain SORT step. Extend the record to contain a sequence-number (large enough for your largest possible number of duplicates (and more)), with a RESTART= for the key value (5,15).
Then an OUTFIL with INCLUDE= (or OMIT=) to get the records you want, with a BUILD to return the record to its original content (drop the sequence-number).
Since you have variable-length records you want to extend at the beginning of the data. Lots of examples here.
Thank You Bill! Appreciate your response.
Here is the thing ... Original files may contain 10 millions records & i am not sure whether sequence (5,15) will repeat or not next time in input. So ideally file is dynamic.
If i am not wrong Outfil(SORT option) with OMIT will need a sequence, which is not fix here.
Hello, updating late.
Kranthi , your sort card has worked perfectly well. Thanks for help!
Initially it was confusing ..but i went through some of some manuals & i was able to get what this CTL2 was doing.