08/12/15

Entendendo Sobre JCL - Utilitário ICETOOL

ICETOOL é um utilitário multiuso DFSORT que utiliza as capacidades do DFSORT para realizar várias operações em um ou mais datasets num único passo. Este exemplo de ICETOOL quero classificar os dados de um dataset da coluna 1 até 7 para checar se tem registro duplicado, o resultado vamos gravar em dois datasets diferente (registros dulplicados e regristros não duplicados).

   File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help

 EDIT       ADCD.LIB.JCL(ICETOOL) - 01.04                   Columns 00001 00072
 Command ===>                                                  Scroll ===> CSR
 ****** ***************************** Top of Data ******************************
 000001 //ICETOOL    JOB (72,FB3),ICHMIN00,COND=(0,NE),
 000002 //      CLASS=A,MSGCLASS=H,NOTIFY=IBMUSER
 000003 //* -------------------------------------------------------
 000004 //* RETAIN THE DUPLICATE RECORDS WITH OUT USING XSUM FETURE
 000005 //* -------------------------------------------------------
 000006 //STEP001  EXEC PGM=ICETOOL
 000007 //IN       DD *
 000008 AAAAA01    - REGISTRO DUPLICADO
 000009 AAAAA02    - REGISTRO DUPLICADO
 000010 BBBBB01    - REGISTRO DUPLICADO
 000011 AAAAA01    - REGISTRO DUPLICADO
 000012 AAAAA02    - REGISTRO DUPLICADO
 000013 AAAAA03    - NAO REPETE
 000014 BBBBB01    - REGISTRO DUPLICADO
 000015 BBBBB02    - NAO REPETE
 000016 /*
 000017 //OUT      DD  DSN=ICETOOL.OUT,DISP=(,CATLG,DELETE),
 000018 //         VOL=SER=ZADB82,SPACE=(CYL,(1,1)),UNIT=SYSDA,
 000019 //         DCB=(RECFM=FB,BLKSIZE=0,LRECL=40,DSORG=PS)
 000020 //DUPS     DD  DSN=ICETOOL.DUPS,DISP=(,CATLG,DELETE),
 000021 //         VOL=SER=ZADB82,SPACE=(CYL,(1,1)),UNIT=SYSDA,
 000022 //         DCB=(RECFM=FB,BLKSIZE=0,LRECL=40,DSORG=PS)
 000023 //TOOLMSG  DD SYSOUT=*
 000024 //DFSMSG   DD SYSOUT=*
 000025 //TOOLIN   DD *
 000026   SELECT FROM(IN) TO(OUT) ON(1,7,CH) DISCARD(DUPS) ALLDUPS
 000027 /*
 ****** **************************** Bottom of Data ****************************
Vamos ver o resultado do job que rodamos;
   Menu  Utilities  Compilers  Options  Status  Help

                            ISPF Primary Option Menu

 0  Settings      Terminal and user parameters            User ID . : ADCDMST
 1  View          Display source data or listings         Time. . . : 21:02
 2  Edit          Create or change source data            Terminal. : 3278
 3  Utilities     Perform utility functions               Screen. . : 1
 4  Foreground    Interactive language processing         Language. : ENGLISH
 5  Batch         Submit job for language processing      Appl ID . : ISR
 6  Command       Enter TSO or Workstation commands       TSO logon : ISPFPROC
 7  Dialog Test   Perform dialog testing                  TSO prefix: ADCDMST
 9  IBM Products  IBM program development products        System ID : ADCD
 10 SCLM          SW Configuration Library Manager        MVS acct. : ACCT#
 11 Workplace     ISPF Object/Action Workplace            Release . : ISPF 6.0
 M  More          Additional IBM Products


      Enter X to Terminate using log/list defaults


 Option ===> m
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=Actions  F12=Cancel
Opção 5 (enter) - SDSF;
   Menu  Help
 ------------------------------------------------------------------------------
                            IBM Products Panel

 1  SMP/E       System Modification Program/Extended
 2  ISMF        Integrated Storage Management Facility
 3  RACF        Resource Access Control Facility
 4  HCD         Hardware Configuration Dialogs
 5  SDSF        Spool Search and Display Facility
 6  IPCS        Interactive Problem Control System
 7  DITTO       DITTO/ESA for MVS Version 1
 8  RMF         Resource Measurement Facility
 10 OMVS        MVS OpenEdition
 11 RRS         Resource Recovery Services
 12 MQ          WMQ Series Operations and Control
 13 FMN         File Manager 3.1.0perations and Control
 14 WLM         Workload Manager




 Option ===> 5
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=Actions  F12=Cancel
Vamos ver o resultado do job - opção st (enter);
   Display  Filter  View  Print  Options  Help
 -------------------------------------------------------------------------------
 HQX7750 -----------------  SDSF PRIMARY OPTION MENU  --------------------------

 DA    Active users                      INIT  Initiators
 I     Input queue                       PR    Printers
 O     Output queue                      PUN   Punches
 H     Held output queue                 RDR   Readers
 ST    Status of jobs                    LINE  Lines
                                         NODE  Nodes
 LOG   System log                        SO    Spool offload
 MAS   Members in the MAS
 JC    Job classes                       ULOG  User session log
 SE    Scheduling environments
 RES   WLM resources

 Licensed Materials - Property of IBM

 5694-A01 Copyright IBM Corp. 1981, 2008. All rights reserved.
 US Government Users Restricted Rights - Use, duplication or
 disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
 COMMAND INPUT ===> ST                                         SCROLL ===> PAGE
  F1=HELP      F2=SPLIT     F3=END       F4=RETURN    F5=IFIND     F6=BOOK
  F7=UP        F8=DOWN      F9=SWAP     F10=LEFT     F11=RIGHT    F12=RETRIEVE
Vamos digitar FIND ICETOOL (para ir direto ao nosso job)
   Display  Filter  View  Print  Options  Help
 -------------------------------------------------------------------------------
 SDSF STATUS DISPLAY ALL CLASSES                        LINE 1-17 (78)
 NP   JOBNAME  JobID    Owner    Prty Queue      C  Pos  SAff  ASys Status
      IBMUSER  TSU00199 IBMUSER    15 EXECUTION          SYS1  SYS1
      ADCDMST  TSU00215 ADCDMST    15 EXECUTION          SYS1  SYS1
      SYSLOG   STC00174 +MASTER+   15 EXECUTION          SYS1  SYS1
      VTAM     STC00175 START1     15 EXECUTION          SYS1  SYS1
      ZFS      STC00176 ++++++++   15 EXECUTION          SYS1  SYS1
      INIT     STC00178 START2     15 EXECUTION          SYS1  SYS1
      INIT     STC00179 START2     15 EXECUTION          SYS1  SYS1
      INIT     STC00180 START2     15 EXECUTION          SYS1  SYS1
      INIT     STC00181 START2     15 EXECUTION          SYS1  SYS1
      INIT     STC00182 START2     15 EXECUTION          SYS1  SYS1
      INIT     STC00183 START2     15 EXECUTION          SYS1  SYS1
      INIT     STC00184 START2     15 EXECUTION          SYS1  SYS1
      INIT     STC00185 START2     15 EXECUTION          SYS1  SYS1
      INIT     STC00186 START2     15 EXECUTION          SYS1  SYS1
      INIT     STC00187 START2     15 EXECUTION          SYS1  SYS1
      RACF     STC00188 START2     15 EXECUTION          SYS1  SYS1
      TSO      STC00189 START1     15 EXECUTION          SYS1  SYS1
 COMMAND INPUT ===> FIND ICETOOL                               SCROLL ===> PAGE
  F1=HELP      F2=SPLIT     F3=END       F4=RETURN    F5=IFIND     F6=BOOK
  F7=UP        F8=DOWN      F9=SWAP     F10=LEFT     F11=RIGHT    F12=RETRIEVE
Vamos acessar ele (s) enter;
   Display  Filter  View  Print  Options  Help
 -------------------------------------------------------------------------------
 SDSF STATUS DISPLAY ALL CLASSES                         CHARS 'ICETOOL' FOUND
 NP   JOBNAME  JobID    Owner    Prty Queue      C  Pos  SAff  ASys Status
 s    ICETOOL  JOB00217 IBMUSER     1 PRINT      A
      $MASCOMM STC00001 START1     15 PRINT
      SYSLOG   STC00002 +MASTER+    1 PRINT
      TSO      STC00017 START1      1 PRINT
      SDSF     STC00019 START2      1 PRINT
      TCPIP    STC00021 TCPIP       1 PRINT
      HTTPD1   STC00023 WEBSRV      1 PRINT
      NFSS     STC00024 START1      1 PRINT
      CSQ7MSTR STC00026 START2      1 PRINT
      PORTMAP  STC00037 START2      1 PRINT
      CICSA    STC00039 START2      1 PRINT
      SYSLOG   STC00041 +MASTER+    1 PRINT
      TSO      STC00056 START1      1 PRINT
      SDSF     STC00057 START2      1 PRINT
      TCPIP    STC00061 TCPIP       1 PRINT
      HTTPD1   STC00062 WEBSRV      1 PRINT
      NFSS     STC00063 START1      1 PRINT
 COMMAND INPUT ===>                                            SCROLL ===> PAGE
  F1=HELP      F2=SPLIT     F3=END       F4=RETURN    F5=IFIND     F6=BOOK
  F7=UP        F8=DOWN      F9=SWAP     F10=LEFT     F11=RIGHT    F12=RETRIEVE
Vamos ver o resultado, rodou ok;
   Display  Filter  View  Print  Options  Help
 -------------------------------------------------------------------------------
 SDSF OUTPUT DISPLAY ICETOOL  JOB00217  DSID     2 LINE 0       COLUMNS 02- 81
 COMMAND INPUT ===>                                            SCROLL ===> PAGE
********************************* TOP OF DATA **********************************
                         J E S 2  J O B  L O G  --  S Y S T E M  S Y S 1  --  N

20.51.57 JOB00217 ---- TUESDAY,   08 DEC 2015 ----
20.51.57 JOB00217  IRR010I  USERID IBMUSER  IS ASSIGNED TO THIS JOB.
20.51.58 JOB00217  ICH70001I IBMUSER  LAST ACCESS AT 20:28:27 ON TUESDAY, DECEMB
20.51.58 JOB00217  $HASP373 ICETOOL  STARTED - INIT 1    - CLASS A - SYS SYS1
20.51.58 JOB00217  IEF403I ICETOOL - STARTED - TIME=20.51.58
20.52.00 JOB00217  IEF404I ICETOOL - ENDED - TIME=20.52.00
20.52.00 JOB00217  $HASP395 ICETOOL  ENDED
------ JES2 JOB STATISTICS ------
  08 DEC 2015 JOB EXECUTION DATE
           27 CARDS READ
          133 SYSOUT PRINT RECORDS
            0 SYSOUT PUNCH RECORDS
            8 SYSOUT SPOOL KBYTES
         0.04 MINUTES EXECUTION TIME
        1 //ICETOOL    JOB (72,FB3),ICHMIN00,COND=(0,NE),
          //      CLASS=A,MSGCLASS=H,NOTIFY=IBMUSER
          //* -------------------------------------------------------
          //* RETAIN THE DUPLICATE RECORDS WITH OUT USING XSUM FETURE
          //* -------------------------------------------------------
        2 //STEP001  EXEC PGM=ICETOOL
        3 //IN       DD *
        4 //OUT      DD  DSN=ICETOOL.OUT,DISP=(,CATLG,DELETE),
          //         VOL=SER=ZADB82,SPACE=(CYL,(1,1)),UNIT=SYSDA,
          //         DCB=(RECFM=FB,BLKSIZE=0,LRECL=40,DSORG=PS)
        5 //DUPS     DD  DSN=ICETOOL.DUPS,DISP=(,CATLG,DELETE),
          //         VOL=SER=ZADB82,SPACE=(CYL,(1,1)),UNIT=SYSDA,
          //         DCB=(RECFM=FB,BLKSIZE=0,LRECL=40,DSORG=PS)
        6 //TOOLMSG  DD SYSOUT=*
        7 //DFSMSG   DD SYSOUT=*
        8 //TOOLIN   DD *
ICH70001I IBMUSER  LAST ACCESS AT 20:28:27 ON TUESDAY, DECEMBER 8, 2015
IEF236I ALLOC. FOR ICETOOL STEP001
IEF237I JES2 ALLOCATED TO IN
IGD100I 0A84 ALLOCATED TO DDNAME OUT      DATACLAS (        )
IGD100I 0A84 ALLOCATED TO DDNAME DUPS     DATACLAS (        )
IEF237I JES2 ALLOCATED TO TOOLMSG
IEF237I JES2 ALLOCATED TO DFSMSG
IEF237I JES2 ALLOCATED TO TOOLIN
IGD100I VIO ALLOCATED TO DDNAME SORTWK01 DATACLAS (        )
IEF285I   SYS15342.T205158.RA000.ICETOOL.R0100021      DELETED
IGD100I VIO ALLOCATED TO DDNAME SORTWK01 DATACLAS (        )
IGD100I VIO ALLOCATED TO DDNAME SORTWK02 DATACLAS (        )
IEF285I   SYS15342.T205159.RA000.ICETOOL.R0100022      DELETED
IGD100I VIO ALLOCATED TO DDNAME SORTWK02 DATACLAS (        )
IGD100I VIO ALLOCATED TO DDNAME SORTWK03 DATACLAS (        )
IEF285I   SYS15342.T205159.RA000.ICETOOL.R0100023      DELETED
IGD100I VIO ALLOCATED TO DDNAME SORTWK03 DATACLAS (        )
IGD100I VIO ALLOCATED TO DDNAME SORTWK04 DATACLAS (        )
IEF285I   SYS15342.T205159.RA000.ICETOOL.R0100024      DELETED
IGD100I VIO ALLOCATED TO DDNAME SORTWK04 DATACLAS (        )
IEF285I   SYS15342.T205158.RA000.ICETOOL.SORTWK01.H01  DELETED
IEF285I   SYS15342.T205159.RA000.ICETOOL.SORTWK02.H01  DELETED
IEF285I   SYS15342.T205159.RA000.ICETOOL.SORTWK03.H01  DELETED
IEF285I   SYS15342.T205159.RA000.ICETOOL.SORTWK04.H01  DELETED
IEF142I ICETOOL STEP001 - STEP WAS EXECUTED - COND CODE 0000
IEF285I   IBMUSER.ICETOOL.JOB00217.D0000101.?          SYSIN
IEF285I   ICETOOL.OUT                                  CATALOGED
IEF285I   VOL SER NOS= ZADB82.
IEF285I   ICETOOL.DUPS                                 CATALOGED
IEF285I   VOL SER NOS= ZADB82.
IEF285I   IBMUSER.ICETOOL.JOB00217.D0000103.?          SYSOUT
IEF285I   IBMUSER.ICETOOL.JOB00217.D0000104.?          SYSOUT
IEF285I   IBMUSER.ICETOOL.JOB00217.D0000102.?          SYSIN
IEF373I STEP/STEP001 /START 2015342.2051
IEF374I STEP/STEP001 /STOP  2015342.2052 CPU    0MIN 01.83SEC SRB    0MIN 00.05S
IEF375I  JOB/ICETOOL /START 2015342.2051
IEF376I  JOB/ICETOOL /STOP  2015342.2052 CPU    0MIN 01.83SEC SRB    0MIN 00.05S
ICE600I 0 DFSORT ICETOOL UTILITY RUN STARTED
ICE650I 0 VISIT http://www.ibm.com/storage/dfsort FOR ICETOOL PAPERS, EXAMPLES A

ICE632I 0 SOURCE FOR ICETOOL STATEMENTS:  TOOLIN


ICE630I 0 MODE IN EFFECT:  STOP

            SELECT FROM(IN) TO(OUT) ON(1,7,CH) DISCARD(DUPS) ALLDUPS
ICE627I 0 DFSORT CALL 0001 FOR SORT FROM IN       TO OUTFIL   COMPLETED
ICE628I 0 RECORD COUNT:  000000000000008
ICE638I 0 NUMBER OF RECORDS RESULTING FROM CRITERIA:  000000000000006
ICE602I 0 OPERATION RETURN CODE:  00


ICE601I 0 DFSORT ICETOOL UTILITY RUN ENDED - RETURN CODE:  00
ICE200I 0 IDENTIFIER FROM CALLING PROGRAM IS 0001
ICE143I 0 BLOCKSET     SORT  TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AN
ICE000I 0 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R10 - 20:51 ON TUE DE
          DEBUG NOABEND,ESTAE
          OPTION MSGDDN=DFSMSG,LIST,MSGPRT=ALL,RESINV=0,SORTIN=IN,SORTOUT=OUT,DY
                         ALLOC,SZERO,EQUALS,NOVLSHRT,LOCALE=NONE,NOCHECK
          SORT FIELDS=(1,7,CH,A)
          MODS E35=(ICE35DU,12288)
          OUTFIL FNAMES=OUT
          OUTFIL FNAMES=DUPS
ICE201I F RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE175I A ATTEMPT TO REALLOCATE VIO WORK DATA SETS TO REAL RESULTED IN VIO
ICE751I 0 C5-K90014 C6-K90014 C7-BASE   C8-K90014 E4-BASE   C9-BASE   E5-K38900
ICE193I 0 ICEAM2 INVOCATION ENVIRONMENT IN EFFECT - ICEAM2 ENVIRONMENT SELECTED
ICE088I 5 ICETOOL .STEP001 .        , INPUT LRECL = 80, BLKSIZE = 80, TYPE = FB
ICE093I 0 MAIN STORAGE = (MAX,6291456,6266880)
ICE156I 0 MAIN STORAGE ABOVE 16MB = (6225904,6209520)
ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 ,SPANINC=RC16,VLSCMP=N,SZERO=Y,
ICE128I 0 OPTIONS: SIZE=6291456,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ERE
ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO   ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=
ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 ,CHECK=N,WRKREL=Y,OUTREL=Y,CKPT=
ICE131I 0 OPTIONS: TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=16384,CINV=Y,CFW=
ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE    ,EXITC
ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=MAX ,ODMAXBF=2097152,SOLRF=Y,VLLONG=N
ICE235I 0 OPTIONS: NULLOUT=RC0
ICE084I 0 BSAM ACCESS METHOD USED FOR IN
ICE750I 0 DC 500000 TC 0 CS DSVVV KSZ 11 VSZ 11
ICE752I 0 FSZ=6250 RC  IGN=0 E  AVG=84 0  WSP=682 C  DYN=0 0
ICE231I 0 STORAGE USED FOR OUTFIL : BELOW 16M = 20480, ABOVE 16M = 4199424
ICE210I 0 OUT      : EXCP USED, LRECL = 40, BLKSIZE = 27960, TYPE = FB
ICE210I 0 DUPS     : EXCP USED, LRECL = 40, BLKSIZE = 27960, TYPE = FB
ICE751I 1 BA-BASE   BB-K38900 BC-BASE   CB-K90014 E8-K38900
ICE080I 0 IN MAIN STORAGE SORT
ICE055I 0 INSERT 5, DELETE 5
ICE054I 0 RECORDS - IN: 8, OUT: 8
ICE227I 0 OUT      : DELETED = 2, REPORT = 0, DATA = 6
ICE228I 0 OUT      : TOTAL IN = 8, TOTAL OUT = 6
ICE227I 0 DUPS     : DELETED = 6, REPORT = 0, DATA = 2
ICE228I 0 DUPS     : TOTAL IN = 8, TOTAL OUT = 2
ICE134I 0 NUMBER OF BYTES SORTED: 640
ICE253I 0 RECORDS SORTED - PROCESSED: 8, EXPECTED: 6250
ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 0 , TRACKS USED: 0
ICE199I 0 MEMORY OBJECT STORAGE USED = 1M BYTES
ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES
ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES
ICE052I 0 END OF DFSORT
******************************** BOTTOM OF DATA ********************************









  F1=HELP      F2=SPLIT     F3=END       F4=RETURN    F5=IFIND     F6=BOOK
  F7=UP        F8=DOWN      F9=SWAP     F10=LEFT     F11=RIGHT    F12=RETRIEVE
Vamos ver os datasets que geramos;
   Menu  Utilities  Compilers  Options  Status  Help

                            ISPF Primary Option Menu

 0  Settings      Terminal and user parameters            User ID . : ADCDMST
 1  View          Display source data or listings         Time. . . : 20:54
 2  Edit          Create or change source data            Terminal. : 3278
 3  Utilities     Perform utility functions               Screen. . : 1
 4  Foreground    Interactive language processing         Language. : ENGLISH
 5  Batch         Submit job for language processing      Appl ID . : ISR
 6  Command       Enter TSO or Workstation commands       TSO logon : ISPFPROC
 7  Dialog Test   Perform dialog testing                  TSO prefix: ADCDMST
 9  IBM Products  IBM program development products        System ID : ADCD
 10 SCLM          SW Configuration Library Manager        MVS acct. : ACCT#
 11 Workplace     ISPF Object/Action Workplace            Release . : ISPF 6.0
 M  More          Additional IBM Products


      Enter X to Terminate using log/list defaults


 Option ===> 3.4
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=Actions  F12=Cancel
Vamos colocar o dataset ICETOOL.OUT - Este coloca os registros duplicados;
   Menu  RefList  RefMode  Utilities  Help

                             Data Set List Utility
                                                                    More:     +
    blank Display data set list               P Print data set list
        V Display VTOC information           PV Print VTOC information

 Enter one or both of the parameters below:
    Dsname Level . . . ICETOOL.OUT
    Volume serial  . .

 Data set list options
    Initial View                 Enter "/" to select option
    1  1. Volume                 /  Confirm Data Set Delete
       2. Space                  /  Confirm Member Delete
       3. Attrib                 /  Include Additional Qualifiers
       4. Total                  /  Display Catalog Name
                                    Display Total Tracks

 When the data set list is displayed, enter either:
   "/" on the data set list command field for the command prompt pop-up,
 Option ===>
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=Actions  F12=Cancel
B (enter)
   Menu  Options  View  Utilities  Compilers  Help

 DSLIST - Data Sets Matching ICETOOL.OUT                             Row 1 of 1

 Command - Enter "/" to select action                  Message           Volume
 -------------------------------------------------------------------------------
 B        ICETOOL.OUT                                                    ZADB82
 ***************************** End of Data Set list ****************************













 Command ===>                                                  Scroll ===> PAGE
  F1=Help    F2=Split   F3=Exit    F5=Rfind   F7=Up      F8=Down    F9=Swap
 F10=Left   F11=Right  F12=Cancel
Feito, esta os registros duplicados;
   Menu  Utilities  Compilers  Help

 BROWSE    ICETOOL.OUT                                Line 00000000 Col 001 040
********************************* Top of Data **********************************
AAAAA01    - REGISTRO DUPLICADO
AAAAA01    - REGISTRO DUPLICADO
AAAAA02    - REGISTRO DUPLICADO
AAAAA02    - REGISTRO DUPLICADO
BBBBB01    - REGISTRO DUPLICADO
BBBBB01    - REGISTRO DUPLICADO
******************************** Bottom of Data ********************************










 Command ===>                                                  Scroll ===> PAGE
  F1=Help    F2=Split   F3=Exit    F5=Rfind   F7=Up      F8=Down    F9=Swap
 F10=Left   F11=Right  F12=Cancel
Vendo o outro dataset;
   Menu  RefList  RefMode  Utilities  Help

                             Data Set List Utility
                                                                    More:     +
    blank Display data set list               P Print data set list
        V Display VTOC information           PV Print VTOC information

 Enter one or both of the parameters below:
    Dsname Level . . . ICETOOL.DUPS
    Volume serial  . .

 Data set list options
    Initial View                 Enter "/" to select option
    1  1. Volume                 /  Confirm Data Set Delete
       2. Space                  /  Confirm Member Delete
       3. Attrib                 /  Include Additional Qualifiers
       4. Total                  /  Display Catalog Name
                                    Display Total Tracks

 When the data set list is displayed, enter either:
   "/" on the data set list command field for the command prompt pop-up,
 Option ===>
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=Actions  F12=Cancel
B (enter)
   Menu  Options  View  Utilities  Compilers  Help

 DSLIST - Data Sets Matching ICETOOL.DUPS                            Row 1 of 1

 Command - Enter "/" to select action                  Message           Volume
 -------------------------------------------------------------------------------
 B        ICETOOL.DUPS                                                   ZADB82
 ***************************** End of Data Set list ****************************













 Command ===>                                                  Scroll ===> PAGE
  F1=Help    F2=Split   F3=Exit    F5=Rfind   F7=Up      F8=Down    F9=Swap
 F10=Left   F11=Right  F12=Cancel
Registros que não temos duplicados;
   Menu  Utilities  Compilers  Help

 BROWSE    ICETOOL.DUPS                               Line 00000000 Col 001 040
********************************* Top of Data **********************************
AAAAA03    - NAO REPETE
BBBBB02    - NAO REPETE
******************************** Bottom of Data ********************************














 Command ===>                                                  Scroll ===> PAGE
  F1=Help    F2=Split   F3=Exit    F5=Rfind   F7=Up      F8=Down    F9=Swap
 F10=Left   F11=Right  F12=Cancel


Segundo Exemplo

Vamos rodar de novo, só que com outras informações, como o dataset já existe não vamos recriar ele, vamos usar o parametro SHR;
   File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help

 EDIT       ADCD.LIB.JCL(ICETOOL) - 01.04                  Member ICETOOL saved
 Command ===>                                                  Scroll ===> CSR
 ****** ***************************** Top of Data ******************************
 000001 //ICETOOL    JOB (72,FB3),ICHMIN00,COND=(0,NE),
 000002 //      CLASS=A,MSGCLASS=H,NOTIFY=IBMUSER
 000003 //* -------------------------------------------------------
 000004 //* RETAIN THE DUPLICATE RECORDS WITH OUT USING XSUM FETURE
 000005 //* -------------------------------------------------------
 000006 //STEP001  EXEC PGM=ICETOOL
 000007 //IN       DD *
 000008 0000001    - REGISTRO DUPLICADO
 000009 0000001    - REGISTRO DUPLICADO
 000010 0000002    - REGISTRO DUPLICADO
 000011 0000003    - NAO REPETE
 000012 0000004    - NAO REPETE
 000013 0000005    - NAO REPETE
 000014 0000002    - REGISTRO DUPLICADO
 000015 0000006    - NAO REPETE
 000016 /*
 000017 //OUT      DD  DSN=ICETOOL.OUT,DISP=SHR
 000018 //DUPS     DD  DSN=ICETOOL.DUPS,DISP=SHR
 000019 //TOOLMSG  DD SYSOUT=*
 000020 //DFSMSG   DD SYSOUT=*
 000021 //TOOLIN   DD *
 000022   SELECT FROM(IN) TO(OUT) ON(1,7,CH) DISCARD(DUPS) ALLDUPS
 000023 /*
Rodou ok;
   Display  Filter  View  Print  Options  Help
 -------------------------------------------------------------------------------
 SDSF OUTPUT DISPLAY ICETOOL  JOB00218  DSID     2 LINE 0       COLUMNS 02- 81
 COMMAND INPUT ===>                                            SCROLL ===> PAGE
********************************* TOP OF DATA **********************************
                         J E S 2  J O B  L O G  --  S Y S T E M  S Y S 1  --  N

21.14.46 JOB00218 ---- TUESDAY,   08 DEC 2015 ----
21.14.46 JOB00218  IRR010I  USERID IBMUSER  IS ASSIGNED TO THIS JOB.
21.14.46 JOB00218  ICH70001I IBMUSER  LAST ACCESS AT 20:51:58 ON TUESDAY, DECEMB
21.14.46 JOB00218  $HASP373 ICETOOL  STARTED - INIT 1    - CLASS A - SYS SYS1
21.14.46 JOB00218  IEF403I ICETOOL - STARTED - TIME=21.14.46
21.14.49 JOB00218  IEF404I ICETOOL - ENDED - TIME=21.14.49
21.14.49 JOB00218  $HASP395 ICETOOL  ENDED
------ JES2 JOB STATISTICS ------
  08 DEC 2015 JOB EXECUTION DATE
           23 CARDS READ
          129 SYSOUT PRINT RECORDS
            0 SYSOUT PUNCH RECORDS
            7 SYSOUT SPOOL KBYTES
         0.05 MINUTES EXECUTION TIME
        1 //ICETOOL    JOB (72,FB3),ICHMIN00,COND=(0,NE),
          //      CLASS=A,MSGCLASS=H,NOTIFY=IBMUSER
          //* -------------------------------------------------------
          //* RETAIN THE DUPLICATE RECORDS WITH OUT USING XSUM FETURE
          //* -------------------------------------------------------
        2 //STEP001  EXEC PGM=ICETOOL
        3 //IN       DD *
        4 //OUT      DD  DSN=ICETOOL.OUT,DISP=SHR
        5 //DUPS     DD  DSN=ICETOOL.DUPS,DISP=SHR
        6 //TOOLMSG  DD SYSOUT=*
        7 //DFSMSG   DD SYSOUT=*
        8 //TOOLIN   DD *
ICH70001I IBMUSER  LAST ACCESS AT 20:51:58 ON TUESDAY, DECEMBER 8, 2015
IEF236I ALLOC. FOR ICETOOL STEP001
IEF237I JES2 ALLOCATED TO IN
IEF237I 0A84 ALLOCATED TO OUT
IEF237I 0A84 ALLOCATED TO DUPS
IEF237I JES2 ALLOCATED TO TOOLMSG
IEF237I JES2 ALLOCATED TO DFSMSG
---- CORTE ---- RODOU OK
Acessando o arquivo com os dados duplicados;
   Menu  Options  View  Utilities  Compilers  Help

 DSLIST - Data Sets Matching ICETOOL.OUT                             Row 1 of 1

 Command - Enter "/" to select action                  Message           Volume
 -------------------------------------------------------------------------------
 B        ICETOOL.OUT                                                    ZADB82
 ***************************** End of Data Set list ****************************













 Command ===>                                                  Scroll ===> PAGE
  F1=Help    F2=Split   F3=Exit    F5=Rfind   F7=Up      F8=Down    F9=Swap
 F10=Left   F11=Right  F12=Cancel
Mostrou os dados;
   Menu  Utilities  Compilers  Help

 BROWSE    ICETOOL.OUT                                Line 00000000 Col 001 040
********************************* Top of Data **********************************
0000001    - REGISTRO DUPLICADO
0000001    - REGISTRO DUPLICADO
0000002    - REGISTRO DUPLICADO
0000002    - REGISTRO DUPLICADO
******************************** Bottom of Data ********************************












 Command ===>                                                  Scroll ===> PAGE
  F1=Help    F2=Split   F3=Exit    F5=Rfind   F7=Up      F8=Down    F9=Swap
 F10=Left   F11=Right  F12=Cancel
Acessando os dados não duplicados;
   Menu  RefList  RefMode  Utilities  Help

                             Data Set List Utility
                                                                    More:     +
    blank Display data set list               P Print data set list
        V Display VTOC information           PV Print VTOC information

 Enter one or both of the parameters below:
    Dsname Level . . . ICETOOL.DUPS
    Volume serial  . .

 Data set list options
    Initial View                 Enter "/" to select option
    1  1. Volume                 /  Confirm Data Set Delete
       2. Space                  /  Confirm Member Delete
       3. Attrib                 /  Include Additional Qualifiers
       4. Total                  /  Display Catalog Name
                                    Display Total Tracks

 When the data set list is displayed, enter either:
   "/" on the data set list command field for the command prompt pop-up,
 Option ===>
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=Actions  F12=Cancel
Acessando;
   Menu  Options  View  Utilities  Compilers  Help

 DSLIST - Data Sets Matching ICETOOL.DUPS                            Row 1 of 1

 Command - Enter "/" to select action                  Message           Volume
 -------------------------------------------------------------------------------
 B        ICETOOL.DUPS                                                   ZADB82
 ***************************** End of Data Set list ****************************













 Command ===>                                                  Scroll ===> PAGE
  F1=Help    F2=Split   F3=Exit    F5=Rfind   F7=Up      F8=Down    F9=Swap
 F10=Left   F11=Right  F12=Cancel
Os dados que não se repetem;
   Menu  Utilities  Compilers  Help

 BROWSE    ICETOOL.DUPS                               Line 00000000 Col 001 040
********************************* Top of Data **********************************
0000003    - NAO REPETE
0000004    - NAO REPETE
0000005    - NAO REPETE
0000006    - NAO REPETE
******************************** Bottom of Data ********************************












 Command ===>                                                  Scroll ===> PAGE
  F1=Help    F2=Split   F3=Exit    F5=Rfind   F7=Up      F8=Down    F9=Swap
 F10=Left   F11=Right  F12=Cancel

0 comentários:

Enviar um comentário