Help Required in ICETOOL



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

Help Required in ICETOOL

Postby sultanabdulkadhar » Thu Jul 09, 2009 7:54 pm

I have 2 input files with different lengths. 1 file is a master file and contains 15 Million records with 18K Record length and second file is 14bytes length and it contains 1 Million records.

Now i want get the records from master file based on the value present in the Second file. the matching based on 14bytes of the both files.

i have tried with ICETOOL include condtion. it failed and thrown an error too many include condtions.

Sultan
sultanabdulkadhar
 
Posts: 19
Joined: Tue Jul 07, 2009 9:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help Required in ICETOOL

Postby Frank Yaeger » Thu Jul 09, 2009 8:17 pm

Please show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and format of each relevant field. Give the RECFM and LRECL of the input files. If file1 can have duplicates within it, show that in your example. If file2 can have duplicates within it, show that in your example.
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: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Help Required in ICETOOL

Postby sultanabdulkadhar » Thu Jul 09, 2009 8:34 pm

Thanks for your reply.

This is the detail about master file - 18,000Bytes(with Duplicates) RECFM FB, LRECL = 18000

09171123456ABCXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
09171123456ABCXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
09171123456DEFXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
09171123456GHIXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
09171123456GHIXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
09171123456JKLXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
09171123456MNOXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Second file - 14 Bytes length (No Duplicates) RECFM FB, LRECL = 14
09171123456ABC
09171123456DEF
09171123456JKL
09171123456GHI
09171123456MNO

The output file should be 18,000Bytes - Records from the Master file (unique records) No Duplicates- RECFM FB, LRECL = 18000

09171123456ABCXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
09171123456DEFXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
09171123456GHIXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
09171123456JKLXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
09171123456MNOXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Starting position is 1, Lenght of the field os 14. format of field is character.
sultanabdulkadhar
 
Posts: 19
Joined: Tue Jul 07, 2009 9:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help Required in ICETOOL

Postby Frank Yaeger » Thu Jul 09, 2009 9:20 pm

Are the records in each file already in sorted order by positions 1-14 as shown in your example?

For duplicate records in file2 with a match in file1, do you want the first file2 record of the duplicates, or the last file2 record of the duplicates, or can it be any file2 record of the duplicates?

In your example, every record in file1 has a match in file2. Is it possible for a record in file1 to have no match in file2? Is it possible for a record in file2 to have no match in file1? If so, please show a better example including these variations.
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: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Help Required in ICETOOL

Postby sultanabdulkadhar » Thu Jul 09, 2009 9:36 pm

I would say that

The records in file2(Base File) is NOT SORTED. But File2 is SORTED by 1-14.

For duplicate records in file2- i want last file2 record of the duplicate.

there is a possible record in file1 to have no match in file2.

My main concern that i should get the records in file2 from file1 based on 1-14.
sultanabdulkadhar
 
Posts: 19
Joined: Tue Jul 07, 2009 9:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help Required in ICETOOL

Postby Frank Yaeger » Fri Jul 10, 2009 1:34 am

The records in file2(Base File) is NOT SORTED. But File2 is SORTED by 1-14.


Huh? The first sentence says the records in File2 are not sorted. The second sentence says the records in File2 are sorted. Which is it? And what about File1?
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: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Help Required in ICETOOL

Postby sultanabdulkadhar » Fri Jul 10, 2009 4:01 pm

Sorry for that, That was typo.


The records in file1(Base File) is NOT SORTED. But File2 is SORTED by 1-14.
sultanabdulkadhar
 
Posts: 19
Joined: Tue Jul 07, 2009 9:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help Required in ICETOOL

Postby Frank Yaeger » Fri Jul 10, 2009 9:06 pm

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

//S1   EXEC  PGM=ICETOOL
//TOOLMSG   DD  SYSOUT=*
//DFSMSG    DD  SYSOUT=*
//IN1 DD DSN=... input file1 (FB/18000)
//IN2 DD DSN=... input file2 (FB/14)
//T1 DD DSN=&&T1,UNIT=SYSDA,SPACE=(CYL,(5,5)),DISP=(MOD,PASS)
//OUT DD DSN=...  output file (FB/18000)
//TOOLIN DD *
COPY FROM(IN2) TO(T1) USING(CTL1)
COPY FROM(IN1) TO(T1) USING(CTL2)
SPLICE FROM(T1) TO(OUT) ON(1,14,CH) WITH(1,18001) USING(CTL3)
/*
//CTL1CNTL DD *
  INREC OVERLAY=(18001:C'BB')
/*
//CTL2CNTL DD *
  INREC OVERLAY=(18001:C'VV')
/*
//CTL3CNTL DD *
  OUTFIL FNAMES=OUT,INCLUDE=(18001,2,CH,EQ,C'VB'),
    BUILD=(1,18000)
/*
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: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Help Required in ICETOOL

Postby sultanabdulkadhar » Mon Jul 13, 2009 8:43 pm

Hi,

I tried with ablove code. its given error code 16.

SPLICE FROM(T1) TO(OUT) ON(1,14,CH) WITH(1,18001) USING(CTL3)
DFSORT CALL 0003 FOR SORT FROM T1 TO OUT USING CTL3CNTL TERMINATED
OPERATION RETURN CODE: 16


Please advice

Thanks,
Sultan
sultanabdulkadhar
 
Posts: 19
Joined: Tue Jul 07, 2009 9:33 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Help Required in ICETOOL

Postby Frank Yaeger » Mon Jul 13, 2009 8:48 pm

You need to show the complete JES output, including all of the TOOLMSG and DFSMSG messages.
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: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Next

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post