Page 1 of 1

Is it possible thru ICETOOL?

PostPosted: Thu Sep 09, 2010 10:32 pm
by Gaurav Dhingra
Hi guys..
here's the issue i am facing..

i have 2 files..
first file (f1) data is somewhat like this.
<----><-----> (2 fields of 5 byte each)
1234599999

2nd file (f2)
<----><----><->(3 fields of 5 5 and 3 byte respectively)
xxxxx12345abc
xxxxx12345pqr
qwers12345xyz
qweds33333abx
qweda44444acv


now i want to compare these 2 files with 1st 5 bytes of f1 and 6-10 byte of f2.
if the record matches than rite it in the output file.(for every 1 record in f1 there is a possibilty of multiple records in f2 as shown in the above example, so all needs to be updated with the another number present in f2)
and my output file f3 shd be something like that.

xxxxx99999abc
xxxxx99999pqr
qwers99999xyz
qweds33333abx
qweda44444acv

i know its possible thru splice but not able to figure it out exactly..

thanks

Re: Is it possible thru ICETOOL?

PostPosted: Fri Sep 10, 2010 1:07 am
by Frank Yaeger
Is there always only one record in f1? If not, can there be duplicates in f1? Show a better example with more records in f1, including duplicates, if that's possible.

Are the records in f1 already in order by the key (1-5)?

Are the records in f2 already in order by the key (6-10)?

What is the RECFM and LRECL of each input file?

Run this job and show the //SYSOUT messages you receive, so I can see what level you're at:

//S1    EXEC  PGM=SORT
//SYSOUT    DD  SYSOUT=*
//SORTIN DD *
RECORD
//SORTOUT DD DUMMY
//SYSIN    DD    *
    OPTION COPY
/*

Re: Is it possible thru ICETOOL?

PostPosted: Fri Sep 10, 2010 9:52 am
by Gaurav Dhingra
F1 will not have duplicate records.its a FB with 10bytes of LRECL
Comprehensive F1 data will be and yes they will be in sorted order.
1234599999
4545478788
5855841265

File F2 is a VSAM file wherein first 5bytes(xxxx as shown in data is the key) will be the key part whereas 6-10 is the one we need for comparision.(and they might/might not be in order).
LRECL for F2 =13bytes its a VB.

Re: Is it possible thru ICETOOL?

PostPosted: Fri Sep 10, 2010 10:50 pm
by Frank Yaeger
Comprehensive F1 data will be


I have no idea what you mean by this. (Sounds like something Yoda would say :-))

File F2 is a VSAM file ... LRECL for F2 =13bytes its a VB.


Does every record of the VSAM data set have 13 bytes? (If so, we can treat it as TYPE=F.)

Again:

Run this job and show the //SYSOUT messages you receive, so I can see what level you're at:

//S1    EXEC  PGM=SORT
//SYSOUT    DD  SYSOUT=*
//SORTIN DD *
RECORD
//SORTOUT DD DUMMY
//SYSIN    DD    *
    OPTION COPY
/*