IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

ICETOOL question:More then one input


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Fri Jun 24, 2005 9:32 pm
Reply with quote

There's a way to sort from two or more input dataset in ICETOOL without using concatenation and disposition MOD in Output?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Jun 28, 2005 2:18 am
Reply with quote

Concatenation is the way to sort from two or more input data sets with DFSORT's ICETOOL. You do NOT need DISP=MOD in the output, e..g

Code:

//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=...  input file1
//    DD DSN=...  input file2
//OUT DD DISP=(NEW,CATLG,DELETE),DSN=...
//TOOLIN DD *
  SORT FROM(IN) TO(OUT) USING(CTL1)
/*
//CTL1CNTL DD *
  SORT FIELDS=(...)
/*


What are you trying to do that prevents you from using concatenation?
Back to top
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Tue Jun 28, 2005 3:17 pm
Reply with quote

Ok, but is not what I need.
If in ICETOOL i have 1 input that produce 2 output and then I want to produce a third output from the two previous output(in the same ICETOOL)... how can I do this?
In all the sample of ICETOOL in this forum and in the manual I saw only output in append mode(MOD) for my situation but this kind of work has some difficult in the practice.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Jun 28, 2005 10:15 pm
Reply with quote

Are you talking about something like this?

Code:

//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN DD DSN=...   input file
//T1 DD DSN=&&T1,UNIT=SYSDA,SPACE=(CYL,(5,5)),DISP=(,PASS)
//T2 DD DSN=&&T2,UNIT=SYSDA,SPACE=(CYL,(5,5)),DISP=(,PASS)
//CON DD DSN=*.T1,VOL=REF=*.T1,DISP=(OLD,PASS)   
//    DD DSN=*.T2,VOL=REF=*.T2,DISP=(OLD,PASS) 
//OUT DD DSN=...  output file
//TOOLIN DD *
   COPY FROM(IN) USING(CTL1)
   COPY FROM(CON) TO(OUT) USING(CTL2)
/*
//CTL1CNTL DD *
   OUTFIL FNAMES=T1,INCLUDE=(...)
   OUTFIL FNAMES=T2,INCLUDE=(...)
/*
//CTL2CNTL DD *
   ...
/*


This will work providing you don't violate the system restriction of using multivolume data sets for T1 and T2. If you do violate that system restriction, then you won't get all of the records in OUT.

If this is not what you're talking about, then you need to explain clearly with an example what it is you're trying to do.
Back to top
View user's profile Send private message
MGIndaco

Active User


Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy

PostPosted: Tue Jun 28, 2005 10:35 pm
Reply with quote

Yes is what I need but this kind of restriction ends my search.
It's a very interesting sample...congrats!
And I'm sure that in the future, this sample will be useful.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts TRIM everything from input, output co... DFSORT/ICETOOL 1
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Shift left VB record without x00 endi... DFSORT/ICETOOL 11
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
Search our Forums:

Back to Top