Count check in ICETOOL



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

Count check in ICETOOL

Postby vinothrajagopal » Fri Apr 15, 2011 6:12 pm

Data Reference :
* InputDataset1 contains 19070491 records
* InputDataset2 contains 19070491 records

When I execute the below JCL it shows RCD IN 38140982, OUT 38140982 in SPOOL. But I would like to see the record count for the InputDataset1 and InputDataset2 separately. Is it possible? Requesting your help on this.

//PS010    EXEC PGM=ICETOOL                             
//DFSMSG DD SYSOUT=*                                       
//TOOLMSG DD SYSOUT=*                                                                       
//CURRFIL  DD  DSN=InputDataset1,     
//             DISP=SHR                                   
//         DD  DSN=InputDataset2,     
//             DISP=SHR                                   
//OUT      DD  DSN=OutputDataset,     
//             DISP=(,CATLG,DELETE),                       
//             UNIT=SYSDA,                                 
//             SPACE=(CYL,(200,200),RLSE)             
//TOOLIN DD *                 
COPY FROM(CURRFIL) TO(OUT)     
//*


Thanks,
Vinoth R
vinothrajagopal
 
Posts: 4
Joined: Mon Apr 11, 2011 12:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Count check in ICETOOL

Postby Frank Yaeger » Fri Apr 15, 2011 8:49 pm

When you concatenate input data sets, DFSORT does not count the records separately. However, you could COPY each data set separately to a MOD output data set to get the separate record counts. For example:

//PS010    EXEC PGM=ICETOOL                             
//DFSMSG DD SYSOUT=*                                       
//TOOLMSG DD SYSOUT=*                                                                       
//IN1  DD  DSN=InputDataset1,     
//      DISP=SHR                                   
//IN2   DD  DSN=InputDataset2,     
//       DISP=SHR                                   
//OUT      DD  DSN=OutputDataset,     
//             DISP=(MOD,CATLG,DELETE),                       
//             UNIT=SYSDA,                                 
//             SPACE=(CYL,(200,200),RLSE)             
//TOOLIN DD *                 
COPY FROM(IN1) TO(OUT)     
COPY FROM(IN2) TO(OUT)
//*


Of course, if you just want to get the record counts without copying the input data sets to an output data set, COUNT operators would be a better choice than COPY operators.
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