Is it possible thru ICETOOL?



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Is it possible thru ICETOOL?

Postby Gaurav Dhingra » Thu Sep 09, 2010 10:32 pm

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
Gaurav Dhingra
 
Posts: 2
Joined: Thu Sep 09, 2010 10:22 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Is it possible thru ICETOOL?

 

Re: Is it possible thru ICETOOL?

Postby Frank Yaeger » Fri Sep 10, 2010 1:07 am

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
/*
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: Is it possible thru ICETOOL?

Postby Gaurav Dhingra » Fri Sep 10, 2010 9:52 am

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.
Gaurav Dhingra
 
Posts: 2
Joined: Thu Sep 09, 2010 10:22 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Is it possible thru ICETOOL?

Postby Frank Yaeger » Fri Sep 10, 2010 10:50 pm

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
/*
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post