maching of files using ICETOOL



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

Re: maching of files using ICETOOL

Postby pulcinella » Tue Apr 29, 2008 2:01 pm

Thanks Frank, I think that undestand...
But If i want join three files (the third file are 42 position's and the key is the same 12 position (only work with 30 last position because the first 12 are the key), Could i be?...

//STEP032 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD DSN=... input file1
//IN2 DD DSN=... input file2
//IN3 DD DSN=... input file2
//T1 DD DSN=&&T1,UNIT=SYSDA,SPACE=(CYL,(5,5)),DISP=(MOD,PASS)
//OUT DD DSN=... output file
//TOOLIN DD *
COPY FROM(IN1) TO(T1) USING(CTL1)
COPY FROM(IN2) TO(T1) USING(CTL2)
COPY FROM(IN3) TO(T1) USING(CTL3)
SPLICE FROM(T1) TO(OUT) ON(1,12,CH) -
WITH(388,7)
//CTL1CNTL DD *
INREC OVERLAY=(394:X)
//CTL2CNTL DD *
INREC BUILD=(1,12,388:13,7)
//CTL3CNTL DD *
INREC BUILD=(1,12,388:13,7,395:13,30)
/*
pulcinella
 
Posts: 114
Joined: Mon Dec 10, 2007 10:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: maching of files using ICETOOL

Postby Frank Yaeger » Tue Apr 29, 2008 9:26 pm

Taking a quick look, I think you would need to change the SPLICE operator to:

SPLICE FROM(T1) TO(OUT) ON(1,12,CH) -
  WITHEACH WITH(388,7) WITH(395,30)


If that doesn't do it, let me know and I'll take a better look. Some example input and output records would help.
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

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post