ICETOOL using, but got no result, RC=0



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

ICETOOL using, but got no result, RC=0

Postby mapleleaf35 » Fri Dec 04, 2009 9:46 pm

I just try to use ICETOO to SELECT data from file1 to file2. when I sub the jcl, get return code with 0, but i can't find any result from log or the output file. alas.

//USER989 JOB (USER989),'RUN SELECT',CLASS=2,MSGCLASS=H,NOTIFY=&SYSUID   
//STEP1  EXEC PGM=ICETOOL                                               
//TOOLMSG DD SYSOUT=*                                                 
//DFSMSG DD SYSOUT=*                                                 
//IN1 DD DSN=USER989.TEST.MY(INFILE1),DISP=SHR                           
//OUT1 DD DSN=USER989.TEST.MY(OUTPF),SPACE=(CYL,(5,5)),
//   DISP=(MOD,CATLG,DELETE)                                                             
//TOOLIN DD                 
 SELECT FROM(IN1) TO(OUT1) ON(1,10,CH) FIRST                       
/*                                                                   



COMMAND INPUT ===> SCROLL ===> PAGE
ICE600I 0 DFSORT ICETOOL UTILITY RUN STARTED

ICE650I 0 VISIT http://www.ibm.com/storage/dfsort FOR ICETOOL PAPERS, EXAMPLES

ICE632I 0 SOURCE FOR ICETOOL STATEMENTS: TOOLIN


ICE630I 0 MODE IN EFFECT: STOP


ICE601I 0 DFSORT ICETOOL UTILITY RUN ENDED - RETURN CODE: 00
mapleleaf35
 
Posts: 5
Joined: Fri Dec 04, 2009 9:25 pm
Has thanked: 0 time
Been thanked: 0 time

Re: ICETOOL using, but got no result, RC=0

Postby Frank Yaeger » Fri Dec 04, 2009 10:02 pm

//TOOLIN DD                 
SELECT FROM(IN1) TO(OUT1) ON(1,10,CH) FIRST                       
/*               


Try

//TOOLIN DD *
SELECT FROM(IN1) TO(OUT1) ON(1,10,CH) FIRST                       
/*               


I get a JCL error when I don't have the *, but perhaps you're getting further than that for some reason. At any rate, it appears that without the *, your TOOLIN is empty.
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: ICETOOL using, but got no result, RC=0

Postby mapleleaf35 » Fri Dec 04, 2009 10:23 pm

ah, yes, 3x. but may i have another quetions? If i wrote code like below, can it be possible that get RC=0,But the OUT1 doesn't contain all expected data? in which situation? thanks in advance.
//STEP1 EXEC PGM=ICETOOL                         
//TOOLMSG DD SYSOUT=*                         
//DFSMSG DD SYSOUT=*                         
//IN1 DD DSN=USER989.TEST.FILE1,DISP=SHR                 
//IN2 DD DSN=USER989.TEST.FILE2,DISP=SHR                 
//OUT1 DD DSN=USER989.TEST.OUT1,UNIT=SYSDA,SPACE=(CYL,(5,5)),
//   DISP=(MOD,CATLG,DELETE)                   
//TOOLIN DD *                                 
SELECT FROM(IN1) TO(OUT1) ON(1,5,CH) FIRST     
SELECT FROM(IN2) TO(OUT1) ON(1,5,CH) FIRST     
/*
mapleleaf35
 
Posts: 5
Joined: Fri Dec 04, 2009 9:25 pm
Has thanked: 0 time
Been thanked: 0 time

Re: ICETOOL using, but got no result, RC=0

Postby Frank Yaeger » Fri Dec 04, 2009 11:09 pm

If i wrote code like below, can it be possible that get RC=0,But the OUT1 doesn't contain all expected data? in which situation?


If you get RC=0, then DFSORT/ICETOOL did what you told it do to do. If your OUT1 did not contain all expected data, then you most likely didn't tell DFSORT/ICETOOL to do what you wanted done. Since I don't know what your input or output contained, I can't tell you what you did wrong.

One common error is when you have RECFM=VB but you use position 1 as the starting position instead of position 5. For a VB record, positions 1-4 have the RDW, so the data starts in position 5, not position 1. But that's just one possibility.

If you want more help on this, show an example of the records in your input files (relevant fields only), what you got for output, and what you expected for output. Give the RECFM and LRECL of your input files.
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


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post