2023 2024 EduVark > Education Discussion > General Discussion


  #1  
March 19th, 2017, 05:51 PM
Unregistered
Guest User
 
ICETOOLS z/Os

Hii sir, I Wants to get the Information About the ICETOOL Utility Will you Please provide me the Information About the ICETOO Example ?
  #2  
March 20th, 2017, 08:35 AM
Super Moderator
 
Join Date: Mar 2012
Re: ICETOOLS z/Os

ICETOOL is a multipurpose DFSORT utility that uses the capabilities of DFSORT to perform multiple operations on one or more data sets in a single step.

ICETOOL example contains a complete ICETOOL sample job with all required JCL and control statements

Simple ICETOOL Job
//EXAMP JOB A402,PROGRAMMER
//RUNIT EXEC PGM=ICETOOL,REGION=1024K
//TOOLMSG DD SYSOUT=A
//DFSMSG DD SYSOUT=A
//TOOLIN DD *
* Show installation defaults
DEFAULTS LIST(SHOWDEF)
* Create three copies of a data set
COPY FROM(IN1) TO(OUT1,OUT2,OUT3)
* Print a report
DISPLAY FROM(IN2) LIST(REPORT) DATE TITLE('Monthly Report') PAGE -
HEADER('Location') ON(1,25,CH) -
HEADER('Revenue') ON(23,10,FS) -
HEADER('Profit') ON(45,10,FS) -
TOTAL('Totals') AVERAGE('Averages') BLANK
* Select all records with duplicate (non-unique) keys
SELECT FROM(IN2) TO(DUPKEYS) ON(1,25,CH) ALLDUPS -
* Save all records with non-duplicate (unique) keys
DISCARD (UNQKEYS)
/*
//SHOWDEF DD SYSOUT=A
//IN1 DD DSN=FLY.INPUT1,DISP=SHR
//IN2 DD DSN=FLY.INPUT2,DISP=SHR
//OUT1 DD DSN=FLY.NEW,DISP=OLD
//OUT2 DD DSN=FLY.BU1,DISP=OLD
//OUT3 DD DSN=FLY.BU2,DISP=OLD
//DUPKEYS DD DSN=FLY.DUPS,DISP=OLD
//UNQKEYS DD DSN=FLY.UNQS,DISP=OLD
//REPORT DD SYSOUT=A


Quick Reply
Your Username: Click here to log in

Message:
Options



All times are GMT +5. The time now is 03:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Content Relevant URLs by vBSEO 3.6.0

1 2 3 4 5 6 7 8