INCLUDE COND parameters from a dataset.

jithumohan · Posted: Tue Apr 15, 2008 11:23 am

Hi,

Can we get the include condition parameters ('1234567') from a dataset?

SORT FIELDS=COPY
INCLUDE COND=(1,6,CH,EQ,C'1234567')

In the above example I have the data '1234567' in a dataset and I need to extract records from another dataset based on this parameter (Which is in first dataset).

In my case the first dataset have 1 lakh records. I need to automate this using a sort. Can we do this using SORT/ICETOOL or any other utility.

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

can you post a few records of input and expected output

jithumohan · Posted: Tue Apr 15, 2008 12:48 pm

Thanks for the response

First file(key file): LRECL = 12
YYYYYCCCCCCC
CCCC1234567
OOOOCCCCCCC

Second file (input file): (Matching record 9:12)
RRRR1234OOOOCCCCCCC
RYYR1234OOOyy999999
BBBB1234YYYYYCCCCCCC
UUUU1234CCCC1234567
RRRR1234OOOO9kk9999
RRRR1234OOOOCCCCCCC
BBBB1234CCCC1234567
UUUU1234YYYYYCCCCCC
RRRR1234OOOO9999999
88888888OOOOCCCCCCC

Output file records should be as follows.

RRRR1234OOOOCCCCCCC
BBBB1234YYYYYCCCCCCC
UUUU1234CCCC1234567
RRRR1234OOOOCCCCCCC
BBBB1234CCCC1234567
UUUU1234YYYYYCCCCCC

Could you please let me know if you have any doubts.

expat · Posted: Tue Apr 15, 2008 12:57 pm

Take a look at the ICETOOL SELECT parameter, although you may have to reformat the records of one file to ensure that the two keys have a matching location.

I do have an example somewhere, and will try to find it later if I get time, although there are many examples in the forum already.

Frank Yaeger · Posted: Tue Apr 15, 2008 9:33 pm

Jithu,

Here's a DFSORT/ICETOOL job that will do what you asked for using SPLICE:

Frank Yaeger · Posted: Tue Apr 15, 2008 9:35 pm