Z Data Tools Customization Guide
  About this document
    Overview of Z Data Tools
    Who might use this document
    Syntax notation
  Customizing Z Data Tools
    Preparing to customize Z Data Tools
      Checklist for installing and customizing Z Data Tools
      Library names after you finish installing
      Alternatives for making Z Data Tools available
        Concatenating libraries to the LINKLIST
        Modifying the TSO logon procedure
      Planning for running Z Data Tools with or without APF-authorization
      Alternatives for controlling Z Data Tools Base auditing
    Customizing the operating environment for Z Data Tools
      License and enable Z Data Tools
      Modifying the ISPF environment
        Preparing Z Data Tools to run with LIBDEFs
        Invocation of Z Data Tools using LIBDEFs
        Adding Z Data Tools to the ISPF menu
        Defining Z Data Tools in an ISPF command table
        Avoiding conflicts between ZDT commands and other applications
        Making Z Data Tools the default VSAM editor
        Invoking Z Data Tools from ISPF 3.4 or a data set list
      Setting up CICS access for Z Data Tools base component
      Enabling Z Data Tools to work with certain products
        Enabling WebSphere MQ support
        Customizing for processing COBOL copybooks
          Using a supported COBOL compiler
            Adding the COBOL compiler library to the LINKLIST
            Adding the COBOL compiler library to the batch JCL skeletons
            Authorizing the COBOL compiler library for batch processing
            Suppressing COBOL compiler warning messages
            Using COBOL compiler options with Z Data Tools
          Using the Z Data Tools COBOL compiler
            Adding the COBOL compiler library to the LINKLIST
            Adding the COBOL compiler library to the batch JCL skeletons
            Authorizing the COBOL compiler library for batch processing
            Suppressing COBOL compiler warning messages
            Using COBOL compiler options with Z Data Tools
        Customizing for processing PL/I include books
        Customizing for processing HLASM copybooks
        Customizing to use DFSORT to improve Z Data Tools performance
          Customizing when DFSORT is the primary sort product
          Customizing when DFSORT is not the primary sort product
          Determining if DFSORT is being used
          Summary
        Binding Db2 to use Z Data Tools object access method (OAM) functions
      Disabling Websphere MQ feature by system name
      Running Z Data Tools with APF-authorization
        Troubleshooting problems with APF-authorization
      Language Environment considerations
    Customizing Z Data Tools
      Changing the default options
        Setting the default national language
      Setting up Z Data Tools to use a template repository
      Changing the JCL skeleton for batch mode
      Customizing Z Data Tools batch return codes
      Changing the print and display translation tables
        Changing the translation tables in English
      Changing the ASCII translation tables
    Customizing the Z Data Tools security environment
      Setting up the security environment by using RACF or an equivalent security product
        Controlling access to Z Data Tools functions with SAF
          Important information for users of non-IBM security products
        Controlling fullpack access to DASD volumes
        Controlling Bypass Label Processing (BLP)
        Controlling the use of the COBOL compiler
      Setting up the security environment by using HFMSECUR
        Using HFMSECUR to protect DASD volumes from fullpack access
        Syntax of the HFMS macro
        Exit routine environment
        Registers at entry
        Parameter list contents
        Registers at exit
        Installing HFMSECUR using HFMUMODS
      Unprotected functions and profile names for protected functions
    Customizing Z Data Tools to write audit records to SMF
      Using System Management Facilities (SMF) for audit logging
    Customizing the Z Data Tools audit facility for Base component
      HFM0POPT-controlled auditing
      Audit data set configuration
      SAF-controlled auditing for Z Data Tools Base component
        SAF-controlled auditing using SYS1.PARMLIB
          Defining the HFM0PARM member
        SAF-controlled auditing without SYS1.PARMLIB
        When a security product other than RACF is in use
      Implementing SAF-rule controlled auditing
        Understanding how Z Data Tools uses SAF rules to control auditing
          Understanding SAF rule access levels
        How Z Data Tools determines whether audit log records should be written
      SAF rule examples
        Controlling where Z Data Tools writes audit log records
        Controlling auditing of Z Data Tools functions
      Z Data Tools auditing FACILITY and XFACILIT class resource names
    Customizing Z Data Tools for national languages
      Changing the print and display translation tables for languages other than English
      Translating the message text
        Providing a national language version of HFM0MENU
        Translating the ISPF messages text
      Translating the panel text
      Using the translated messages and panels
    Customizing Z Data Tools to use library management system libraries
      Accessing source code in CA-Panvalet libraries
      Other library management systems
        Accessing source code in an LMS with SUBSYS interface
        Accessing source code in an LMS without SUBSYS interface
      Capabilities provided by Z Data Tools via HFMCRAEX
        Restrictions
      Functions which must be provided by HFMCRAEX
        Initialize and terminate the exit
        Validate the library
        Extract a member from the library
        Get member information
        Get display information
      The LMS sample exit
      Writing your own exit
      Performance considerations
    Customizing Z Data Tools Service Provider for z/OS Connect
      Installing Z Data Tools Service Provider for z/OS Connect
        Installing Z Data Tools Service Provider on z/OS
        Installing the service archive file
        Installing the Build Toolkit plug-in
        TLS for the Build Toolkit plug-in
      Maintaining Z Data Tools Service Provider
      Uninstalling Z Data Tools Service Provider
    Customizing Z Data Tools to use the Optim Data Privacy Provider API
    Customizing Z Data Tools to use an I/O exit
      Exit protocol
      Writing your exit
      Exit control block data names
      Using the I/O exit control block
        Function codes and the flow of I/O exit processing
        Information that should always be returned from the I/O Exit to Z Data Tools
        Initialization call discussion
        Termination call discussion
        Open call discussion
        Close call discussion
        Read and Write call discussion
          Important additional information to note about Read and Write
      Installing your exit
    Customizing Z Data Tools to use a scrambling exit
      Exit protocol
      Writing your exit
      Exit control block description
      Using the scrambling exit control block
        Function codes
        Return codes
        Return output field values
      Installing your exit
    Verifying the customization of Z Data Tools
  Customizing Z Data Tools Db2 Component
    Preparing to customize ZDT/Db2
      Checklist for installing and customizing ZDT/Db2
      Alternatives for making ZDT/Db2 available
        Concatenating libraries to the LINKLIST
        Modifying the TSO logon procedure
        Using LIBDEFs to allocate the ZDT/Db2 Libraries
        Ensuring the Db2 libraries are available to ZDT/Db2
      Planning for running ZDT/Db2 with APF-authorization
      Improving ZDT/Db2 performance
      Alternatives for controlling ZDT/Db2 auditing
    Customizing the operating environment for ZDT/Db2
      Modifying the ISPF environment
        Adding ZDT/Db2 to the ISPF menu
        Defining ZDT/Db2 in an ISPF command table
      Customizing the ZDT/Db2 Primary Option Menu
      Granting access to the Db2 catalog (required)
        Sample jobs to grant SELECT access on the Db2 catalog tables
      Adding ZDT/Db2 to the Db2 Administration Launchpad
      Adding commands to start ZDT/Db2 functions from the Db2 Administration Tool
      Starting ZDT/Db2 functions from an external application
    Customizing ZDT/Db2
      Binding Db2 (required)
      Running multiple versions of ZDT/Db2
      Defining all Db2 systems that ZDT/Db2 will access in HFM2POPT (required)
        Examples of HFM2SSDM macros
      Customizing the ZDT/Db2 options
        Examples of HFM2POPI macros
        Usage tips
      Changing the default options
        Setting the default national language
      Changing the JCL skeletons for batch mode
      Customizing to protect update functions in ZDT/Db2
      Customizing ZDT/Db2 for use in production environments
    Customizing the audit facility for ZDT/Db2
      HFM2POPT-controlled auditing
      Audit data set configuration
      SAF-controlled auditing for Z Data Tools Db2 component
        SAF-controlled auditing using SYS1.PARMLIB
          Defining the HFM2PARM member
        SAF-controlled auditing without SYS1.PARMLIB
      Implementing SAF-rule controlled auditing
        Understanding how ZDT/Db2 uses SAF rules to control auditing
          Understanding SAF rule access levels
        How ZDT/Db2 determines whether audit log records should be written
        Controlling where ZDT/Db2 writes audit log records
      SAF rule examples
        Controlling where ZDT/Db2 writes audit log records
        Controlling auditing of update access to Db2 objects
        Controlling auditing of read access to Db2 objects
      Testing SAF-rule controlled auditing
      ZDT/Db2 auditing FACILITY and XFACILIT class resource names
    Customizing ZDT/Db2 for national languages
      Changing the print and display translation tables for languages other than English
      Translating the message text
        Providing a national language version of HFM2MENU
        Translating the ISPF messages text
      Translating the panel text
      Using the translated messages and panels
    Verifying the customization of ZDT/Db2
      Step 1. Define Db2 objects to be used during verification
      Step 2. Run the HFM2CHCK sample job
      Step 3. Take a copy of the ZDT/Db2 IVP tables
      Step 4. Use the ZDT/Db2 editor (normal and related edit)
      Step 5. Use the ZDT/Db2 Basic SELECT Prototyper
      Step 6. Use the ZDT/Db2 Copy function
      Step 7. Use the ZDT/Db2 Export function
      Step 8. Use the ZDT/Db2 Import function
      Step 9. Use the ZDT/Db2 Object List utility
    Re-installing ZDT/Db2 after migration of a Db2 system
  Customizing Z Data Tools IMS Component
    Preparing to customize ZDT/IMS
      Checklist for installing and customizing ZDT/IMS
      Supported databases
      Region types
        DLI mode
        BMP mode
      PSB types
        Dynamic PSBs
        Static PSBs
      IMS region controller parameters
      Security
        IMS subsystem and ZDT/IMS function security
        Protected functions
        The HFM1SXT security exit
        AGN security
        RAS security
        RACF PADS security
        Securing dynamic PSBs in BMP mode
      IMS subsystem access
      Avoiding resource contention
      IMS management of ACBs
      Alternatives for making ZDT/IMS available
        Concatenating libraries to the LINKLIST
        Modifying the TSO logon procedure
      Alternatives for controlling ZDT/IMS auditing
    Customizing the operating environment for ZDT/IMS
      Modifying the ISPF environment
        Adding ZDT/IMS to your ISPF menu
        Defining ZDT/IMS in an ISPF command table
      Customizing IMS to support the use of dynamic PSBs in BMP mode
        Declaring the dynamic PSBs
        Providing a DOPT ACBLIB data set
    Customizing ZDT/IMS
      Customizing the ZDT/IMS installation options module
        ZDT/IMS macro statements
          HFM0POPI macro
          HFM1POPD macro
          HFM1POPI macro
          HFM1AGNT macro
          HFM1END macro
        Specifying the IMS subsystems
        Specifying the parameters passed to the IMS region controller
          PARDLI considerations
        Controlling access to the subsystems
        Specifying selected processing options
        Specifying IMS and ZDT/IMS data sets
        Specifying miscellaneous IMS subsystem details
        Specifying AGNS
        Setting the default national language
        Examples of HFM1POPD, HFM1POPI and HFM1AGNT macros
      Tailoring the job control skeletons
      Customizing for DEDB randomizing modules
    Customizing the ZDT/IMS security environment
      Controlling access to IMS subsystems and ZDT/IMS functions
      Controlling access to the update or read-only functions
      Controlling access to individual IMS subsystems by the update or read-only functions
      Controlling access to individual functions
      Controlling access to individual IMS subsystems by individual functions
        What governs whether access is granted or denied
        Important information for users of non-IBM security products
      Customizing the ZDT/IMS security exit
        Types of security exits
        Invoking the security exit
        Common Exit Parameters
        Security Exit Parameters
      Sample programs for a security exit
    Customizing the Z Data Tools audit facility for IMS component
      HFM1POPT-controlled audit logging
      Audit data set configuration
      SAF-controlled auditing for Z Data Tools IMS component
        SAF-controlled auditing using SYS1.PARMLIB
          Defining the HFM1PARM member
        SAF-controlled auditing without SYS1.PARMLIB
      Implementing SAF-rule controlled auditing
        Understanding how SAF controls ZDT/IMS audit logging
        Controlling where ZDT/IMS writes audit log records
          FILEM.AUDIT1.ssid.TOSMF
          FILEM.AUDIT1.ssid.TODSN
        Controlling whether or not an audit trail is created
          FILEM.AUDIT1.ssid.fc.db.
        Controlling if users can request an audit trail when one is not required (Edit function only)
          FILEM.AUDIT1.ssid.OPTION
    Customizing ZDT/IMS for national languages
      Changing the print and display translation tables for languages other than English
      Translating the message text
        Providing a national language version of HFM1MENU
      Translating the ISPF messages text
      Translating the panel text
      Using the translated messages and panels
    Verifying the customization of ZDT/IMS
      Step 1. Build the sample IMS databases to be used during verification
      Step 2. Start ZDT/IMS
      Step 3. Display settings menu
      Step 4. Display DLI mode settings menu
      Step 5. Verify subsystem details
      Step 6. Verify DLI mode parameters
      Step 7. Verify DLI mode data sets
      Step 8. Verify DLI mode options
      Step 9. Verify DBD library
      Step 10. Start the browse dialog
      Step 11. Verify database data sets
      Step 12. Database positioning
      Step 13. Browse the database
  Customizing Z Data Tools CICS Component
    Preparing to customize ZDT/CICS
      Checklist for installing and customizing ZDT/CICS
      Alternatives for controlling Z Data Tools CICS auditing
    Customizing the operating environment for ZDT/CICS
      CICS resource definitions for ZDT/CICS
      Updating the CICS startup procedures
      Providing OMVS segments for ZDT/CICS users
      Customizing for CICS TCP/IP
        IPv6 support
      Accessing other Z Data Tools functions from the primary option menu
      Providing CICS resource definitions for ZDT/CICS on interconnected regions
        Limiting the regions to which ZDT/CICS can connect
    Customizing ZDT/CICS
      Customizing the batch procedure
      Modifying and submitting HFM3INST
      Customizing for processing COBOL copybooks
      Customizing for processing PL/I include books
      Customizing for processing HLASM copybooks
      Customizing to use DFSORT to improve Z Data Tools performance
      Changing the default options
        HFM3POPI
          PROF
          QRDR
          TRANVU
          MSGL
          CONN
          START
          TRAN
          PORT
          HOST
      Changing the print and display tables
      Customizing to use an I/O exit
    Customizing the ZDT/CICS security environment
      Customizing to protect update functions in ZDT/CICS
      Customizing to invoke other Z Data Tools components from ZDT/CICS
    CICS security and ZDT/CICS
      Introduction
      CICS security considerations for ZDT/CICS
        Logon and user security
        Resource security
        Command security
        Transaction security
        Intercommunication security
        Controlling ZDT/CICS processing
    Customizing the Z Data Tools audit facility for CICS component
      Audit logging under ZDT/CICS and CICS logging
      HFM3POPT-controlled auditing
      Audit data set configuration
      SAF-controlled auditing for Z Data Tools CICS component
        SAF-controlled auditing using SYS1.PARMLIB
          Defining the HFM3PARM member
        SAF-controlled auditing without SYS1.PARMLIB
      Implementing SAF-rule controlled auditing
      Understanding how ZDT/CICS uses SAF rules to control auditing
        Understanding SAF rule access levels
      How ZDT/CICS determines whether audit log records should be written
      Controlling where ZDT/CICS writes audit log records
      SAF rule examples
        Controlling where ZDT/CICS writes audit log records
        Controlling auditing of ZDT/CICS functions
      ZDT/CICS auditing FACILITY and XFACILIT class resource names
    Customizing ZDT/CICS for national languages
      Changing the print and display translation tables for languages other than English
      Setting the LANGUAGE option
      Verifying that the CICS terminal is DBCS-capable
      Translating the ZDT/CICS logon messages
        Providing a national language version of HFM3MENU
      Translating the panel text
      Using the translated messages and panels
    Verifying the customization of ZDT/CICS
    Customizing Z Common Components for use with ZDT/CICS
      Library names after you finish installing Z Common Components
      Translating the message text
      Translating the panel text
    Preparing for Z Data Tools Remote Services
  Z Data Tools options
    ABENDCC
    ASCII
    AUDDATAC
    AUDITHLQ
    AUDITLOG
    AUDMGMTC
    AUDPQTY
    AUDSQTY
    AUDSTORC
    AUDSUNIT
    AUDUNIT
    AUXDATAC
    AUXDSN
    AUXHLQ
    AUXMDSN
    AUXMGMTC
    AUXSTORC
    CCSID
    COBDBCS
    COBDPC
    COBEXTND
    COBMAXRTN
    COBMCASE
    COMPLANG
    CREPLACEn
    CSYSLIBnn
    CYLHD
    DATAHDR
    DSPINC
    DSPMAX
    DSPMIN
    DSPNUM
    DUMP
    EDMAXVIRT
    EDITCAPS
    EOD
    EXCITRAN
    FMEDITOR
    HEADERPG
    HLDBCS
    HLMAXRTN
    HLNOALIGN
    HSYSLIBnn
    ISPFPACK
    JCL
    LANGUAGE
    LMS
    LMSUBSYS
    LOADLIB
    MQREPHLQ
    MSGUPPER
    NOTRUNC
    PAD
    PAGESIZE
    PAGESKIP
    PDATAC
    PLI31DIGIT
    PLI63BIT
    PLIGRAPHIC
    PLIMAXRTN
    PLIUNALIGN
    PMGMTC
    PRINTDSN
    PRINTLEN
    PRINTOUT
    PRTCLASS
    PRTDISP
    PRTMGMTC
    PRTPQTY
    PRTSQTY
    PRTSTORC
    PRTSUNIT
    PRTTRANS
    PRTUNIT
    PSTORC
    PSYSLIBnn
    PTRDATAC
    PUNIT
    RECLIMIT
    RLS
    SEC
    SHOWCOPY
    SMFNO
    TAPELBL
    TDATAC
    TEMPHLQ
    TERMTYPE
    TMGMTC
    TRACECLS
    TRACEDSN
    TRACELIM
    TRACEOUT
    TRCDATAC
    TRCMGMTC
    TRCPQTY
    TRCSQTY
    TRCSTORC
    TRCSUNIT
    TRCUNIT
    TSTORC
    TUNIT
    USEIOX
    VSAUTO
    VSCHGAUTO
    VSCHGFRQ
    VSSAVE
    WBLKSIZE
    WIDEPRT
    WLRECL
  ZDT/Db2 options
    HFM2SSDM
      ATTACH
      AUDIT
      AUDITBROWSE
      AUTH_ACCESS
      AUTO_COMMIT
      CCSIDWARNIGNORE
      CPYCPYN
      DB2CLIB
      DB2ELIB
      DB2LLIB
      DB2MLIB
      DB2PLIB
      DB2PROC
      DB2RLIB
      DB2SLIB
      DB2TLIB
      DESC
      DISPLAY
      EDIT_MAX_ROWS
      EDITOR_TIMEOUT
      FORCE_WITH_UR
      LDFDDLN
      LOCATION
      LOCATION_NICKNAME
      LODINDN
      OPTEVT1
      OPTEVT2
      OPTEVT3
      OPTEVT4
      PLAN
      PROD_EDIT
      RBXWRKN
      ROGUNLN
      SLDJCL1
      SLDJCL2
      SLDJCL3
      SLDJCL4
      SSID
      STMJCL1
      STMJCL2
      STMJCL3
      STMJCL4
      TABLE_LOCKING
      TMPDDLN
      TYPE
      UNLPUNN
      UNLUNLN
      USER_SELECT_EDIT
    HFM2POPI
      CATOWNERCDRM
        Important information about CDRM
      CATOWNER
      CCSIDWARN
      CONNECT
      EDITCAPS
      OP34MOD
      LIST
      SHOWDATAC
      SHOWMGMTC
      SHOWPQTY
      SHOWSQTY
      SHOWSTORC
      SHOWSUNIT
      SHOWUNIT
      SSIDCMD1
      SSIDCMD2
  ZDT/IMS options
    HFM1POPD and HFM1POPI macros
      ACBLIB
      ACBMGMT
      AUTOSAVE
      BSDSHLQ
      CHGAFREQ
      CHKPINTVL
      COMPAT
      DBDLIBn
      DBRC
      DESC
      DFSDF
      DFSRRC00
      DFSVSAMP
      DYNACB
      DYNALLOC
      DYNPRFN
      DYNPRFX
      DYNPSB
      EDITFREQ
      GSGNAME
      IEBFREQ
      IMSAUDLG
      IMSBKO
      IMSNBA
      IMSOBA
      IRLM
      IRLMNAME
      LKEYDATAC
      LKEYMGMTC
      LKEYPQTY
      LKEYSQTY
      LKEYSTORC
      LKEYSUNIT
      LKEYVOLn
      LOADFREQ
      LOCKMAX
      LOGDATAC
      LOGDSN
      LOGMGMTC
      LOGPQTY
      LOGSQTY
      LOGSTORC
      LOGSUNIT
      LOGUNIT
      LOGUSAGE
      MACLIB
      MAXGN
      PADS
      PARDLI
      PROCLIB
      PROCOPTB
      PROCOPTP
      PROCOPTX
      PROCOPTY
      PSBLIBn
      PSBTYPE
      PSBTYPES
      READONLY
      REGTYPES
      RESLIBn
      RKEYDATAC
      RKEYMGMTC
      RKEYPQTY
      RKEYSQTY
      RKEYSTORC
      RKEYSUNIT
      RKEYVOLn
      SKELLIB
      SSID
      TIMEOUTI
      TMINAME
      TPLLIBn
      UACBLIB
      UAGNS
      UAUTOSAV
      UBUF
      UDBDLIB
      UDBRC
      UDFSVSMP
      UIEBFREQ
      UIEFRDER
      UIMSBKO
      UIMSNBA
      UIRLM
      ULOADFRQ
      ULOCKMAX
      ULOGDSN
      ULOGUSAG
      UMACLIB
      UPARDLI
      UPROCOPB
      UPROCOPP
      UPROCOPX
      UPROCOPY
      UPSBLIB
      UPSBTYPE
      URECON
      URESLIB
      URSR
      UTPLLIB
      VCURULE
      VSMPMEM
      XDOPTLB
      XKEYDATAC
      XKEYMGMTC
      XKEYPQTY
      XKEYSQTY
      XKEYSTORC
      XKEYSUNIT
      XKEYUNIT
    HFM1AGNT macro
      AGN
      DESC
      SSID
  Z Data Tools options specified in PARMLIB members
    Z Data Tools options specified in HFM0PARM
      FMAUDIT
        SAF_CTRL
        SMF_NO
      FMOPTMOD
        DSNAME
        MEMBER
      Facilities for customizing the HFM0PARM definitions
      Tags
      Rules for specifying tags
      Example of tag usage
      Included members
      Comments
      Continuing specifications across multiple lines
    ZDT/IMS options specified in HFM1PARM
      FMAUDIT
        SAF_CTRL
        SMF_NO
      FMOPTMOD
        DSNAME
        MEMBER
      Facilities for customizing the HFM1PARM definitions
      Tags
      Rules for specifying tags
      Example of tag usage
      Included members
      Comments
      Continuing specifications across multiple lines
    ZDT/Db2 options specified in HFM2PARM
      FMAUDIT
        SAF_CTRL
        SMF_NO
      FMOPTMOD
        DSNAME
        MEMBER
      Facilities for customizing the HFM2PARM definitions
      Tags
      Rules for specifying tags
      Example of tag usage
      Included members
      Comments
      Continuing specifications across multiple lines
    ZDT/CICS options specified in HFM3PARM
      FMAUDIT
        SAF_CTRL
        SMF_NO
      FMOPTMOD
        DSNAME
        MEMBER
      Facilities for customizing the HFM3PARM definitions
      Tags
      Rules for specifying tags
      Example of tag usage
      Included members
      Comments
      Continuing specifications across multiple lines
  Customizing the Z Common Components server
    Z Common Components server configuration
    Additional security considerations
    Address space timeout
  The library management system exit
    Coding the exit: the basics
      The main program and first argument: the operation code
      The return code
      Initializing the exit
      Tracing
      Terminating the exit
    Coding the exit: required services
      Common argument and the name of the library
      Validate the library
      Get member records
      Get member information (metadata)
      Get display information
    Supporting multiple library management systems
    Writing the exit in HLASM
  Z Data Tools audit records
    Z Data Tools (base) audit records
      Z Data Tools (base) audit data items
      Z Data Tools (base) audit record types
      Data items specific to Z Data Tools (base) audit records
    ZDT/Db2 audit records
      ZDT/Db2 audit data items
      ZDT/Db2 audit record types
      Data items specific to ZDT/Db2 audit records
    ZDT/IMS audit records
      ZDT/IMS audit data items
      ZDT/IMS audit record types
      Data items specific to ZDT/IMS audit records
    ZDT/CICS audit records
      ZDT/CICS audit data items
      ZDT/CICS audit record types
      Data items specific to ZDT/CICS audit records
  Notices
    Programming interface information
  About this document
    Overview of Z Data Tools
    Who might use this document
    Syntax notation
  Customizing Z Data Tools
    Preparing to customize Z Data Tools
      Checklist for installing and customizing Z Data Tools
      Library names after you finish installing
      Alternatives for making Z Data Tools available
        Concatenating libraries to the LINKLIST
        Modifying the TSO logon procedure
      Planning for running Z Data Tools with or without APF-authorization
      Alternatives for controlling Z Data Tools Base auditing
    Customizing the operating environment for Z Data Tools
      License and enable Z Data Tools
      Modifying the ISPF environment
        Preparing Z Data Tools to run with LIBDEFs
        Invocation of Z Data Tools using LIBDEFs
        Adding Z Data Tools to the ISPF menu
        Defining Z Data Tools in an ISPF command table
        Avoiding conflicts between ZDT commands and other applications
        Making Z Data Tools the default VSAM editor
        Invoking Z Data Tools from ISPF 3.4 or a data set list
      Setting up CICS access for Z Data Tools base component
      Enabling Z Data Tools to work with certain products
        Enabling WebSphere MQ support
        Customizing for processing COBOL copybooks
          Using a supported COBOL compiler
            Adding the COBOL compiler library to the LINKLIST
            Adding the COBOL compiler library to the batch JCL skeletons
            Authorizing the COBOL compiler library for batch processing
            Suppressing COBOL compiler warning messages
            Using COBOL compiler options with Z Data Tools
          Using the Z Data Tools COBOL compiler
            Adding the COBOL compiler library to the LINKLIST
            Adding the COBOL compiler library to the batch JCL skeletons
            Authorizing the COBOL compiler library for batch processing
            Suppressing COBOL compiler warning messages
            Using COBOL compiler options with Z Data Tools
        Customizing for processing PL/I include books
        Customizing for processing HLASM copybooks
        Customizing to use DFSORT to improve Z Data Tools performance
          Customizing when DFSORT is the primary sort product
          Customizing when DFSORT is not the primary sort product
          Determining if DFSORT is being used
          Summary
        Binding Db2 to use Z Data Tools object access method (OAM) functions
      Disabling Websphere MQ feature by system name
      Running Z Data Tools with APF-authorization
        Troubleshooting problems with APF-authorization
      Language Environment considerations
    Customizing Z Data Tools
      Changing the default options
        Setting the default national language
      Setting up Z Data Tools to use a template repository
      Changing the JCL skeleton for batch mode
      Customizing Z Data Tools batch return codes
      Changing the print and display translation tables
        Changing the translation tables in English
      Changing the ASCII translation tables
    Customizing the Z Data Tools security environment
      Setting up the security environment by using RACF or an equivalent security product
        Controlling access to Z Data Tools functions with SAF
          Important information for users of non-IBM security products
        Controlling fullpack access to DASD volumes
        Controlling Bypass Label Processing (BLP)
        Controlling the use of the COBOL compiler
      Setting up the security environment by using HFMSECUR
        Using HFMSECUR to protect DASD volumes from fullpack access
        Syntax of the HFMS macro
        Exit routine environment
        Registers at entry
        Parameter list contents
        Registers at exit
        Installing HFMSECUR using HFMUMODS
      Unprotected functions and profile names for protected functions
    Customizing Z Data Tools to write audit records to SMF
      Using System Management Facilities (SMF) for audit logging
    Customizing the Z Data Tools audit facility for Base component
      HFM0POPT-controlled auditing
      Audit data set configuration
      SAF-controlled auditing for Z Data Tools Base component
        SAF-controlled auditing using SYS1.PARMLIB
          Defining the HFM0PARM member
        SAF-controlled auditing without SYS1.PARMLIB
        When a security product other than RACF is in use
      Implementing SAF-rule controlled auditing
        Understanding how Z Data Tools uses SAF rules to control auditing
          Understanding SAF rule access levels
        How Z Data Tools determines whether audit log records should be written
      SAF rule examples
        Controlling where Z Data Tools writes audit log records
        Controlling auditing of Z Data Tools functions
      Z Data Tools auditing FACILITY and XFACILIT class resource names
    Customizing Z Data Tools for national languages
      Changing the print and display translation tables for languages other than English
      Translating the message text
        Providing a national language version of HFM0MENU
        Translating the ISPF messages text
      Translating the panel text
      Using the translated messages and panels
    Customizing Z Data Tools to use library management system libraries
      Accessing source code in CA-Panvalet libraries
      Other library management systems
        Accessing source code in an LMS with SUBSYS interface
        Accessing source code in an LMS without SUBSYS interface
      Capabilities provided by Z Data Tools via HFMCRAEX
        Restrictions
      Functions which must be provided by HFMCRAEX
        Initialize and terminate the exit
        Validate the library
        Extract a member from the library
        Get member information
        Get display information
      The LMS sample exit
      Writing your own exit
      Performance considerations
    Customizing Z Data Tools Service Provider for z/OS Connect
      Installing Z Data Tools Service Provider for z/OS Connect
        Installing Z Data Tools Service Provider on z/OS
        Installing the service archive file
        Installing the Build Toolkit plug-in
        TLS for the Build Toolkit plug-in
      Maintaining Z Data Tools Service Provider
      Uninstalling Z Data Tools Service Provider
    Customizing Z Data Tools to use the Optim Data Privacy Provider API
    Customizing Z Data Tools to use an I/O exit
      Exit protocol
      Writing your exit
      Exit control block data names
      Using the I/O exit control block
        Function codes and the flow of I/O exit processing
        Information that should always be returned from the I/O Exit to Z Data Tools
        Initialization call discussion
        Termination call discussion
        Open call discussion
        Close call discussion
        Read and Write call discussion
          Important additional information to note about Read and Write
      Installing your exit
    Customizing Z Data Tools to use a scrambling exit
      Exit protocol
      Writing your exit
      Exit control block description
      Using the scrambling exit control block
        Function codes
        Return codes
        Return output field values
      Installing your exit
    Verifying the customization of Z Data Tools
  Customizing Z Data Tools Db2 Component
    Preparing to customize ZDT/Db2
      Checklist for installing and customizing ZDT/Db2
      Alternatives for making ZDT/Db2 available
        Concatenating libraries to the LINKLIST
        Modifying the TSO logon procedure
        Using LIBDEFs to allocate the ZDT/Db2 Libraries
        Ensuring the Db2 libraries are available to ZDT/Db2
      Planning for running ZDT/Db2 with APF-authorization
      Improving ZDT/Db2 performance
      Alternatives for controlling ZDT/Db2 auditing
    Customizing the operating environment for ZDT/Db2
      Modifying the ISPF environment
        Adding ZDT/Db2 to the ISPF menu
        Defining ZDT/Db2 in an ISPF command table
      Customizing the ZDT/Db2 Primary Option Menu
      Granting access to the Db2 catalog (required)
        Sample jobs to grant SELECT access on the Db2 catalog tables
      Adding ZDT/Db2 to the Db2 Administration Launchpad
      Adding commands to start ZDT/Db2 functions from the Db2 Administration Tool
      Starting ZDT/Db2 functions from an external application
    Customizing ZDT/Db2
      Binding Db2 (required)
      Running multiple versions of ZDT/Db2
      Defining all Db2 systems that ZDT/Db2 will access in HFM2POPT (required)
        Examples of HFM2SSDM macros
      Customizing the ZDT/Db2 options
        Examples of HFM2POPI macros
        Usage tips
      Changing the default options
        Setting the default national language
      Changing the JCL skeletons for batch mode
      Customizing to protect update functions in ZDT/Db2
      Customizing ZDT/Db2 for use in production environments
    Customizing the audit facility for ZDT/Db2
      HFM2POPT-controlled auditing
      Audit data set configuration
      SAF-controlled auditing for Z Data Tools Db2 component
        SAF-controlled auditing using SYS1.PARMLIB
          Defining the HFM2PARM member
        SAF-controlled auditing without SYS1.PARMLIB
      Implementing SAF-rule controlled auditing
        Understanding how ZDT/Db2 uses SAF rules to control auditing
          Understanding SAF rule access levels
        How ZDT/Db2 determines whether audit log records should be written
        Controlling where ZDT/Db2 writes audit log records
      SAF rule examples
        Controlling where ZDT/Db2 writes audit log records
        Controlling auditing of update access to Db2 objects
        Controlling auditing of read access to Db2 objects
      Testing SAF-rule controlled auditing
      ZDT/Db2 auditing FACILITY and XFACILIT class resource names
    Customizing ZDT/Db2 for national languages
      Changing the print and display translation tables for languages other than English
      Translating the message text
        Providing a national language version of HFM2MENU
        Translating the ISPF messages text
      Translating the panel text
      Using the translated messages and panels
    Verifying the customization of ZDT/Db2
      Step 1. Define Db2 objects to be used during verification
      Step 2. Run the HFM2CHCK sample job
      Step 3. Take a copy of the ZDT/Db2 IVP tables
      Step 4. Use the ZDT/Db2 editor (normal and related edit)
      Step 5. Use the ZDT/Db2 Basic SELECT Prototyper
      Step 6. Use the ZDT/Db2 Copy function
      Step 7. Use the ZDT/Db2 Export function
      Step 8. Use the ZDT/Db2 Import function
      Step 9. Use the ZDT/Db2 Object List utility
    Re-installing ZDT/Db2 after migration of a Db2 system
  Customizing Z Data Tools IMS Component
    Preparing to customize ZDT/IMS
      Checklist for installing and customizing ZDT/IMS
      Supported databases
      Region types
        DLI mode
        BMP mode
      PSB types
        Dynamic PSBs
        Static PSBs
      IMS region controller parameters
      Security
        IMS subsystem and ZDT/IMS function security
        Protected functions
        The HFM1SXT security exit
        AGN security
        RAS security
        RACF PADS security
        Securing dynamic PSBs in BMP mode
      IMS subsystem access
      Avoiding resource contention
      IMS management of ACBs
      Alternatives for making ZDT/IMS available
        Concatenating libraries to the LINKLIST
        Modifying the TSO logon procedure
      Alternatives for controlling ZDT/IMS auditing
    Customizing the operating environment for ZDT/IMS
      Modifying the ISPF environment
        Adding ZDT/IMS to your ISPF menu
        Defining ZDT/IMS in an ISPF command table
      Customizing IMS to support the use of dynamic PSBs in BMP mode
        Declaring the dynamic PSBs
        Providing a DOPT ACBLIB data set
    Customizing ZDT/IMS
      Customizing the ZDT/IMS installation options module
        ZDT/IMS macro statements
          HFM0POPI macro
          HFM1POPD macro
          HFM1POPI macro
          HFM1AGNT macro
          HFM1END macro
        Specifying the IMS subsystems
        Specifying the parameters passed to the IMS region controller
          PARDLI considerations
        Controlling access to the subsystems
        Specifying selected processing options
        Specifying IMS and ZDT/IMS data sets
        Specifying miscellaneous IMS subsystem details
        Specifying AGNS
        Setting the default national language
        Examples of HFM1POPD, HFM1POPI and HFM1AGNT macros
      Tailoring the job control skeletons
      Customizing for DEDB randomizing modules
    Customizing the ZDT/IMS security environment
      Controlling access to IMS subsystems and ZDT/IMS functions
      Controlling access to the update or read-only functions
      Controlling access to individual IMS subsystems by the update or read-only functions
      Controlling access to individual functions
      Controlling access to individual IMS subsystems by individual functions
        What governs whether access is granted or denied
        Important information for users of non-IBM security products
      Customizing the ZDT/IMS security exit
        Types of security exits
        Invoking the security exit
        Common Exit Parameters
        Security Exit Parameters
      Sample programs for a security exit
    Customizing the Z Data Tools audit facility for IMS component
      HFM1POPT-controlled audit logging
      Audit data set configuration
      SAF-controlled auditing for Z Data Tools IMS component
        SAF-controlled auditing using SYS1.PARMLIB
          Defining the HFM1PARM member
        SAF-controlled auditing without SYS1.PARMLIB
      Implementing SAF-rule controlled auditing
        Understanding how SAF controls ZDT/IMS audit logging
        Controlling where ZDT/IMS writes audit log records
          FILEM.AUDIT1.ssid.TOSMF
          FILEM.AUDIT1.ssid.TODSN
        Controlling whether or not an audit trail is created
          FILEM.AUDIT1.ssid.fc.db.
        Controlling if users can request an audit trail when one is not required (Edit function only)
          FILEM.AUDIT1.ssid.OPTION
    Customizing ZDT/IMS for national languages
      Changing the print and display translation tables for languages other than English
      Translating the message text
        Providing a national language version of HFM1MENU
      Translating the ISPF messages text
      Translating the panel text
      Using the translated messages and panels
    Verifying the customization of ZDT/IMS
      Step 1. Build the sample IMS databases to be used during verification
      Step 2. Start ZDT/IMS
      Step 3. Display settings menu
      Step 4. Display DLI mode settings menu
      Step 5. Verify subsystem details
      Step 6. Verify DLI mode parameters
      Step 7. Verify DLI mode data sets
      Step 8. Verify DLI mode options
      Step 9. Verify DBD library
      Step 10. Start the browse dialog
      Step 11. Verify database data sets
      Step 12. Database positioning
      Step 13. Browse the database
  Customizing Z Data Tools CICS Component
    Preparing to customize ZDT/CICS
      Checklist for installing and customizing ZDT/CICS
      Alternatives for controlling Z Data Tools CICS auditing
    Customizing the operating environment for ZDT/CICS
      CICS resource definitions for ZDT/CICS
      Updating the CICS startup procedures
      Providing OMVS segments for ZDT/CICS users
      Customizing for CICS TCP/IP
        IPv6 support
      Accessing other Z Data Tools functions from the primary option menu
      Providing CICS resource definitions for ZDT/CICS on interconnected regions
        Limiting the regions to which ZDT/CICS can connect
    Customizing ZDT/CICS
      Customizing the batch procedure
      Modifying and submitting HFM3INST
      Customizing for processing COBOL copybooks
      Customizing for processing PL/I include books
      Customizing for processing HLASM copybooks
      Customizing to use DFSORT to improve Z Data Tools performance
      Changing the default options
        HFM3POPI
          PROF
          QRDR
          TRANVU
          MSGL
          CONN
          START
          TRAN
          PORT
          HOST
      Changing the print and display tables
      Customizing to use an I/O exit
    Customizing the ZDT/CICS security environment
      Customizing to protect update functions in ZDT/CICS
      Customizing to invoke other Z Data Tools components from ZDT/CICS
    CICS security and ZDT/CICS
      Introduction
      CICS security considerations for ZDT/CICS
        Logon and user security
        Resource security
        Command security
        Transaction security
        Intercommunication security
        Controlling ZDT/CICS processing
    Customizing the Z Data Tools audit facility for CICS component
      Audit logging under ZDT/CICS and CICS logging
      HFM3POPT-controlled auditing
      Audit data set configuration
      SAF-controlled auditing for Z Data Tools CICS component
        SAF-controlled auditing using SYS1.PARMLIB
          Defining the HFM3PARM member
        SAF-controlled auditing without SYS1.PARMLIB
      Implementing SAF-rule controlled auditing
      Understanding how ZDT/CICS uses SAF rules to control auditing
        Understanding SAF rule access levels
      How ZDT/CICS determines whether audit log records should be written
      Controlling where ZDT/CICS writes audit log records
      SAF rule examples
        Controlling where ZDT/CICS writes audit log records
        Controlling auditing of ZDT/CICS functions
      ZDT/CICS auditing FACILITY and XFACILIT class resource names
    Customizing ZDT/CICS for national languages
      Changing the print and display translation tables for languages other than English
      Setting the LANGUAGE option
      Verifying that the CICS terminal is DBCS-capable
      Translating the ZDT/CICS logon messages
        Providing a national language version of HFM3MENU
      Translating the panel text
      Using the translated messages and panels
    Verifying the customization of ZDT/CICS
    Customizing Z Common Components for use with ZDT/CICS
      Library names after you finish installing Z Common Components
      Translating the message text
      Translating the panel text
    Preparing for Z Data Tools Remote Services
  Z Data Tools options
    ABENDCC
    ASCII
    AUDDATAC
    AUDITHLQ
    AUDITLOG
    AUDMGMTC
    AUDPQTY
    AUDSQTY
    AUDSTORC
    AUDSUNIT
    AUDUNIT
    AUXDATAC
    AUXDSN
    AUXHLQ
    AUXMDSN
    AUXMGMTC
    AUXSTORC
    CCSID
    COBDBCS
    COBDPC
    COBEXTND
    COBMAXRTN
    COBMCASE
    COMPLANG
    CREPLACEn
    CSYSLIBnn
    CYLHD
    DATAHDR
    DSPINC
    DSPMAX
    DSPMIN
    DSPNUM
    DUMP
    EDMAXVIRT
    EDITCAPS
    EOD
    EXCITRAN
    FMEDITOR
    HEADERPG
    HLDBCS
    HLMAXRTN
    HLNOALIGN
    HSYSLIBnn
    ISPFPACK
    JCL
    LANGUAGE
    LMS
    LMSUBSYS
    LOADLIB
    MQREPHLQ
    MSGUPPER
    NOTRUNC
    PAD
    PAGESIZE
    PAGESKIP
    PDATAC
    PLI31DIGIT
    PLI63BIT
    PLIGRAPHIC
    PLIMAXRTN
    PLIUNALIGN
    PMGMTC
    PRINTDSN
    PRINTLEN
    PRINTOUT
    PRTCLASS
    PRTDISP
    PRTMGMTC
    PRTPQTY
    PRTSQTY
    PRTSTORC
    PRTSUNIT
    PRTTRANS
    PRTUNIT
    PSTORC
    PSYSLIBnn
    PTRDATAC
    PUNIT
    RECLIMIT
    RLS
    SEC
    SHOWCOPY
    SMFNO
    TAPELBL
    TDATAC
    TEMPHLQ
    TERMTYPE
    TMGMTC
    TRACECLS
    TRACEDSN
    TRACELIM
    TRACEOUT
    TRCDATAC
    TRCMGMTC
    TRCPQTY
    TRCSQTY
    TRCSTORC
    TRCSUNIT
    TRCUNIT
    TSTORC
    TUNIT
    USEIOX
    VSAUTO
    VSCHGAUTO
    VSCHGFRQ
    VSSAVE
    WBLKSIZE
    WIDEPRT
    WLRECL
  ZDT/Db2 options
    HFM2SSDM
      ATTACH
      AUDIT
      AUDITBROWSE
      AUTH_ACCESS
      AUTO_COMMIT
      CCSIDWARNIGNORE
      CPYCPYN
      DB2CLIB
      DB2ELIB
      DB2LLIB
      DB2MLIB
      DB2PLIB
      DB2PROC
      DB2RLIB
      DB2SLIB
      DB2TLIB
      DESC
      DISPLAY
      EDIT_MAX_ROWS
      EDITOR_TIMEOUT
      FORCE_WITH_UR
      LDFDDLN
      LOCATION
      LOCATION_NICKNAME
      LODINDN
      OPTEVT1
      OPTEVT2
      OPTEVT3
      OPTEVT4
      PLAN
      PROD_EDIT
      RBXWRKN
      ROGUNLN
      SLDJCL1
      SLDJCL2
      SLDJCL3
      SLDJCL4
      SSID
      STMJCL1
      STMJCL2
      STMJCL3
      STMJCL4
      TABLE_LOCKING
      TMPDDLN
      TYPE
      UNLPUNN
      UNLUNLN
      USER_SELECT_EDIT
    HFM2POPI
      CATOWNERCDRM
        Important information about CDRM
      CATOWNER
      CCSIDWARN
      CONNECT
      EDITCAPS
      OP34MOD
      LIST
      SHOWDATAC
      SHOWMGMTC
      SHOWPQTY
      SHOWSQTY
      SHOWSTORC
      SHOWSUNIT
      SHOWUNIT
      SSIDCMD1
      SSIDCMD2
  ZDT/IMS options
    HFM1POPD and HFM1POPI macros
      ACBLIB
      ACBMGMT
      AUTOSAVE
      BSDSHLQ
      CHGAFREQ
      CHKPINTVL
      COMPAT
      DBDLIBn
      DBRC
      DESC
      DFSDF
      DFSRRC00
      DFSVSAMP
      DYNACB
      DYNALLOC
      DYNPRFN
      DYNPRFX
      DYNPSB
      EDITFREQ
      GSGNAME
      IEBFREQ
      IMSAUDLG
      IMSBKO
      IMSNBA
      IMSOBA
      IRLM
      IRLMNAME
      LKEYDATAC
      LKEYMGMTC
      LKEYPQTY
      LKEYSQTY
      LKEYSTORC
      LKEYSUNIT
      LKEYVOLn
      LOADFREQ
      LOCKMAX
      LOGDATAC
      LOGDSN
      LOGMGMTC
      LOGPQTY
      LOGSQTY
      LOGSTORC
      LOGSUNIT
      LOGUNIT
      LOGUSAGE
      MACLIB
      MAXGN
      PADS
      PARDLI
      PROCLIB
      PROCOPTB
      PROCOPTP
      PROCOPTX
      PROCOPTY
      PSBLIBn
      PSBTYPE
      PSBTYPES
      READONLY
      REGTYPES
      RESLIBn
      RKEYDATAC
      RKEYMGMTC
      RKEYPQTY
      RKEYSQTY
      RKEYSTORC
      RKEYSUNIT
      RKEYVOLn
      SKELLIB
      SSID
      TIMEOUTI
      TMINAME
      TPLLIBn
      UACBLIB
      UAGNS
      UAUTOSAV
      UBUF
      UDBDLIB
      UDBRC
      UDFSVSMP
      UIEBFREQ
      UIEFRDER
      UIMSBKO
      UIMSNBA
      UIRLM
      ULOADFRQ
      ULOCKMAX
      ULOGDSN
      ULOGUSAG
      UMACLIB
      UPARDLI
      UPROCOPB
      UPROCOPP
      UPROCOPX
      UPROCOPY
      UPSBLIB
      UPSBTYPE
      URECON
      URESLIB
      URSR
      UTPLLIB
      VCURULE
      VSMPMEM
      XDOPTLB
      XKEYDATAC
      XKEYMGMTC
      XKEYPQTY
      XKEYSQTY
      XKEYSTORC
      XKEYSUNIT
      XKEYUNIT
    HFM1AGNT macro
      AGN
      DESC
      SSID
  Z Data Tools options specified in PARMLIB members
    Z Data Tools options specified in HFM0PARM
      FMAUDIT
        SAF_CTRL
        SMF_NO
      FMOPTMOD
        DSNAME
        MEMBER
      Facilities for customizing the HFM0PARM definitions
      Tags
      Rules for specifying tags
      Example of tag usage
      Included members
      Comments
      Continuing specifications across multiple lines
    ZDT/IMS options specified in HFM1PARM
      FMAUDIT
        SAF_CTRL
        SMF_NO
      FMOPTMOD
        DSNAME
        MEMBER
      Facilities for customizing the HFM1PARM definitions
      Tags
      Rules for specifying tags
      Example of tag usage
      Included members
      Comments
      Continuing specifications across multiple lines
    ZDT/Db2 options specified in HFM2PARM
      FMAUDIT
        SAF_CTRL
        SMF_NO
      FMOPTMOD
        DSNAME
        MEMBER
      Facilities for customizing the HFM2PARM definitions
      Tags
      Rules for specifying tags
      Example of tag usage
      Included members
      Comments
      Continuing specifications across multiple lines
    ZDT/CICS options specified in HFM3PARM
      FMAUDIT
        SAF_CTRL
        SMF_NO
      FMOPTMOD
        DSNAME
        MEMBER
      Facilities for customizing the HFM3PARM definitions
      Tags
      Rules for specifying tags
      Example of tag usage
      Included members
      Comments
      Continuing specifications across multiple lines
  Customizing the Z Common Components server
    Z Common Components server configuration
    Additional security considerations
    Address space timeout
  The library management system exit
    Coding the exit: the basics
      The main program and first argument: the operation code
      The return code
      Initializing the exit
      Tracing
      Terminating the exit
    Coding the exit: required services
      Common argument and the name of the library
      Validate the library
      Get member records
      Get member information (metadata)
      Get display information
    Supporting multiple library management systems
    Writing the exit in HLASM
  Z Data Tools audit records
    Z Data Tools (base) audit records
      Z Data Tools (base) audit data items
      Z Data Tools (base) audit record types
      Data items specific to Z Data Tools (base) audit records
    ZDT/Db2 audit records
      ZDT/Db2 audit data items
      ZDT/Db2 audit record types
      Data items specific to ZDT/Db2 audit records
    ZDT/IMS audit records
      ZDT/IMS audit data items
      ZDT/IMS audit record types
      Data items specific to ZDT/IMS audit records
    ZDT/CICS audit records
      ZDT/CICS audit data items
      ZDT/CICS audit record types
      Data items specific to ZDT/CICS audit records
  Notices
    Programming interface information
Z Data Tools User's Guide and Reference
  About this document
    Who should use this document
    How to read syntax diagrams
  Working with Z Data Tools
    Z Data Tools overview
      Z Data Tools actions
      Data sets and records
      Templates
        Why use a template?
        What can you do with a template?
        Where can you use templates?
    Getting started with Z Data Tools
      Starting and exiting Z Data Tools
        Starting Z Data Tools
        Checking your Z Data Tools version
        Checking which COBOL compiler you're using
        Exiting from Z Data Tools
        Invoking Z Data Tools panels from outside Z Data Tools
      Using the Z Data Tools interface
        Navigating in Z Data Tools
        Issuing commands
        Specifying quoted strings
        Specifying a data set and a member name
          Examples of data set name patterns
          Examples of specifying a member name or pattern
        Specifying an MQ manager or queue
        Specifying a CICS resource
        Accessing CICS resources
          Examples of accessing CICS resources
          Running Z Data Tools batch functions with a CICS resource
        Specifying a remote resource
        Accessing remote resources
          Functions supporting remote resources
          Example 1. Viewing a data set on a remote system
          Example 2. Copy a remote load library to the local system
        Manipulating your view of selection lists
          Using primary commands with selection lists
          Scrolling to see data
            Controlling how far you scroll
            Scrolling to the first or last line or column
            Holding a column when scrolling left or right
          Sorting the data
          Finding specific data
          Changing the display width of columns
          Filtering your selection list
          Changing where (and if) columns are displayed
          Displaying data in hexadecimal
        Selecting a range of PDS(E) members
        Using hexadecimal values in Z Data Tools
      Getting help
        Displaying field help information
        Accessing Tutorial Help
        Viewing error messages
      Setting your default processing options
        Set print processing options (option 0.1)
        Setting your System Processing Options (option 0.2)
        Set tape processing options (option 0.3)
        Set batch job card information (option 0.4)
        Language and compiler specifications (option 0.5)
        Editor options (option 0.6)
        VSAM edit sharing options (option 0.7)
        Temporary Data Set Allocations (option 0.8)
        Output Data Set Allocations (option 0.9)
        Trace options (option 0.10)
        Displaying or editing DBCS characters
        National characters
      SAF-rule controlled auditing
        SAF rules for auditing
        SAF-rule controlled auditing not in effect
        SAF-rule controlled auditing in effect, auditing possible
    Viewing and changing data sets
      Starting and ending editor sessions
        Starting an editor session without using templates
          Example of displaying data without a template
        Starting an editor session with a template
          Example of displaying data with a template
          Removing or changing the template
        Viewing and changing packed data
          Working with packed data in Edit
          Working with packed data in View
        Listing statistics for the current editor session
        Displaying your current editor options
        Ending an editor session
          Saving changes without ending the Edit session
      Displaying the RBA and record length information
      Managing the prefix area
      Manipulating your view of the data
        Using primary commands in an editor session
        Selecting a display format
          Setting the initial display format
          Changing the display format
          Display formats
        Displaying a column identification line
        Zooming in to see all of a record
        Displaying the record length
        Scrolling to see data
          Controlling how far you scroll
          Scrolling to the first or last record or column
          Holding fields when scrolling left or right
          Locating a field, column or record number
        Scrollable input and display fields for long names
          Working with scrollable input fields
            Deleting data in scrollable input fields
          Working with scrollable display fields
        Sorting the data
        Finding specific data
          Searching numeric fields
          Handling long strings in FIND
          Finding and correcting errors in your data
        Excluding records from display
          Handling long strings in EXCLUDE
      Using Date/Time fields
      Working with Z Data Tools and shared files
        Overview of shared file features
        What Z Data Tools considers a shared file
        Record integrity checking
          Marking of records that had an integrity check
          "==MSG>" and "=PROF>" indicators
        Refreshing the contents of a record
          Refresh of a record in SNGL display format
          Saving individual records
          Saving a file after a given number of updates (Autosave frequency option)
            What counts as an update?
          CHANGE ALL, automatic saving and retry
      Editing techniques
        In-place-in-memory edit
        In-place edit
        In-memory edit
        Auxiliary edit
        KSDS edit
        Editing large files
        Editing load modules
      Changing data
        Changing data in individual records
        Change data in multiple records
          Differences between primary commands when editing and viewing
        Locating labeled records
        Changing the case of data
        Finding and replacing strings
          Handling long strings in CHANGE
        Changing invalid numeric fields in your data
      Limiting the effect of editing changes
        Setting bounds
        Setting column ranges
        Limiting the search to specified fields
          Specifying a list of fields
          Specifying ranges of fields
        Excluding records
        Labelling record ranges
          Editor-assigned labels
      Editing records within data sets
        Inserting records
        Deleting records
        Recovering deleted records
        Moving records
        Copying and repeating records
        Overlaying data in existing records
        Copying data to and from a clipboard
          Copying data to a clipboard (CUT)
          Copying data from a clipboard (PASTE)
        Copying data from another data set
        Splitting and joining lines
        Changing the length of a record
    Creating and editing templates
      Template types and structure
        Information stored in a template
        About copybook templates
        Segmented data templates
        Mapping SMF data with segmented templates
        About dynamic templates
        Data description support
          Support for COBOL data description entries
          Support for PL/I data description entries
          Support for variable-length arrays
          Editing rules for PL/I varying length string types
          Editing rules for PL/I varying length zero terminated string types
        Using HLASM copybooks with Z Data Tools
          Interpreting HLASM source
      Template repository
        Telling Z Data Tools to use the repository template name
        Template repository edit
          Insert or update repository entries
        Template repository utilities
          Template repository export utility
          Template repository import utility
          Template repository export history utility
          Export utility XML format
      Managing templates
        Setting your template processing options
          Selecting your compiler language
          Setting your COBOL processing options
          Setting your HLASM processing options
          Setting your PL/I processing options
          Overriding Compiler Options
          Determining the search order for your copybooks
        Specifying or updating the source definition for a copybook template
          Single copybook source definitions
          Advanced copybook source definitions
        Advanced copybook selection
        Creating a copybook template with the Template Workbench
        Setting up a template to be used with segmented data
        Creating a template from a model template
        Creating dynamic templates
          Creating dynamic templates on the fly
          Creating dynamic templates from copybook templates
        Creating corresponding templates from selected copybooks
        Editing a template
        Updating one or more templates
      Manipulating the display of fields in records
        Selecting and deselecting fields
        Changing the field display order
          Holding columns when scrolling left or right
          Toggling the hold status of more than one field at a time
        Changing field headings
        Changing field attributes
          Selecting a field for attribute change
          Changing the attributes for an alphanumeric field
          Changing the attributes for a numeric field
        Displaying alphanumeric fields in long hexadecimal
        Defining and changing date and time attributes
      Managing templates with the Template Workbench
        Editing a template (E)
        Editing related ID criteria
          How Z Data Tools handles segmented data with related ID criteria
        Updating a template from a copybook (U)
        Running a function using a copybook or template (RC or RT)
        Mapping fields (MC or MT)
        Generating and editing field mapping (GM, GE and EM)
        Mapping contiguous fields
      Specifying scrambling options
        Selecting a field for specifying scrambling options
          Specifying the scramble type
          Specifying the value option
          Specifying value input and out columns
          Specifying range values
          Specifying a value data set name
          Specifying and editing a value list
        Specifying scrambling options for date and time fields
      Mapping fields between templates
        Default field mapping
          Copying with the default field mapping
          Comparing with the default field mapping
        Editing the field mapping
          Setting up a mapping for a field
          Deleting a field mapping
          Pairing with a different record type
          Mapping group items
          Mapping contiguous fields
          Creating data for a field
          Mapping using different templates
        Field mapping rules
      Copybook View and Print Utility (option 3.13 or 7.2)
      XML templates
        Sample XML for BASE template
        Sample XML for IMS template
        Sample XML for Db2 template
        Using the foreground interface to export XML templates
        Using the foreground interface to import XML templates
        Examples of the batch interface
    Filtering records with templates
      Selecting records with templates
        Selecting records by record type
        Specifying record identification criteria
        Specifying record selection criteria
        Specifying offset values
      Defining criteria expressions
        Entering criteria as a freeform expression
        Entering criteria by field
          Entering criteria expressions for an array element
          Entering criteria for date and time fields
        About expression processing
          Improving performance using internal expression processing
          Overview of REXX expressions
          Handling floating point numbers
          Comparison operators
          Arithmetic operators
          Logical (boolean) operators
          Useful functions
        Examples of REXX comparison expressions
      Filtering record display using templates
        Displaying "suppressed" records
        Changing display of the record type
        Displaying "not-selected" records
          Seeing why a record is not-selected
        Hiding or showing records in SNGL display format
        Using the SHOW command in an editor session
        Viewing segmented data
          Viewing segmented data in SNGL display mode
        Adjusting your view to allow for header information
          Example of a positive offset
          Example of a negative offset
          Specifying an offset value
    Managing data sets
      Working with data set lists
        Accessing data set lists
        Managing personal data set lists
          Making a list the current data set list
          Creating a new personal data set list
          Editing an existing data set list
            Adding a new entry to a data set list
            Deleting an entry from a data set list
            Changing details for an existing entry in a data set list
            Adding a description to an entry in a data set list
          Deleting a data set list
        Retrieving details from a data set list
        Allocating program function keys
      Creating data sets and records
        Creating data without using a template
        Creating data sets using a template
        Allocating a new data set
        Setting the Data Create Attributes in your template
      Creating, replacing, and adding data using existing data
        Creating a new member or data set using data from an edit session
        Replacing a member or data set using data from an edit session
        Adding data to a data set using data from an edit session
        Using all the data from an edit session to create a new member or data set
      Copying data sets
        Copying without a template
        Renaming members as you copy
        Copying with a copybook or template
        Scrambling data
        Copying records with segmented data templates
        Generating data in external format - XML representation
        Copying files or members containing JCL
        Using a DFSORT or REXX procedure
          Example 1
          Example 2
          Example 3
          Example 4
        REXX member selection
          Example 1
          Example 2
      Cloning data sets
        Define the CLONE command without LIBDEFs
        Define the CLONE command with LIBDEFs
        Clone Data Sets panel
        Clone Member List panel
        Review Clone List panel
      Finding and changing data in multiple PDS members
        Building your member list for processing
        Refining the list of selected members
        Specifying where your results are stored
        Specifying your processing options
        Specifying multiple arguments for FIND
        Using the CHANGE command in the Find/Change Utility
        Specifying context in the output listing
        Changing data with a REXX procedure
      Working with files or members containing JCL
      Comparing data sets
        Comparing data sets without using a template
        Comparing data sets using templates
        Record synchronization
        Creating key sequencing for use in a multi-segment key
        Comparison output
          Report sections
          Body section record formats
          Body section flags
          Template details section
            Template details flags
        Formatted comparison of unlike fields
        Comparing load modules
      Printing from Z Data Tools
        Setting your Print Processing Options
        Printing data sets
        Using a DFSORT or REXX procedure
          Example 1
          Example 2
        REXX member selection
          Example 1
          Example 2
        Printing DBCS data
        Printing a single record
        Printing your Audit Trail Report
          Audit trail report
    Using Z Data Tools utilities
      Managing catalog entries
        Available catalog services
        Selecting your service
        Working with a list of catalog entries
        Viewing your Catalog Entry Details
          Viewing association information
          Statistics for VSAM data sets
          Displaying volume information
          Displaying extent details for non-VSAM data sets
          IAM Entry Detail display
        Defining a new Catalog Entry
        Changing an existing Catalog Entry
        Deleting a catalog entry
        Recalling catalog entries
      Displaying a Volume Table of Contents (VTOC)
        Using line commands with Work with VTOC
      Browsing AFP Print documents
        AFP Print Browse primary commands
      Browsing your user storage
        Memory Browse primary commands
      Viewing load module information
      Working with WebSphere MQ
    Tape Specific Functions
      Specifying tape input or output
        Tape density and mode values
        Tape block size considerations
      Specifying the number of tape files to process
      Processing tapes with data-check errors
      ASCII translation
      Exported Stacked Volumes (ESVs)
        Requirements for Exported Stacked Volumes
        ESV options
      Using primary commands with Tape Specific Functions
        BID
        BSF
        BSR
        COPY
        FIND
        FSF
        FSR
        LOCATE
        RD
        REW
        RFIND
        RP
        RUN
        TOF
        ZOOM
      Tape Browse (option 4.1)
      Tape Data Copy Function (option 4.2)
        Tape to Tape (option 4.2.1)
        Tape to Tape Reblocked (option 4.2.2)
        Tape to Labeled Tape (option 4.2.3)
        Tape to VSAM (option 4.2.4)
        Tape to Sequential Data (option 4.2.5)
        VSAM to Tape (option 4.2.6)
        Sequential Data to Tape (option 4.2.7)
        Exported Stacked Volume Copy (option 4.2.8)
        Copying tape data across a network
      Tape Update (option 4.3)
        Special considerations
      Tape Record Load (option 4.4)
      Tape Print (option 4.5)
        Controlling print output
      Tape Map (option 4.6)
      Create Tape Data (option 4.7)
      Tape Label Display (option 4.8)
      Tape to Tape Compare (option 4.9)
      Tape Record Scan (option 4.10)
      Write Tape Mark (option 4.11)
      Initialize Tape (option 4.12)
      Erase Tape (option 4.13)
      Exported Stacked Volume List (option 4.14)
      Tape Positioning Functions (option 4.15)
    Disk/VSAM Data Functions
      Processing disk records
        Specifying disk input and output
        Specifying disk extents
      Disk Browse (option 5.1)
        Disk Browse primary commands
          FIND
      Disk Track Edit (option 5.2)
        Disk Track Edit primary commands
          ADDKEY
          FIND
          CHANGE
          EXCLUDE
      Disk Print (option 5.3)
        Specifying what you want to print
        Controlling print output
      Disk Record Scan (option 5.4)
      Write EOF Record (option 5.5)
      Data Set Extents (option 5.6)
      VSAM Update (option 5.7)
      Data in Virtual (option 5.8)
    OAM Functions
      Introducing the Object Access Method
      Object Directory List (option 6.1)
      Object Browse (option 6.2)
      Object Print (option 6.3)
        Controlling print output
      Object Update (option 6.4)
      Object Erase (option 6.5)
      Object Copy Functions (option 6.6)
      Backing up OAM objects
        Object to VSAM (option 6.6.1)
        Object to Sequential Data (option 6.6.2)
        VSAM to Object (6.6.3)
        Sequential Data to Object (option 6.6.4)
        Object to Object (option 6.6.5)
        Backing up a single OAM object
        Backing up many OAM objects
      Restoring OAM objects
        Restoring an object that was backed up individually
        Restoring one or more objects from a multiple-object backup
    Using UNIX System Services and the Hierarchical File System
      Specifying an HFS file
      Using directories
      Selecting files for processing
      Logical record length
      Processing an HFS file
      Viewing and editing HFS files
      Creating HFS files
      Copying HFS files
      Comparing HFS files
      Printing HFS files
      Finding a string in HFS files
    Introduction to programming with Z Data Tools functions
      Summary of Z Data Tools functions
      Using Z Data Tools functions in REXX procedures or TSO clists
        Invoking Z Data Tools panels from REXX procedures or TSO clists
        Invoking Z Data Tools functions from a REXX procedure or CLIST in /BATCH mode
      Using Z Data Tools functions in batch jobs
        Setting processing options in batch
      Destination of Z Data Tools print output
      Handling errors
    Enhancing Z Data Tools processing
      Why enhance Z Data Tools processing?
      Which tasks can be enhanced
      Choosing the right function to enhance
      Creating and supplying a procedure
        Procedure statement types
        Choosing between FASTREXX, REXX, and DFSORT for your procedure
        Coding DFSORT procedure statements
        Coding REXX procedure statements
          Using internal (FASTREXX) processing
          REXX coding hints and tips
        Coding end of file procedure
        Combining DFSORT and REXX statements in a procedure
        Supplying a procedure to enhance Z Data Tools processing
          Supplying a procedure when using a Z Data Tools panel
          Supplying a procedure when running Z Data Tools in batch
          Supplying a procedure when invoking Z Data Tools from a REXX program
      How enhanced processing works
        How REXX-enhanced processing works
        How DFSORT-enhanced processing works
        Enhanced processing modes
          Enhanced record processing
          Enhanced member processing
        Using templates with enhanced processing
        Working with an entire data set (DSEB only) or per record
        Dropping a record from further processing
        Performance tips
      REXX and DFSORT Examples
        Printing data
        Copying data
        Updating records in a data set
        Editing a data set
      Examples of tasks that can be performed easily using FASTREXX
        Record Editing
        Writing one or more optionally edited records to one or more output files, depending on data in the input record
        Determining whether to copy or print a member based on some condition inside the member
        Relative positioning support
          Input record relative positioning
          Output record relative positioning
    Redefines criteria
      Specifying redefines criteria
        Example 1. CF (by field) prefix command
        Example 2. CR (free-format criteria) prefix command
      Selection rules and example
    Enhanced Reference List, Search, and Change facilities
      Getting Started
        Setting up your ISPF command
        Define the search command without LIBDEFs
        Define the search command with LIBDEFs
        Define the Enhanced Reference List command without LIBDEFs
        Define the Enhanced Reference List command with LIBDEFs
        Setting up your edit or view function key
        Define the Enhanced Change command without LIBDEFs
        Define the Enhanced Change command with LIBDEFs
      Using Enhanced Reference List, Search, and Change
        Reference data set
          Creating the reference data set
          Enhanced Reference List panel
            Primary Commands
            Line Commands
            Field Descriptions
          Specifying resource names in an reference member
            Examples
        EFind command syntax
          How the data set or resource list is determined
        EChange command syntax
        Enhanced Search command panel
        Enhanced Change command panel
        Enhanced Change command member list panel
        Using the F4 function key
          Using F4 for enhanced search report filtering commands
          Using F4 to edit a resource from the enhanced search report
          Using F4 from any edit or view session when positioned on a string or word
            Data set name variable substitution
          Using the Z Data Tools pull-down options from your F4 function key
          Populating Z Data Tools base functions with more than one resource or data set name
          Populating Z Data Tools full-screen functions from Z Data Tools batch JCL
          F4 edit macro hot spots
          Converting the BATCH report output to a navigational report
          Using the F4 data set processing options in JCL
        Examples: Enhanced Reference List and Search
          Example 1. Setting up default member first time usage
          Example 2. Using the DIR DRILL and RESULT with HFS
          Example 3. Using F4 with the enhanced search report
          Example 4. Using F4 in an edit or view session
          Example 5. Enhanced find on current PARMLIB data sets
          Example 6. Enhanced find on SYSPROC SYSEXEC DDs
          Example 7. Searching 3.4 data sets for specific members
          Example 8. Setting up reference members using F4 Select option
        Examples: Enhanced Change
          Example 1. Change all data sets in a reference member
          Example 2. Issue EC command from ISPF 3.4
          Example 3. EC command panel: batch option
          Example 4. EC command panel: select from history
    Z Data Tools Service Provider for z/OS Connect Enterprise Edition
      Methods for accessing IBM Z data sources
      Single reads versus multiple reads
      Requests and responses
        Generic method requests
        Generic method responses
        Specific method requests
        Specific method responses
      Creating z/OS Connect APIs
      Using the Build Toolkit plug-in
        zconbt command line utility
        Build Toolkit plug-in properties
        Deploying SAR files
        Configuring Z Data Tools SAR files
        Modifying templates
      Swagger documentation
      Security
      Troubleshooting
      Example scenarios
        Generic method examples
          Example 1: Read an MVS data set sequentially
          Example 2: Read a keyed record from a CICS VSAM data set
          Example 3: Read the entire contents of a USS file
        Specific method examples
          Example 4: Read a CICS VSAM file sequentially
          Example 5: Read a keyed record from a CICS VSAM data set
          Example 6: Read the entire contents of an MVS data set member
    Function and panel reference lists
      Introduction
        HFMREFTB DD - Sharing reference lists
      Save reference command: SAVEREF (SR SREF)
        Syntax
        Save reference panel
      Retrieve reference command. GETREF (GR GREF)
        Syntax
        Example
      Maintaining your saved references – Reference list
  Z Data Tools Reference
    Panels and fields
      Summary of Z Data Tools panels
      Access Hierarchical File System panel
      Advanced Member Selection panel
      AFP Print Browse panel
      AFP Print Browse output
      AIX Association Information panel
      AIX Entry Detail panel
      Allocate panel
      Allocate (Two) panel
      Allocate (Three) panel
      Append panel
      Browse panel
      Browse Entry panel
      Catalog Services panel
      Catalog Services Data Set List panel
      Clipboard Manager panel
      Compiler Language Selection panel
      Compare Utility: "Old" and "New" panels
      Compare Utility: Load module options panel
      Compare Utility: Options panel
      Compare Utility: Output Data Sets
      Copy From panel
      Copy To panel
      Copybook and Template Utility functions panel
      Copybook Selection panel
      Copybook View and Print: Entry panel
      Copybook View and Print: View panel
      Create panel
      Create Tape Data panel
      Data Create Utility panel
      Data Set Selection panel
      Date/Time Attributes panel
      Delete Entry panel
      Disk Volume Details panel
      Disk/VSAM Data Functions panel
      Display VTOC panel
      Display VTOC Batch Sort Options panel
      Display VTOC Data Set List panel
      Dynamic Template panel
      Editor panel
      Edit Entry panel
      Edit Personal Data Set List panel
      Edit/View - Copy panel
      Editor Options panel
      Erase Tape panel
      Exported Stacked Volume Copy panel
      Exported Stacked Volume List panel
      Field Attributes panel - alphanumeric fields
      Field Attributes panel - numeric field
      Field Mapping panel
      Field Selection/Edit panel
      Field Selection List panel
      File Selection panel
      Find/Change Utility panel
      FMAP Copybook or Template panel
      From (or Old) Field Mapping panel
      GDG Entry Detail panel
      IAM KSDS Define panel
      IAM Entry Details panel
      Initialize Tape panel
      Key positioning panel
      01 Layout Selection List panel
      Library List panel
      Load Module Compare - entry panel
      Load Module Information panel
      Load Module Information - Selection panel
      Load module utility functions panel
      Map To panel
      Member Selection panel
      Memory Browse panel
      Non-VSAM Allocate panel
      Non-VSAM Association Information panel
      Non-VSAM Define panel
      Non-VSAM Entry Detail panel
      Non-VSAM Extent Information panel
      OAM Functions panel
      Path Entry Detail panel
      Personal Data Set List panel
      Personal Data Set Lists panel
      Primary Option Menu panel
      Print Audit Trail panel
      Print Options panel
      Print Utility panel
      Record Identification Criteria panel
      Record Sampling panel
      Record Selection Criteria panel
      Record Type Mapping panel
      Record Type Selection panel
      Redefines / Range Specifications panel
      Related ID expression panel
      RID Selection panel
      Remote System Definition panel
      Remote System Definition List panel
      Replace panel
      Saveas panel
      Scramble Exit Specification panel
      Sequential Data to Tape panel
      Set Batch Job Card Information panel (option 0.4)
      Set COBOL Processing Options panel (option 0.5.2)
      Set DBCS Format panel
      Set HLASM Processing Options panel (option 0.5.3)
      Set Language and Compiler Specifications (option 0.5)
      Set Output Data Set Allocation Options panel
      Set PL/I Processing Options panel (option 0.5.4)
      Set Print Processing Options panel (option 0.1)
      Set Processing Options panel
      Set System Processing Options panel (option 0.2)
      Set Tape Processing Options panel (option 0.3)
      Set Temporary Data Set Allocation Options panel
      Set Trace options panel
      Tape Browse panel
      Tape Data Copy Functions panel
      Tape Label Display panel
      Tape Map panel
      Tape Positioning Functions panel
      Tape Print panel
      Tape Record Load panel
      Tape Record Scan panel
      Tape Specific Functions panel
      Tape to Labeled Tape panel
      Tape to Tape panel
      Tape to Tape Compare panel
      Tape to Tape Reblocked panel
      Tape to QSAM panel
      Tape to VSAM panel
      Tape Update panel
      Template Build Utility panel
      Template Export Utility panel
      Template Import Utility panel
      Template Update Utility panel
      Template Save pop-up panel
      Template Workbench panel
      Utility Functions menu panel
      Utility Functions menu panel from ISPF 3.4
      Value List Edit panel
      View panel
      View Entry panel
      Volume Summary/Selection panel
      VSAM Association Information panel
      VSAM Define panel
      VSAM Edit Sharing Options panel
      VSAM Entry Detail panel
      VSAM Entry Rename panel
      VSAM Statistics and Extent Detail panel
      VSAM to Tape panel
      WebSphere MQ Functions panel
      WebSphere MQ Managers panel
      WebSphere MQ Managers Information panel
      WebSphere MQ Queue Editor Entry panel
      WebSphere MQ Queue Information panel
      WebSphere MQ Queue List panel
      Write Tape Mark panel
    Primary commands
      ABOUT primary command
      AMSMSG primary command
      APPEND and APPENDX primary commands
      ASSOCS primary command
      AUTORTRY primary command
      AUTOSAVE primary command
      BOTTOM primary command
      BOUNDS primary command
      CANCEL primary command
      CAPS primary command
      CASE primary command
      CCSID primary command
      CE (Change Error) primary command
      CEDIT primary command
      CHANGE/CX primary command
      CHGASAVE primary command
      COPY primary command
      CUT primary command
      CREATE, CREATEX primary commands
      DEDIT primary command
      DELETE primary command
      DESCRIBE primary command
      DOWN primary command
      DX primary command
      EDIT primary command
      END primary command
      EXCLUDE/XX primary command
      EXIT primary command
      EXPAND primary command
      EXTENT primary command
      FE (Find Error) primary command
      FKEY primary command
      FILE primary command
      FIND/FX primary command
      FINDNOT primary command
      FMAP primary command
      FORMAT primary command
      FREE primary command
      HEX primary command
      HIDE primary command
      HOLD primary command
      INFO primary command
      JOIN primary command
      JUST primary command
      KEY primary command
      LEFT primary command
      LHEX primary command
      LIBLIST primary command
      LIST primary command
      LISTVIEW primary command
      LOCATE primary command
      NEXT primary command
      NEXTREC primary command
      NRETRIEV primary command
      OFFSET primary command
      ORDER primary command
      PACK primary command
      PASTE primary command
      PIC primary command
      PREFIX primary command
      PREVIOUS primary command
      PREVREC primary command
      PROFILE primary command
      QUIT primary command
      RBALEN primary command
      RCHANGE primary command
      RD primary command
      RDF primary command
      RECLEN primary command
      RECOVER primary command
      RECSTATS primary command
      REFRESH primary command
      REFS primary command
      REPLACE, REPLACEX primary commands
      RESET primary command
      RF primary command
      RFIND primary command
      RIGHT primary command
      RP primary command
      RUNTEMP primary command
      SAVE primary command
      SAVEAS primary command (templates)
      SAVEAS, SAVEASX primary commands (data)
      SELECT primary command
      SHADOW primary command
      SHOW (FLD) primary command
      SHOW (REC) primary command
      SHOWCOB primary command
      SLOC primary command
      SORT primary command
      SPLT primary command
      SPLTJOIN primary command
      STR primary command
      STATS primary command
      SV primary command
      TAILOR primary command
      TEDIT primary command
      TOP primary command
      TPRINT primary command
      TVIEW primary command
      TYPE primary command
      UP primary command
      UPDATE primary command
      VCONTEXT primary command
      VER primary command
      VIEW primary command
      VOLUME primary command
      WIDTH primary command
      XD primary command
      ZOOM primary command
    Functions
      How to use this reference chapter
      How to read the syntax diagrams
      General tips about performance when you use Z Data Tools functions
      Z Data Tools functions
        AUD (Print audit trail report)
        BSF (Backward Space File)
        BSR (Backward Space Record)
        BT (Create Tape File)
        BTB (Batch Template Build)
        BTU (Batch Template Update)
        CLM (Compare Load Module)
        DP (Disk Print)
        DRS (Disk Record Scan)
        DSB (Data Set Browse)
        DSC (Data Set Copy)
        DSE (Data Set Edit)
        DSEB (Data Set Edit Batch) -- batch only
        DSFA (Altering a data set)
        DSFC (Allocate a data set)
        DSFD (Delete a data set)
        DSFR (Rename a data set)
        DSG (Data Set Generate)
        DSI (Data Set Information)
        DSM (Data Set Compare)
        DSP (Data Set Print)
        DSU (Data Set Update) -- batch only
        DSV (Data Set View)
        DSX (Data Set Extents)
        DVT (Display VTOC)
        EOJ (End of Job)
        ERT (Erase Tape)
        EVC (Exported Stacked Volume Copy)
        EVL (Exported Stacked Volume List)
        FCH (Find/Change)
        FMT (Set DBCS Format)
        FSF (Forward Space File)
        FSR (Forward Space Record)
        INT (Initialize Tape)
        NOSORT (Disable the use of DFSORT)
        ODL (Object Directory List)
        OE (Object Erase)
        OO (Object to Object)
        OP (Object Print)
        OS (Object to Sequential Data)
        OV (Object to VSAM)
        PBK (Print Copybook)
        REW (Tape Rewind)
        RUN (Tape Rewind-Unload)
        SCS (Catalog Services)
        SET (Set Processing Options)
        SETRC (Set the job step return code)
        SO (Sequential Data to Object)
        ST (Sequential Data to Tape)
        TLB (Tape Label Display)
        TLT (Tape to Labeled Tape)
        TMP (Tape Map)
        TP (Tape Print)
        TPEXP (Export template to XML)
        TPIMP (Import template from XML)
        TRS (Tape Record Scan)
        TS (Tape to Sequential Data)
        TT (Tape to Tape)
        TTC (Tape to Tape Compare)
        TTR (Tape to Tape Reblocked)
        TV (Tape to VSAM)
        TX (Tape to REXX Variable) -- REXX only
        VER (Display Service Level)
        VLM (View Load Module)
        VO (VSAM to Object)
        VT (VSAM to Tape)
        VX (VSAM to REXX Variable) -- REXX only
        WTM (Write Tape Mark)
        XT (REXX Variable to Tape) -- REXX only
        XV (REXX Variable to VSAM) -- REXX only
      External REXX functions
        Absolute and relative positioning in external REXX functions
        Specifying relative positions
        Using FASTREXX variables
        Tally register for external REXX functions
          Specifying your tally register
          Using a tally register
        BOT (DSEB only)
        CHANGE
        CHG_OUT
        CHG_VAR
        CONTAINS
        CMP_DATE
        CMP_TIME
        DOWN (DSEB only)
        FINDNEXT, FINDPREV (DSEB only)
        FLD
        FLD_CO
        FLD_OUT
        FLD_TM
        FLD_TYPE
        FLDI
        FLDO
        I_LENGTH
        MOD_DATE
        NCONTAIN
        O_LENGTH
        OFLD_CO
        OVLY_OUT
        OVLY_VAR
        PRINT
        PRTCOUNT
        PRT_IN
        PRT_OUT
        PRT_VAR
        RECCUR (DSEB only)
        RECSIN
        RECSOUT
        RSTR_OUT
        SAVE_OUT
        SEGCNT
        SEGLEN
        SEGOFF
        SEGNO
        SET_FLD
        SET_OLEN
        SETC
        SETN
        SETRC
        STATS
        TALLY
        TESTC
        TESTN
        TFLD
        TID
        TM
        TOP (DSEB only)
        UP (DSEB only)
        UPDATE (DSEB only)
        VAL_FLD
        VAR_OUT
        VAR_TM
        WRITE
      RETURN return values
        DROP
        DROP MEMBER
        PROCESS MEMBER
        STOP
        STOP IMMEDIATE
  Z Data Tools messages
    HFMBA009
    HFMBA011
    HFMBA012
    HFMBA013
    HFMBA014
    HFMBA015
    HFMBA016
    HFMBA031
    HFMBA032
    HFMBA033
    HFMBA036
    HFMBA037
    HFMBA038
    HFMBA040
    HFMBA055
    HFMBA063
    HFMBA065
    HFMBA066
    HFMBA067
    HFMBA068
    HFMBA075
    HFMBA076
    HFMBA081
    HFMBA082
    HFMBA083
    HFMBA084
    HFMBA085
    HFMBA091
    HFMBA092
    HFMBA093
    HFMBA094
    HFMBA095
    HFMBA096
    HFMBA097
    HFMBA098
    HFMBA099
    HFMBA100
    HFMBA101
    HFMBA102
    HFMBA113
    HFMBA114
    HFMBA115
    HFMBA116
    HFMBA117
    HFMBA118
    HFMBA119
    HFMBA120
    HFMBA121
    HFMBA130
    HFMBA131
    HFMBA133
    HFMBA134
    HFMBA150
    HFMBA151
    HFMBA152
    HFMBA153
    HFMBA156
    HFMBA157
    HFMBA158
    HFMBA159
    HFMBA160
    HFMBA162
    HFMBA163
    HFMBA170
    HFMBA171
    HFMBA172
    HFMBA181
    HFMBA191
    HFMBA192
    HFMBA193
    HFMBA194
    HFMBA195
    HFMBA196
    HFMBA197
    HFMBA198
    HFMBA199
    HFMBA214
    HFMBA215
    HFMBA216
    HFMBA218
    HFMBA219
    HFMBA220
    HFMBA230
    HFMBA231
    HFMBA232
    HFMBA233
    HFMBA234
    HFMBA235
    HFMBA236
    HFMBA237
    HFMBA238
    HFMBA239
    HFMBA240
    HFMBA241
    HFMBA242
    HFMBA243
    HFMBA244
    HFMBA245
    HFMBA246
    HFMBA247
    HFMBA248
    HFMBA249
    HFMBA252
    HFMBA253
    HFMBA254
    HFMBA260
    HFMBA261
    HFMBA262
    HFMBA263
    HFMBA264
    HFMBA265
    HFMBA267
    HFMBA268
    HFMBA269
    HFMBA271
    HFMBA273
    HFMBA278
    HFMBA279
    HFMBA281
    HFMBA282
    HFMBA283
    HFMBA284
    HFMBA298
    HFMBA299
    HFMBA301
    HFMBA310
    HFMBA311
    HFMBA314
    HFMBA315
    HFMBA316
    HFMBA317
    HFMBA318
    HFMBA319
    HFMBA320
    HFMBA321
    HFMBA322
    HFMBA323
    HFMBA331
    HFMBA332
    HFMBA333
    HFMBA350
    HFMBA351
    HFMBA352
    HFMBA353
    HFMBA354
    HFMBA355
    HFMBA356
    HFMBA358
    HFMBA359
    HFMBA360
    HFMBA361
    HFMBA362
    HFMBA363
    HFMBA370
    HFMBA371
    HFMBA372
    HFMBA375
    HFMBA378
    HFMBA393
    HFMBA394
    HFMBA395
    HFMBA396
    HFMBA397
    HFMBA401
    HFMBA407
    HFMBA409
    HFMBA411
    HFMBA413
    HFMBA420
    HFMBA421
    HFMBA422
    HFMBA423
    HFMBA424
    HFMBA425
    HFMBA426
    HFMBA427
    HFMBA428
    HFMBA429
    HFMBA430
    HFMBA431
    HFMBA432
    HFMBA433
    HFMBA434
    HFMBA435
    HFMBA436
    HFMBA437
    HFMBA438
    HFMBA440
    HFMBA441
    HFMBA442
    HFMBA443
    HFMBA444
    HFMBA445
    HFMBA446
    HFMBA448
    HFMBA449
    HFMBA450
    HFMBA451
    HFMBA453
    HFMBA454
    HFMBA455
    HFMBA456
    HFMBA457
    HFMBA458
    HFMBA459
    HFMBA460
    HFMBA461
    HFMBA462
    HFMBA463
    HFMBA464
    HFMBA465
    HFMBA466
    HFMBA467
    HFMBA470
    HFMBA471
    HFMBA472
    HFMBA473
    HFMBA474
    HFMBA479
    HFMBA480
    HFMBA481
    HFMBA482
    HFMBA483
    HFMBA484
    HFMBA485
    HFMBA486
    HFMBA487
    HFMBA488
    HFMBA489
    HFMBA490
    HFMBA491
    HFMBA492
    HFMBA493
    HFMBA494
    HFMBA495
    HFMBA496
    HFMBA497
    HFMBA498
    HFMBA499
    HFMBA516
    HFMBA517
    HFMBA518
    HFMBA519
    HFMBA520
    HFMBA521
    HFMBA522
    HFMBA523
    HFMBA524
    HFMBA525
    HFMBA526
    HFMBA529
    HFMBA530
    HFMBA534
    HFMBA538
    HFMBA539
    HFMBA590
    HFMBA591
    HFMBA592
    HFMBA600
    HFMBA601
    HFMBA604
    HFMBA605
    HFMBA606
    HFMBA607
    HFMBA608
    HFMBA609
    HFMBA610
    HFMBA613
    HFMBA620
    HFMBA621
    HFMBA622
    HFMBA623
    HFMBA628
    HFMBA629
    HFMBA630
    HFMBA631
    HFMBA634
    HFMBA635
    HFMBA649
    HFMBA650
    HFMBA651
    HFMBA652
    HFMBA653
    HFMBA654
    HFMBA655
    HFMBA661
    HFMBA665
    HFMBA666
    HFMBA667
    HFMBA668
    HFMBA669
    HFMBA670
    HFMBA671
    HFMBA672
    HFMBA673
    HFMBA674
    HFMBA675
    HFMBA676
    HFMBA677
    HFMBA678
    HFMBA679
    HFMBA719
    HFMBA820
    HFMBA821
    HFMBA822
    HFMBA823
    HFMBA830
    HFMBA999
    HFMBB039
    HFMBB172
    HFMBB331
    HFMBB537
    HFMBB538
    HFMBB573
    HFMBB631
    HFMBB632
    HFMBC003
    HFMBC250
    HFMBC251
    HFMBC420
    HFMBC421
    HFMBC422
    HFMBC423
    HFMBC424
    HFMBC425
    HFMBC426
    HFMBC427
    HFMBC428
    HFMBC429
    HFMBC430
    HFMBC431
    HFMBC432
    HFMBC433
    HFMBC434
    HFMBC435
    HFMBC436
    HFMBC437
    HFMBC438
    HFMBC439
    HFMBC440
    HFMBC441
    HFMBC442
    HFMBC448
    HFMBC443
    HFMBC444
    HFMBC445
    HFMBC515
    HFMBC516
    HFMBC530
    HFMBC531
    HFMBC532
    HFMBC533
    HFMBC534
    HFMBC857
    HFMBC858
    HFMBC859
    HFMBC860
    HFMBC861
    HFMBC862
    HFMBC863
    HFMBC864
    HFMBC865
    HFMBC866
    HFMBC867
    HFMBC868
    HFMBD520
    HFMBD521
    HFMBD522
    HFMBD523
    HFMBD524
    HFMBD525
    HFMBD526
    HFMBD527
    HFMBD528
    HFMBD529
    HFMBD530
    HFMBD531
    HFMBD532
    HFMBD533
    HFMBD534
    HFMBD535
    HFMBD536
    HFMBD600
    HFMBD601
    HFMBD602
    HFMBD603
    HFMBD604
    HFMBD605
    HFMBD607
    HFMBD608
    HFMBD612
    HFMBD613
    HFMBD614
    HFMBE004
    HFMBE005
    HFMBE052
    HFMBE094
    HFMBE351
    HFMBE491
    HFMBE719
    HFMBE805
    HFMBE808
    HFMBE895
    HFMBE898
    HFMBE991
    HFMBE992
    HFMBE993
    HFMBE994
    HFMBE998
    HFMBE999
    HFMBF003
    HFMBF123
    HFMBF124
    HFMBF126
    HFMBF427
    HFMBF434
  XML definitions for a template
    Options for "act"
  Notices
    Programming interface information
  Glossary
  About this document
    Who should use this document
    How to read syntax diagrams
  Working with Z Data Tools
    Z Data Tools overview
      Z Data Tools actions
      Data sets and records
      Templates
        Why use a template?
        What can you do with a template?
        Where can you use templates?
    Getting started with Z Data Tools
      Starting and exiting Z Data Tools
        Starting Z Data Tools
        Checking your Z Data Tools version
        Checking which COBOL compiler you're using
        Exiting from Z Data Tools
        Invoking Z Data Tools panels from outside Z Data Tools
      Using the Z Data Tools interface
        Navigating in Z Data Tools
        Issuing commands
        Specifying quoted strings
        Specifying a data set and a member name
          Examples of data set name patterns
          Examples of specifying a member name or pattern
        Specifying an MQ manager or queue
        Specifying a CICS resource
        Accessing CICS resources
          Examples of accessing CICS resources
          Running Z Data Tools batch functions with a CICS resource
        Specifying a remote resource
        Accessing remote resources
          Functions supporting remote resources
          Example 1. Viewing a data set on a remote system
          Example 2. Copy a remote load library to the local system
        Manipulating your view of selection lists
          Using primary commands with selection lists
          Scrolling to see data
            Controlling how far you scroll
            Scrolling to the first or last line or column
            Holding a column when scrolling left or right
          Sorting the data
          Finding specific data
          Changing the display width of columns
          Filtering your selection list
          Changing where (and if) columns are displayed
          Displaying data in hexadecimal
        Selecting a range of PDS(E) members
        Using hexadecimal values in Z Data Tools
      Getting help
        Displaying field help information
        Accessing Tutorial Help
        Viewing error messages
      Setting your default processing options
        Set print processing options (option 0.1)
        Setting your System Processing Options (option 0.2)
        Set tape processing options (option 0.3)
        Set batch job card information (option 0.4)
        Language and compiler specifications (option 0.5)
        Editor options (option 0.6)
        VSAM edit sharing options (option 0.7)
        Temporary Data Set Allocations (option 0.8)
        Output Data Set Allocations (option 0.9)
        Trace options (option 0.10)
        Displaying or editing DBCS characters
        National characters
      SAF-rule controlled auditing
        SAF rules for auditing
        SAF-rule controlled auditing not in effect
        SAF-rule controlled auditing in effect, auditing possible
    Viewing and changing data sets
      Starting and ending editor sessions
        Starting an editor session without using templates
          Example of displaying data without a template
        Starting an editor session with a template
          Example of displaying data with a template
          Removing or changing the template
        Viewing and changing packed data
          Working with packed data in Edit
          Working with packed data in View
        Listing statistics for the current editor session
        Displaying your current editor options
        Ending an editor session
          Saving changes without ending the Edit session
      Displaying the RBA and record length information
      Managing the prefix area
      Manipulating your view of the data
        Using primary commands in an editor session
        Selecting a display format
          Setting the initial display format
          Changing the display format
          Display formats
        Displaying a column identification line
        Zooming in to see all of a record
        Displaying the record length
        Scrolling to see data
          Controlling how far you scroll
          Scrolling to the first or last record or column
          Holding fields when scrolling left or right
          Locating a field, column or record number
        Scrollable input and display fields for long names
          Working with scrollable input fields
            Deleting data in scrollable input fields
          Working with scrollable display fields
        Sorting the data
        Finding specific data
          Searching numeric fields
          Handling long strings in FIND
          Finding and correcting errors in your data
        Excluding records from display
          Handling long strings in EXCLUDE
      Using Date/Time fields
      Working with Z Data Tools and shared files
        Overview of shared file features
        What Z Data Tools considers a shared file
        Record integrity checking
          Marking of records that had an integrity check
          "==MSG>" and "=PROF>" indicators
        Refreshing the contents of a record
          Refresh of a record in SNGL display format
          Saving individual records
          Saving a file after a given number of updates (Autosave frequency option)
            What counts as an update?
          CHANGE ALL, automatic saving and retry
      Editing techniques
        In-place-in-memory edit
        In-place edit
        In-memory edit
        Auxiliary edit
        KSDS edit
        Editing large files
        Editing load modules
      Changing data
        Changing data in individual records
        Change data in multiple records
          Differences between primary commands when editing and viewing
        Locating labeled records
        Changing the case of data
        Finding and replacing strings
          Handling long strings in CHANGE
        Changing invalid numeric fields in your data
      Limiting the effect of editing changes
        Setting bounds
        Setting column ranges
        Limiting the search to specified fields
          Specifying a list of fields
          Specifying ranges of fields
        Excluding records
        Labelling record ranges
          Editor-assigned labels
      Editing records within data sets
        Inserting records
        Deleting records
        Recovering deleted records
        Moving records
        Copying and repeating records
        Overlaying data in existing records
        Copying data to and from a clipboard
          Copying data to a clipboard (CUT)
          Copying data from a clipboard (PASTE)
        Copying data from another data set
        Splitting and joining lines
        Changing the length of a record
    Creating and editing templates
      Template types and structure
        Information stored in a template
        About copybook templates
        Segmented data templates
        Mapping SMF data with segmented templates
        About dynamic templates
        Data description support
          Support for COBOL data description entries
          Support for PL/I data description entries
          Support for variable-length arrays
          Editing rules for PL/I varying length string types
          Editing rules for PL/I varying length zero terminated string types
        Using HLASM copybooks with Z Data Tools
          Interpreting HLASM source
      Template repository
        Telling Z Data Tools to use the repository template name
        Template repository edit
          Insert or update repository entries
        Template repository utilities
          Template repository export utility
          Template repository import utility
          Template repository export history utility
          Export utility XML format
      Managing templates
        Setting your template processing options
          Selecting your compiler language
          Setting your COBOL processing options
          Setting your HLASM processing options
          Setting your PL/I processing options
          Overriding Compiler Options
          Determining the search order for your copybooks
        Specifying or updating the source definition for a copybook template
          Single copybook source definitions
          Advanced copybook source definitions
        Advanced copybook selection
        Creating a copybook template with the Template Workbench
        Setting up a template to be used with segmented data
        Creating a template from a model template
        Creating dynamic templates
          Creating dynamic templates on the fly
          Creating dynamic templates from copybook templates
        Creating corresponding templates from selected copybooks
        Editing a template
        Updating one or more templates
      Manipulating the display of fields in records
        Selecting and deselecting fields
        Changing the field display order
          Holding columns when scrolling left or right
          Toggling the hold status of more than one field at a time
        Changing field headings
        Changing field attributes
          Selecting a field for attribute change
          Changing the attributes for an alphanumeric field
          Changing the attributes for a numeric field
        Displaying alphanumeric fields in long hexadecimal
        Defining and changing date and time attributes
      Managing templates with the Template Workbench
        Editing a template (E)
        Editing related ID criteria
          How Z Data Tools handles segmented data with related ID criteria
        Updating a template from a copybook (U)
        Running a function using a copybook or template (RC or RT)
        Mapping fields (MC or MT)
        Generating and editing field mapping (GM, GE and EM)
        Mapping contiguous fields
      Specifying scrambling options
        Selecting a field for specifying scrambling options
          Specifying the scramble type
          Specifying the value option
          Specifying value input and out columns
          Specifying range values
          Specifying a value data set name
          Specifying and editing a value list
        Specifying scrambling options for date and time fields
      Mapping fields between templates
        Default field mapping
          Copying with the default field mapping
          Comparing with the default field mapping
        Editing the field mapping
          Setting up a mapping for a field
          Deleting a field mapping
          Pairing with a different record type
          Mapping group items
          Mapping contiguous fields
          Creating data for a field
          Mapping using different templates
        Field mapping rules
      Copybook View and Print Utility (option 3.13 or 7.2)
      XML templates
        Sample XML for BASE template
        Sample XML for IMS template
        Sample XML for Db2 template
        Using the foreground interface to export XML templates
        Using the foreground interface to import XML templates
        Examples of the batch interface
    Filtering records with templates
      Selecting records with templates
        Selecting records by record type
        Specifying record identification criteria
        Specifying record selection criteria
        Specifying offset values
      Defining criteria expressions
        Entering criteria as a freeform expression
        Entering criteria by field
          Entering criteria expressions for an array element
          Entering criteria for date and time fields
        About expression processing
          Improving performance using internal expression processing
          Overview of REXX expressions
          Handling floating point numbers
          Comparison operators
          Arithmetic operators
          Logical (boolean) operators
          Useful functions
        Examples of REXX comparison expressions
      Filtering record display using templates
        Displaying "suppressed" records
        Changing display of the record type
        Displaying "not-selected" records
          Seeing why a record is not-selected
        Hiding or showing records in SNGL display format
        Using the SHOW command in an editor session
        Viewing segmented data
          Viewing segmented data in SNGL display mode
        Adjusting your view to allow for header information
          Example of a positive offset
          Example of a negative offset
          Specifying an offset value
    Managing data sets
      Working with data set lists
        Accessing data set lists
        Managing personal data set lists
          Making a list the current data set list
          Creating a new personal data set list
          Editing an existing data set list
            Adding a new entry to a data set list
            Deleting an entry from a data set list
            Changing details for an existing entry in a data set list
            Adding a description to an entry in a data set list
          Deleting a data set list
        Retrieving details from a data set list
        Allocating program function keys
      Creating data sets and records
        Creating data without using a template
        Creating data sets using a template
        Allocating a new data set
        Setting the Data Create Attributes in your template
      Creating, replacing, and adding data using existing data
        Creating a new member or data set using data from an edit session
        Replacing a member or data set using data from an edit session
        Adding data to a data set using data from an edit session
        Using all the data from an edit session to create a new member or data set
      Copying data sets
        Copying without a template
        Renaming members as you copy
        Copying with a copybook or template
        Scrambling data
        Copying records with segmented data templates
        Generating data in external format - XML representation
        Copying files or members containing JCL
        Using a DFSORT or REXX procedure
          Example 1
          Example 2
          Example 3
          Example 4
        REXX member selection
          Example 1
          Example 2
      Cloning data sets
        Define the CLONE command without LIBDEFs
        Define the CLONE command with LIBDEFs
        Clone Data Sets panel
        Clone Member List panel
        Review Clone List panel
      Finding and changing data in multiple PDS members
        Building your member list for processing
        Refining the list of selected members
        Specifying where your results are stored
        Specifying your processing options
        Specifying multiple arguments for FIND
        Using the CHANGE command in the Find/Change Utility
        Specifying context in the output listing
        Changing data with a REXX procedure
      Working with files or members containing JCL
      Comparing data sets
        Comparing data sets without using a template
        Comparing data sets using templates
        Record synchronization
        Creating key sequencing for use in a multi-segment key
        Comparison output
          Report sections
          Body section record formats
          Body section flags
          Template details section
            Template details flags
        Formatted comparison of unlike fields
        Comparing load modules
      Printing from Z Data Tools
        Setting your Print Processing Options
        Printing data sets
        Using a DFSORT or REXX procedure
          Example 1
          Example 2
        REXX member selection
          Example 1
          Example 2
        Printing DBCS data
        Printing a single record
        Printing your Audit Trail Report
          Audit trail report
    Using Z Data Tools utilities
      Managing catalog entries
        Available catalog services
        Selecting your service
        Working with a list of catalog entries
        Viewing your Catalog Entry Details
          Viewing association information
          Statistics for VSAM data sets
          Displaying volume information
          Displaying extent details for non-VSAM data sets
          IAM Entry Detail display
        Defining a new Catalog Entry
        Changing an existing Catalog Entry
        Deleting a catalog entry
        Recalling catalog entries
      Displaying a Volume Table of Contents (VTOC)
        Using line commands with Work with VTOC
      Browsing AFP Print documents
        AFP Print Browse primary commands
      Browsing your user storage
        Memory Browse primary commands
      Viewing load module information
      Working with WebSphere MQ
    Tape Specific Functions
      Specifying tape input or output
        Tape density and mode values
        Tape block size considerations
      Specifying the number of tape files to process
      Processing tapes with data-check errors
      ASCII translation
      Exported Stacked Volumes (ESVs)
        Requirements for Exported Stacked Volumes
        ESV options
      Using primary commands with Tape Specific Functions
        BID
        BSF
        BSR
        COPY
        FIND
        FSF
        FSR
        LOCATE
        RD
        REW
        RFIND
        RP
        RUN
        TOF
        ZOOM
      Tape Browse (option 4.1)
      Tape Data Copy Function (option 4.2)
        Tape to Tape (option 4.2.1)
        Tape to Tape Reblocked (option 4.2.2)
        Tape to Labeled Tape (option 4.2.3)
        Tape to VSAM (option 4.2.4)
        Tape to Sequential Data (option 4.2.5)
        VSAM to Tape (option 4.2.6)
        Sequential Data to Tape (option 4.2.7)
        Exported Stacked Volume Copy (option 4.2.8)
        Copying tape data across a network
      Tape Update (option 4.3)
        Special considerations
      Tape Record Load (option 4.4)
      Tape Print (option 4.5)
        Controlling print output
      Tape Map (option 4.6)
      Create Tape Data (option 4.7)
      Tape Label Display (option 4.8)
      Tape to Tape Compare (option 4.9)
      Tape Record Scan (option 4.10)
      Write Tape Mark (option 4.11)
      Initialize Tape (option 4.12)
      Erase Tape (option 4.13)
      Exported Stacked Volume List (option 4.14)
      Tape Positioning Functions (option 4.15)
    Disk/VSAM Data Functions
      Processing disk records
        Specifying disk input and output
        Specifying disk extents
      Disk Browse (option 5.1)
        Disk Browse primary commands
          FIND
      Disk Track Edit (option 5.2)
        Disk Track Edit primary commands
          ADDKEY
          FIND
          CHANGE
          EXCLUDE
      Disk Print (option 5.3)
        Specifying what you want to print
        Controlling print output
      Disk Record Scan (option 5.4)
      Write EOF Record (option 5.5)
      Data Set Extents (option 5.6)
      VSAM Update (option 5.7)
      Data in Virtual (option 5.8)
    OAM Functions
      Introducing the Object Access Method
      Object Directory List (option 6.1)
      Object Browse (option 6.2)
      Object Print (option 6.3)
        Controlling print output
      Object Update (option 6.4)
      Object Erase (option 6.5)
      Object Copy Functions (option 6.6)
      Backing up OAM objects
        Object to VSAM (option 6.6.1)
        Object to Sequential Data (option 6.6.2)
        VSAM to Object (6.6.3)
        Sequential Data to Object (option 6.6.4)
        Object to Object (option 6.6.5)
        Backing up a single OAM object
        Backing up many OAM objects
      Restoring OAM objects
        Restoring an object that was backed up individually
        Restoring one or more objects from a multiple-object backup
    Using UNIX System Services and the Hierarchical File System
      Specifying an HFS file
      Using directories
      Selecting files for processing
      Logical record length
      Processing an HFS file
      Viewing and editing HFS files
      Creating HFS files
      Copying HFS files
      Comparing HFS files
      Printing HFS files
      Finding a string in HFS files
    Introduction to programming with Z Data Tools functions
      Summary of Z Data Tools functions
      Using Z Data Tools functions in REXX procedures or TSO clists
        Invoking Z Data Tools panels from REXX procedures or TSO clists
        Invoking Z Data Tools functions from a REXX procedure or CLIST in /BATCH mode
      Using Z Data Tools functions in batch jobs
        Setting processing options in batch
      Destination of Z Data Tools print output
      Handling errors
    Enhancing Z Data Tools processing
      Why enhance Z Data Tools processing?
      Which tasks can be enhanced
      Choosing the right function to enhance
      Creating and supplying a procedure
        Procedure statement types
        Choosing between FASTREXX, REXX, and DFSORT for your procedure
        Coding DFSORT procedure statements
        Coding REXX procedure statements
          Using internal (FASTREXX) processing
          REXX coding hints and tips
        Coding end of file procedure
        Combining DFSORT and REXX statements in a procedure
        Supplying a procedure to enhance Z Data Tools processing
          Supplying a procedure when using a Z Data Tools panel
          Supplying a procedure when running Z Data Tools in batch
          Supplying a procedure when invoking Z Data Tools from a REXX program
      How enhanced processing works
        How REXX-enhanced processing works
        How DFSORT-enhanced processing works
        Enhanced processing modes
          Enhanced record processing
          Enhanced member processing
        Using templates with enhanced processing
        Working with an entire data set (DSEB only) or per record
        Dropping a record from further processing
        Performance tips
      REXX and DFSORT Examples
        Printing data
        Copying data
        Updating records in a data set
        Editing a data set
      Examples of tasks that can be performed easily using FASTREXX
        Record Editing
        Writing one or more optionally edited records to one or more output files, depending on data in the input record
        Determining whether to copy or print a member based on some condition inside the member
        Relative positioning support
          Input record relative positioning
          Output record relative positioning
    Redefines criteria
      Specifying redefines criteria
        Example 1. CF (by field) prefix command
        Example 2. CR (free-format criteria) prefix command
      Selection rules and example
    Enhanced Reference List, Search, and Change facilities
      Getting Started
        Setting up your ISPF command
        Define the search command without LIBDEFs
        Define the search command with LIBDEFs
        Define the Enhanced Reference List command without LIBDEFs
        Define the Enhanced Reference List command with LIBDEFs
        Setting up your edit or view function key
        Define the Enhanced Change command without LIBDEFs
        Define the Enhanced Change command with LIBDEFs
      Using Enhanced Reference List, Search, and Change
        Reference data set
          Creating the reference data set
          Enhanced Reference List panel
            Primary Commands
            Line Commands
            Field Descriptions
          Specifying resource names in an reference member
            Examples
        EFind command syntax
          How the data set or resource list is determined
        EChange command syntax
        Enhanced Search command panel
        Enhanced Change command panel
        Enhanced Change command member list panel
        Using the F4 function key
          Using F4 for enhanced search report filtering commands
          Using F4 to edit a resource from the enhanced search report
          Using F4 from any edit or view session when positioned on a string or word
            Data set name variable substitution
          Using the Z Data Tools pull-down options from your F4 function key
          Populating Z Data Tools base functions with more than one resource or data set name
          Populating Z Data Tools full-screen functions from Z Data Tools batch JCL
          F4 edit macro hot spots
          Converting the BATCH report output to a navigational report
          Using the F4 data set processing options in JCL
        Examples: Enhanced Reference List and Search
          Example 1. Setting up default member first time usage
          Example 2. Using the DIR DRILL and RESULT with HFS
          Example 3. Using F4 with the enhanced search report
          Example 4. Using F4 in an edit or view session
          Example 5. Enhanced find on current PARMLIB data sets
          Example 6. Enhanced find on SYSPROC SYSEXEC DDs
          Example 7. Searching 3.4 data sets for specific members
          Example 8. Setting up reference members using F4 Select option
        Examples: Enhanced Change
          Example 1. Change all data sets in a reference member
          Example 2. Issue EC command from ISPF 3.4
          Example 3. EC command panel: batch option
          Example 4. EC command panel: select from history
    Z Data Tools Service Provider for z/OS Connect Enterprise Edition
      Methods for accessing IBM Z data sources
      Single reads versus multiple reads
      Requests and responses
        Generic method requests
        Generic method responses
        Specific method requests
        Specific method responses
      Creating z/OS Connect APIs
      Using the Build Toolkit plug-in
        zconbt command line utility
        Build Toolkit plug-in properties
        Deploying SAR files
        Configuring Z Data Tools SAR files
        Modifying templates
      Swagger documentation
      Security
      Troubleshooting
      Example scenarios
        Generic method examples
          Example 1: Read an MVS data set sequentially
          Example 2: Read a keyed record from a CICS VSAM data set
          Example 3: Read the entire contents of a USS file
        Specific method examples
          Example 4: Read a CICS VSAM file sequentially
          Example 5: Read a keyed record from a CICS VSAM data set
          Example 6: Read the entire contents of an MVS data set member
    Function and panel reference lists
      Introduction
        HFMREFTB DD - Sharing reference lists
      Save reference command: SAVEREF (SR SREF)
        Syntax
        Save reference panel
      Retrieve reference command. GETREF (GR GREF)
        Syntax
        Example
      Maintaining your saved references – Reference list
  Z Data Tools Reference
    Panels and fields
      Summary of Z Data Tools panels
      Access Hierarchical File System panel
      Advanced Member Selection panel
      AFP Print Browse panel
      AFP Print Browse output
      AIX Association Information panel
      AIX Entry Detail panel
      Allocate panel
      Allocate (Two) panel
      Allocate (Three) panel
      Append panel
      Browse panel
      Browse Entry panel
      Catalog Services panel
      Catalog Services Data Set List panel
      Clipboard Manager panel
      Compiler Language Selection panel
      Compare Utility: "Old" and "New" panels
      Compare Utility: Load module options panel
      Compare Utility: Options panel
      Compare Utility: Output Data Sets
      Copy From panel
      Copy To panel
      Copybook and Template Utility functions panel
      Copybook Selection panel
      Copybook View and Print: Entry panel
      Copybook View and Print: View panel
      Create panel
      Create Tape Data panel
      Data Create Utility panel
      Data Set Selection panel
      Date/Time Attributes panel
      Delete Entry panel
      Disk Volume Details panel
      Disk/VSAM Data Functions panel
      Display VTOC panel
      Display VTOC Batch Sort Options panel
      Display VTOC Data Set List panel
      Dynamic Template panel
      Editor panel
      Edit Entry panel
      Edit Personal Data Set List panel
      Edit/View - Copy panel
      Editor Options panel
      Erase Tape panel
      Exported Stacked Volume Copy panel
      Exported Stacked Volume List panel
      Field Attributes panel - alphanumeric fields
      Field Attributes panel - numeric field
      Field Mapping panel
      Field Selection/Edit panel
      Field Selection List panel
      File Selection panel
      Find/Change Utility panel
      FMAP Copybook or Template panel
      From (or Old) Field Mapping panel
      GDG Entry Detail panel
      IAM KSDS Define panel
      IAM Entry Details panel
      Initialize Tape panel
      Key positioning panel
      01 Layout Selection List panel
      Library List panel
      Load Module Compare - entry panel
      Load Module Information panel
      Load Module Information - Selection panel
      Load module utility functions panel
      Map To panel
      Member Selection panel
      Memory Browse panel
      Non-VSAM Allocate panel
      Non-VSAM Association Information panel
      Non-VSAM Define panel
      Non-VSAM Entry Detail panel
      Non-VSAM Extent Information panel
      OAM Functions panel
      Path Entry Detail panel
      Personal Data Set List panel
      Personal Data Set Lists panel
      Primary Option Menu panel
      Print Audit Trail panel
      Print Options panel
      Print Utility panel
      Record Identification Criteria panel
      Record Sampling panel
      Record Selection Criteria panel
      Record Type Mapping panel
      Record Type Selection panel
      Redefines / Range Specifications panel
      Related ID expression panel
      RID Selection panel
      Remote System Definition panel
      Remote System Definition List panel
      Replace panel
      Saveas panel
      Scramble Exit Specification panel
      Sequential Data to Tape panel
      Set Batch Job Card Information panel (option 0.4)
      Set COBOL Processing Options panel (option 0.5.2)
      Set DBCS Format panel
      Set HLASM Processing Options panel (option 0.5.3)
      Set Language and Compiler Specifications (option 0.5)
      Set Output Data Set Allocation Options panel
      Set PL/I Processing Options panel (option 0.5.4)
      Set Print Processing Options panel (option 0.1)
      Set Processing Options panel
      Set System Processing Options panel (option 0.2)
      Set Tape Processing Options panel (option 0.3)
      Set Temporary Data Set Allocation Options panel
      Set Trace options panel
      Tape Browse panel
      Tape Data Copy Functions panel
      Tape Label Display panel
      Tape Map panel
      Tape Positioning Functions panel
      Tape Print panel
      Tape Record Load panel
      Tape Record Scan panel
      Tape Specific Functions panel
      Tape to Labeled Tape panel
      Tape to Tape panel
      Tape to Tape Compare panel
      Tape to Tape Reblocked panel
      Tape to QSAM panel
      Tape to VSAM panel
      Tape Update panel
      Template Build Utility panel
      Template Export Utility panel
      Template Import Utility panel
      Template Update Utility panel
      Template Save pop-up panel
      Template Workbench panel
      Utility Functions menu panel
      Utility Functions menu panel from ISPF 3.4
      Value List Edit panel
      View panel
      View Entry panel
      Volume Summary/Selection panel
      VSAM Association Information panel
      VSAM Define panel
      VSAM Edit Sharing Options panel
      VSAM Entry Detail panel
      VSAM Entry Rename panel
      VSAM Statistics and Extent Detail panel
      VSAM to Tape panel
      WebSphere MQ Functions panel
      WebSphere MQ Managers panel
      WebSphere MQ Managers Information panel
      WebSphere MQ Queue Editor Entry panel
      WebSphere MQ Queue Information panel
      WebSphere MQ Queue List panel
      Write Tape Mark panel
    Primary commands
      ABOUT primary command
      AMSMSG primary command
      APPEND and APPENDX primary commands
      ASSOCS primary command
      AUTORTRY primary command
      AUTOSAVE primary command
      BOTTOM primary command
      BOUNDS primary command
      CANCEL primary command
      CAPS primary command
      CASE primary command
      CCSID primary command
      CE (Change Error) primary command
      CEDIT primary command
      CHANGE/CX primary command
      CHGASAVE primary command
      COPY primary command
      CUT primary command
      CREATE, CREATEX primary commands
      DEDIT primary command
      DELETE primary command
      DESCRIBE primary command
      DOWN primary command
      DX primary command
      EDIT primary command
      END primary command
      EXCLUDE/XX primary command
      EXIT primary command
      EXPAND primary command
      EXTENT primary command
      FE (Find Error) primary command
      FKEY primary command
      FILE primary command
      FIND/FX primary command
      FINDNOT primary command
      FMAP primary command
      FORMAT primary command
      FREE primary command
      HEX primary command
      HIDE primary command
      HOLD primary command
      INFO primary command
      JOIN primary command
      JUST primary command
      KEY primary command
      LEFT primary command
      LHEX primary command
      LIBLIST primary command
      LIST primary command
      LISTVIEW primary command
      LOCATE primary command
      NEXT primary command
      NEXTREC primary command
      NRETRIEV primary command
      OFFSET primary command
      ORDER primary command
      PACK primary command
      PASTE primary command
      PIC primary command
      PREFIX primary command
      PREVIOUS primary command
      PREVREC primary command
      PROFILE primary command
      QUIT primary command
      RBALEN primary command
      RCHANGE primary command
      RD primary command
      RDF primary command
      RECLEN primary command
      RECOVER primary command
      RECSTATS primary command
      REFRESH primary command
      REFS primary command
      REPLACE, REPLACEX primary commands
      RESET primary command
      RF primary command
      RFIND primary command
      RIGHT primary command
      RP primary command
      RUNTEMP primary command
      SAVE primary command
      SAVEAS primary command (templates)
      SAVEAS, SAVEASX primary commands (data)
      SELECT primary command
      SHADOW primary command
      SHOW (FLD) primary command
      SHOW (REC) primary command
      SHOWCOB primary command
      SLOC primary command
      SORT primary command
      SPLT primary command
      SPLTJOIN primary command
      STR primary command
      STATS primary command
      SV primary command
      TAILOR primary command
      TEDIT primary command
      TOP primary command
      TPRINT primary command
      TVIEW primary command
      TYPE primary command
      UP primary command
      UPDATE primary command
      VCONTEXT primary command
      VER primary command
      VIEW primary command
      VOLUME primary command
      WIDTH primary command
      XD primary command
      ZOOM primary command
    Functions
      How to use this reference chapter
      How to read the syntax diagrams
      General tips about performance when you use Z Data Tools functions
      Z Data Tools functions
        AUD (Print audit trail report)
        BSF (Backward Space File)
        BSR (Backward Space Record)
        BT (Create Tape File)
        BTB (Batch Template Build)
        BTU (Batch Template Update)
        CLM (Compare Load Module)
        DP (Disk Print)
        DRS (Disk Record Scan)
        DSB (Data Set Browse)
        DSC (Data Set Copy)
        DSE (Data Set Edit)
        DSEB (Data Set Edit Batch) -- batch only
        DSFA (Altering a data set)
        DSFC (Allocate a data set)
        DSFD (Delete a data set)
        DSFR (Rename a data set)
        DSG (Data Set Generate)
        DSI (Data Set Information)
        DSM (Data Set Compare)
        DSP (Data Set Print)
        DSU (Data Set Update) -- batch only
        DSV (Data Set View)
        DSX (Data Set Extents)
        DVT (Display VTOC)
        EOJ (End of Job)
        ERT (Erase Tape)
        EVC (Exported Stacked Volume Copy)
        EVL (Exported Stacked Volume List)
        FCH (Find/Change)
        FMT (Set DBCS Format)
        FSF (Forward Space File)
        FSR (Forward Space Record)
        INT (Initialize Tape)
        NOSORT (Disable the use of DFSORT)
        ODL (Object Directory List)
        OE (Object Erase)
        OO (Object to Object)
        OP (Object Print)
        OS (Object to Sequential Data)
        OV (Object to VSAM)
        PBK (Print Copybook)
        REW (Tape Rewind)
        RUN (Tape Rewind-Unload)
        SCS (Catalog Services)
        SET (Set Processing Options)
        SETRC (Set the job step return code)
        SO (Sequential Data to Object)
        ST (Sequential Data to Tape)
        TLB (Tape Label Display)
        TLT (Tape to Labeled Tape)
        TMP (Tape Map)
        TP (Tape Print)
        TPEXP (Export template to XML)
        TPIMP (Import template from XML)
        TRS (Tape Record Scan)
        TS (Tape to Sequential Data)
        TT (Tape to Tape)
        TTC (Tape to Tape Compare)
        TTR (Tape to Tape Reblocked)
        TV (Tape to VSAM)
        TX (Tape to REXX Variable) -- REXX only
        VER (Display Service Level)
        VLM (View Load Module)
        VO (VSAM to Object)
        VT (VSAM to Tape)
        VX (VSAM to REXX Variable) -- REXX only
        WTM (Write Tape Mark)
        XT (REXX Variable to Tape) -- REXX only
        XV (REXX Variable to VSAM) -- REXX only
      External REXX functions
        Absolute and relative positioning in external REXX functions
        Specifying relative positions
        Using FASTREXX variables
        Tally register for external REXX functions
          Specifying your tally register
          Using a tally register
        BOT (DSEB only)
        CHANGE
        CHG_OUT
        CHG_VAR
        CONTAINS
        CMP_DATE
        CMP_TIME
        DOWN (DSEB only)
        FINDNEXT, FINDPREV (DSEB only)
        FLD
        FLD_CO
        FLD_OUT
        FLD_TM
        FLD_TYPE
        FLDI
        FLDO
        I_LENGTH
        MOD_DATE
        NCONTAIN
        O_LENGTH
        OFLD_CO
        OVLY_OUT
        OVLY_VAR
        PRINT
        PRTCOUNT
        PRT_IN
        PRT_OUT
        PRT_VAR
        RECCUR (DSEB only)
        RECSIN
        RECSOUT
        RSTR_OUT
        SAVE_OUT
        SEGCNT
        SEGLEN
        SEGOFF
        SEGNO
        SET_FLD
        SET_OLEN
        SETC
        SETN
        SETRC
        STATS
        TALLY
        TESTC
        TESTN
        TFLD
        TID
        TM
        TOP (DSEB only)
        UP (DSEB only)
        UPDATE (DSEB only)
        VAL_FLD
        VAR_OUT
        VAR_TM
        WRITE
      RETURN return values
        DROP
        DROP MEMBER
        PROCESS MEMBER
        STOP
        STOP IMMEDIATE
  Z Data Tools messages
    HFMBA009
    HFMBA011
    HFMBA012
    HFMBA013
    HFMBA014
    HFMBA015
    HFMBA016
    HFMBA031
    HFMBA032
    HFMBA033
    HFMBA036
    HFMBA037
    HFMBA038
    HFMBA040
    HFMBA055
    HFMBA063
    HFMBA065
    HFMBA066
    HFMBA067
    HFMBA068
    HFMBA075
    HFMBA076
    HFMBA081
    HFMBA082
    HFMBA083
    HFMBA084
    HFMBA085
    HFMBA091
    HFMBA092
    HFMBA093
    HFMBA094
    HFMBA095
    HFMBA096
    HFMBA097
    HFMBA098
    HFMBA099
    HFMBA100
    HFMBA101
    HFMBA102
    HFMBA113
    HFMBA114
    HFMBA115
    HFMBA116
    HFMBA117
    HFMBA118
    HFMBA119
    HFMBA120
    HFMBA121
    HFMBA130
    HFMBA131
    HFMBA133
    HFMBA134
    HFMBA150
    HFMBA151
    HFMBA152
    HFMBA153
    HFMBA156
    HFMBA157
    HFMBA158
    HFMBA159
    HFMBA160
    HFMBA162
    HFMBA163
    HFMBA170
    HFMBA171
    HFMBA172
    HFMBA181
    HFMBA191
    HFMBA192
    HFMBA193
    HFMBA194
    HFMBA195
    HFMBA196
    HFMBA197
    HFMBA198
    HFMBA199
    HFMBA214
    HFMBA215
    HFMBA216
    HFMBA218
    HFMBA219
    HFMBA220
    HFMBA230
    HFMBA231
    HFMBA232
    HFMBA233
    HFMBA234
    HFMBA235
    HFMBA236
    HFMBA237
    HFMBA238
    HFMBA239
    HFMBA240
    HFMBA241
    HFMBA242
    HFMBA243
    HFMBA244
    HFMBA245
    HFMBA246
    HFMBA247
    HFMBA248
    HFMBA249
    HFMBA252
    HFMBA253
    HFMBA254
    HFMBA260
    HFMBA261
    HFMBA262
    HFMBA263
    HFMBA264
    HFMBA265
    HFMBA267
    HFMBA268
    HFMBA269
    HFMBA271
    HFMBA273
    HFMBA278
    HFMBA279
    HFMBA281
    HFMBA282
    HFMBA283
    HFMBA284
    HFMBA298
    HFMBA299
    HFMBA301
    HFMBA310
    HFMBA311
    HFMBA314
    HFMBA315
    HFMBA316
    HFMBA317
    HFMBA318
    HFMBA319
    HFMBA320
    HFMBA321
    HFMBA322
    HFMBA323
    HFMBA331
    HFMBA332
    HFMBA333
    HFMBA350
    HFMBA351
    HFMBA352
    HFMBA353
    HFMBA354
    HFMBA355
    HFMBA356
    HFMBA358
    HFMBA359
    HFMBA360
    HFMBA361
    HFMBA362
    HFMBA363
    HFMBA370
    HFMBA371
    HFMBA372
    HFMBA375
    HFMBA378
    HFMBA393
    HFMBA394
    HFMBA395
    HFMBA396
    HFMBA397
    HFMBA401
    HFMBA407
    HFMBA409
    HFMBA411
    HFMBA413
    HFMBA420
    HFMBA421
    HFMBA422
    HFMBA423
    HFMBA424
    HFMBA425
    HFMBA426
    HFMBA427
    HFMBA428
    HFMBA429
    HFMBA430
    HFMBA431
    HFMBA432
    HFMBA433
    HFMBA434
    HFMBA435
    HFMBA436
    HFMBA437
    HFMBA438
    HFMBA440
    HFMBA441
    HFMBA442
    HFMBA443
    HFMBA444
    HFMBA445
    HFMBA446
    HFMBA448
    HFMBA449
    HFMBA450
    HFMBA451
    HFMBA453
    HFMBA454
    HFMBA455
    HFMBA456
    HFMBA457
    HFMBA458
    HFMBA459
    HFMBA460
    HFMBA461
    HFMBA462
    HFMBA463
    HFMBA464
    HFMBA465
    HFMBA466
    HFMBA467
    HFMBA470
    HFMBA471
    HFMBA472
    HFMBA473
    HFMBA474
    HFMBA479
    HFMBA480
    HFMBA481
    HFMBA482
    HFMBA483
    HFMBA484
    HFMBA485
    HFMBA486
    HFMBA487
    HFMBA488
    HFMBA489
    HFMBA490
    HFMBA491
    HFMBA492
    HFMBA493
    HFMBA494
    HFMBA495
    HFMBA496
    HFMBA497
    HFMBA498
    HFMBA499
    HFMBA516
    HFMBA517
    HFMBA518
    HFMBA519
    HFMBA520
    HFMBA521
    HFMBA522
    HFMBA523
    HFMBA524
    HFMBA525
    HFMBA526
    HFMBA529
    HFMBA530
    HFMBA534
    HFMBA538
    HFMBA539
    HFMBA590
    HFMBA591
    HFMBA592
    HFMBA600
    HFMBA601
    HFMBA604
    HFMBA605
    HFMBA606
    HFMBA607
    HFMBA608
    HFMBA609
    HFMBA610
    HFMBA613
    HFMBA620
    HFMBA621
    HFMBA622
    HFMBA623
    HFMBA628
    HFMBA629
    HFMBA630
    HFMBA631
    HFMBA634
    HFMBA635
    HFMBA649
    HFMBA650
    HFMBA651
    HFMBA652
    HFMBA653
    HFMBA654
    HFMBA655
    HFMBA661
    HFMBA665
    HFMBA666
    HFMBA667
    HFMBA668
    HFMBA669
    HFMBA670
    HFMBA671
    HFMBA672
    HFMBA673
    HFMBA674
    HFMBA675
    HFMBA676
    HFMBA677
    HFMBA678
    HFMBA679
    HFMBA719
    HFMBA820
    HFMBA821
    HFMBA822
    HFMBA823
    HFMBA830
    HFMBA999
    HFMBB039
    HFMBB172
    HFMBB331
    HFMBB537
    HFMBB538
    HFMBB573
    HFMBB631
    HFMBB632
    HFMBC003
    HFMBC250
    HFMBC251
    HFMBC420
    HFMBC421
    HFMBC422
    HFMBC423
    HFMBC424
    HFMBC425
    HFMBC426
    HFMBC427
    HFMBC428
    HFMBC429
    HFMBC430
    HFMBC431
    HFMBC432
    HFMBC433
    HFMBC434
    HFMBC435
    HFMBC436
    HFMBC437
    HFMBC438
    HFMBC439
    HFMBC440
    HFMBC441
    HFMBC442
    HFMBC448
    HFMBC443
    HFMBC444
    HFMBC445
    HFMBC515
    HFMBC516
    HFMBC530
    HFMBC531
    HFMBC532
    HFMBC533
    HFMBC534
    HFMBC857
    HFMBC858
    HFMBC859
    HFMBC860
    HFMBC861
    HFMBC862
    HFMBC863
    HFMBC864
    HFMBC865
    HFMBC866
    HFMBC867
    HFMBC868
    HFMBD520
    HFMBD521
    HFMBD522
    HFMBD523
    HFMBD524
    HFMBD525
    HFMBD526
    HFMBD527
    HFMBD528
    HFMBD529
    HFMBD530
    HFMBD531
    HFMBD532
    HFMBD533
    HFMBD534
    HFMBD535
    HFMBD536
    HFMBD600
    HFMBD601
    HFMBD602
    HFMBD603
    HFMBD604
    HFMBD605
    HFMBD607
    HFMBD608
    HFMBD612
    HFMBD613
    HFMBD614
    HFMBE004
    HFMBE005
    HFMBE052
    HFMBE094
    HFMBE351
    HFMBE491
    HFMBE719
    HFMBE805
    HFMBE808
    HFMBE895
    HFMBE898
    HFMBE991
    HFMBE992
    HFMBE993
    HFMBE994
    HFMBE998
    HFMBE999
    HFMBF003
    HFMBF123
    HFMBF124
    HFMBF126
    HFMBF427
    HFMBF434
  XML definitions for a template
    Options for "act"
  Notices
    Programming interface information
  Glossary
Z Data Tools User’s Guide and Reference for Db2 Data
  About this document
    Who should use this document
    Releases of Db2 supported
    National characters
    Prerequisite and related information
    How to read syntax diagrams
  Working with ZDT/Db2
    ZDT/Db2 overview
      What you can do with ZDT/Db2
      Templates
        What is a template?
        Where you can use templates
    Getting started with ZDT/Db2
      Starting and exiting ZDT/Db2
        TSO region size
        Starting ZDT/Db2
        Checking your ZDT/Db2 version
        Checking which COBOL compiler you're using
        Exiting from ZDT/Db2
      Selecting the Db2 subsystem when more than one is available
        Selecting the Db2 subsystem with the Db2 SSID field
        Selecting the Db2 subsystem by entering the SSID command
        Using the Db2 Subsystem Selection menu
          Selecting a subsystem
          Refreshing the list of Db2 subsystems
          Restricting the list of Db2 subsystems
      Using the ZDT/Db2 interface
        Navigating in ZDT/Db2
        ZDT/Db2 panel features
          Selecting an item from the action bar
        Screen size
        Scrollable input and display fields for long names
          Working with scrollable input fields
            Deleting data in scrollable input fields
          Working with scrollable display fields
        Selecting options on ZDT/Db2 panels
        Specifying a Db2 object name
          Using an asterisk (*) or a pattern in entry fields
        Specifying the SQLID
        Specifying a data set and a member name
          Examples of data set name patterns
          Examples of specifying a member name or pattern
        Canceling long-running Db2 queries
      Getting help
        Accessing Tutorial Help
        Displaying field-level help information
        Displaying the expanded form of error messages
      Setting default processing options
        System Options (option 0)
        Print settings (option 0.1)
        ZDT/Db2 system options (option 0.2)
        Job card specifications (option 0.3)
        Compiler language selection (option 0.4)
        COBOL compiler specifications (option 0.5)
        HLASM compiler specifications (option 0.6)
        PL/I compiler specifications (option 0.7)
        Temporary Data Set Allocations (option 0.8)
        Output Data Set Allocations (option 0.9)
        Trace options (option 0.10)
        ISPF settings (option 0.11)
        View and Edit options (options 1 and 2)
        Utilities (option 3)
        Print utility options (option 3.1)
        Copy utility options (option 3.3)
        Object List Options (option 3.4)
        Export utility options (option 3.7)
        Db2 LOAD utility options (option 3.L)
        Db2 Utility LISTDEF options (option 3.UL)
        Db2 Utility OPTIONS options (option 3.UO)
        Db2 Utility TEMPLATE options (option 3.UT)
        Db2 Unload utility options (option 3.UU)
        Displaying or editing DBCS characters
      SAF-rule controlled auditing
        Determining when SAF-rule controlled auditing is in effect
        SAF rules for auditing
        SAF-rule controlled auditing not in effect
        SAF-rule controlled auditing in effect, no auditing
        SAF-rule controlled auditing in effect, auditing possible
    Working with templates
      Associating a template with a Db2 object
      Information stored in a template
        Printing a template
      Using templates with non-Db2 data
        How ZDT/Db2 compiles a copybook into a template
        Support for COBOL data description entries
        Support for HLASM data description entries
        Support for PL/I data description entries
        Support for variable-length arrays
      Editing a template
        Adding a description to a template
      Selecting rows
        Row selection by column
          Changing the display (80-character screens only)
          Verifying the format of DATE, TIME, and TIMESTAMP columns
        Row selection criteria in freeform style
        Scrolling the Row Selection Criteria field
        Expanding the Row Selection Criteria field
        Using the SQL Edit session
          Making changes
          Saving changes
          Long WHERE clauses
      Manipulating columns
        Selecting columns
          Toggling the selection status of more than one column at a time
        Holding columns (when scrolling left or right)
          Toggling the hold status of more than one column at a time
        Changing the sequence of displayed or printed data
          Changing the sequence of displayed or printed columns
          Changing the sequence of displayed or printed rows
        Changing column attributes
          Changing the attributes for an alphanumeric column
            Changing the column heading
            Changing the output width
          Changing the attributes for a numeric column
            Changing the output width
            Showing leading zeros
        ROWID columns
      Specifying scrambling options
        Selecting a column for specifying scrambling options
          Specifying the scramble type
          Specifying the value option
          Specifying value input and out columns
          Specifying range values
          Specifying a value data set name
          Specifying and editing a value list
      Mapping data
        Where you can map data
        Letting ZDT/Db2 do the mapping
        Specifying your own mapping
          Setting up mapping for a column
          Changing the attributes for a "To" column
          Creating data for a column
          Mapping using different templates
          Mapping contiguous columns
        Column mapping rules
      Creating a copybook from a ZDT/Db2 Template
    Viewing and changing Db2 data
      ZDT/Db2 editor sessions
        Starting a ZDT/Db2 editor session
        Specifying the editor session mode: "normal mode" or "large mode"
          Choosing the appropriate editor mode
        Specifying the start position for your ZDT/Db2 editor session
        Setting options for the current ZDT/Db2 editor session
        Validating and saving changes with a ZDT/Db2 editor session
          Ordering of rows within a Db2 object is not guaranteed
          Viewing and changing LOB data and XML documents
            XML differences
          Db2-related considerations when changing data in a ZDT/Db2 Edit session
        Ending a ZDT/Db2 editor session
        Starting another ZDT/Db2 editor session
      Specifying the Db2 object you want to view
      Restricting the data that ZDT/Db2 loads from Db2
        Storage considerations
        Viewing large tables or views
          Restricting the rows to view by specifying row selection criteria
          Interactively developing row selection criteria
          Restricting the rows to view with the "Row count" entry field
          Restricting the rows to view with the "Start position" entry field
          Using Select Statement Edit to limit the data retrieved by ZDT/Db2
      Viewing data in a ZDT/Db2 editor session
        Count of rows fetched in a ZDT/Db2 editor session
        Locating a row
        Locating a column
          Specifying the column number or column name
            Using the FLD parameter
          Specifying the search direction and starting point
            Using the NEXT parameter
            Using the PREV parameter
            Using the FIRST parameter
            Using the LAST parameter
        Finding a string
          Repeating the search
          Handling long strings
        Finding data within specific columns
          Specifying a list of columns
          Specifying ranges of columns
        Finding a string within specific portions of the data
        Finding data within excluded or non-excluded rows
        Finding data within a label range
          Assigning labels to rows
        Searching numeric columns
        Changing the view of displayed data
          Selecting a display format
          TABL display format
          SNGL display format
          Zooming in to see all of a row
          Scrolling
            Controlling how far you scroll
            Scrolling to the first or last row or column
          Excluding rows
            Showing or hiding excluded rows
          Sorting the data
          Displaying data in hexadecimal format
          Managing the prefix area
          Displaying the column number
          Displaying the data type
      Handling special data
        DATE and TIME columns
          DATE columns
          TIME columns
        Large numeric fields
        Working with large tables
          SQL optimization options
          Large table options
          Data sampling
            Clustered data sampling
            Random data sampling
        Null values and VARCHAR processing
          Null column indicator character
          Varying-length columns
        Unicode data
      Changing data
        Installation settings that affect CAPS
        Changing data by overtyping
        Changing data with the CHANGE command
          "From" and "To" strings of different lengths
          Handling long strings
          Changing numeric columns
          Changing data within excluded or non-excluded rows
          Changing data within a label range
          Limiting the change to specific portions of the data
        Changing data using prefix commands
          Overlaying data in existing rows
        Converting data to uppercase
        "Read-only" views, non-updateable columns
      Deleting rows
        Deleting rows within excluded or non-excluded rows
        Deleting rows within a label range
      Editing related tables
        Listing related tables
        Self-referencing constraints
        Referential integrity errors
        Starting an Edit session of a related table
        Differences when you edit a related table
        Differences when saving or canceling while editing a related table
        Navigating between Edit sessions
        Deleting a primary key
        Inserting a new foreign key
        Updating a primary key
        Adding a primary key
      Issuing Db2 commands from within a ZDT/Db2 session
        Issuing Db2 commands from the Enter and Execute Db2 Commands panel
        Issuing Db2 commands from the command line
      Handling errors during an Edit session
        Determining why an error occurred
        "Duplicate Row" errors
        "No Primary Key" errors
        "Delete Restrict Rule" errors
        "Check Constraint" errors
        "Row Not Found" errors
        Deadlocks or timeouts
        Example of correcting an error during an Edit session
    Creating and dropping Db2 objects
      Working with the Create and Drop panels
        SQL Keywords
      Creating a database
      Creating a table space
        Table Space Type (Create Table Space)
        Table Space Allocation (Create Table Space)
        Data Storage (Create Table Space)
        Locking (Create Table Space)
        Data Sharing (Create Table Space)
        Partitions (Create Table Space)
      Creating a table
        Creating a table using a model
        Creating a table without using a model
        Table Creation options
        1. Columns (Create Table)
        2. Nulls and default values (Create Table)
        3. Options (Create Table)
        4. Unique constraints (Create Table)
        5. Referential constraints (Create Table)
          Column referential constraints and table referential constraints
        6. Check constraints (Create Table)
          Column check constraints and table check constraints
        7. Procedure exits (Create Table)
        8. Generate values (Create Table)
      Creating a view
      Creating an alias
      Creating an index
        Index type (Create Index)
        Index Column Selection (Create Index)
        Allocation (Create Index)
        Index (Create Index)
        Index Partitions (Create Index)
        Partition Values Option (Create Index)
      Creating a synonym
      Creating a distinct type
      Creating a function
        Parameters (Create Function)
        Parameter Types (Create Function)
        Returned Data Type (Create Function)
        Option List 1/2 (Create Function)
        Option List 2/2 (Create Function)
      Creating a procedure
        Procedure Parameters (Create Procedure)
        Parameter Types (Create Procedure)
        Option List 1/2 (Create Procedure)
        Option List 2/2 (Create Procedure)
      Creating a trigger
        Details (Create Trigger)
        Search Conditions (Create Trigger)
        SQL Statement (Create Trigger)
      Creating an auxiliary table
      Dropping Db2 objects
    Populating a Db2 table with data
      Editing the template
    Copying data
      Copying data from one Db2 object to another
        Specifying details for the "From" table
          Editing the template for the "From" table
        Specifying details for the "To" table
          Setting options for the current Copy session
          Running Copy in batch
      Copying data from a VSAM or QSAM file
        When (and when not) to use the Import utility
        Specifying details for the "From" data set
          Editing the template for the "From" data set
        Specifying details for the "To" table
          Running Import in batch
        Using a REXX procedure with the Import utility
        General information about REXX
          Overview of REXX expressions
          Comparison operators
          Arithmetic operators
          Logical (boolean) operators
          Useful functions
          Performance tips
          Examples
        Enhancing the Import utility using a REXX procedure
          Supplying a REXX procedure when using the Import utility
          How enhanced processing works
            Using templates with enhanced processing
            Dropping a record from further processing
          External REXX functions
            CHANGE
            CONTAINS
            FLD
            NCONTAIN
            PRINT
            PRTCOUNT
            RECSIN
            RECSOUT
            TALLY
            TM
            WRITE
          RETURN values
            DROP
            STOP
            STOP IMMEDIATE
      Copying data to a VSAM or QSAM file
        Specifying details for the "From" table
          Setting options for the current Export session
          Editing the template for the "From" table
        Specifying details for the "To" data set
          Exported data formats
          Running Export in batch
          Notes on using Export
        Copying data from a ZDT/Db2 editor session, or from an SQL statement
          Specifying the source for the exported data
          Specifying the format of the exported data
          Limiting the rows exported with a label range
          Differences compared with the export utility
          Ways that you can use the EXPORT primary command
      Scrambling data
        When can you scramble data?
        Scrambling rules
      How do I…?
        How do I copy data from one Db2 table to another on the same Db2 system?
        How do I copy data from one Db2 table to another on a different (connectable) Db2 system?
        How do I copy data from one Db2 table to another on a different (non-connectable) Db2 system?
        How do I copy and reorder selected data from a Db2 table to a sequential file?
        How do I define a copybook that describes data exported to a sequential file?
        How do I export data using a copybook that describes a different data format to that used by the ZDT/Db2 Export Utility?
    Working with lists of Db2 objects
      Displaying or printing a list of objects
      Working with object list panels
        Limiting the data displayed
          Using the filter line
          Using the operator line
        Locating a row or column in a list of Db2 objects
        Finding a string in a list of Db2 objects
        Using the line command area (Cmd)
          Line command
          Line command query (?)
          Equal (=)
          ROW
        Sorting the displayed data
    Printing
      Printing the contents of a Db2 table
        Formatting the print output
        Editing the template
        Running Print in batch
      Printing rows from a Db2 table
      Looking at the print output from your ZDT/Db2 session
      Printing an audit trail report
        Audit Trail Report
    Managing Db2 privileges
      Using the Manage Db2 Privileges panel
      Displaying privileges
      Granting privileges
      Revoking privileges
    Generating batch JCL for Db2 utility jobs
      Setting options for Db2 utilities
      Generating a LISTDEF statement in the Db2 utility job
      Generating a Db2 utility job
        Working with LISTDEF utility panels
      COPY utility
        Default values
        COPY (table spaces)
        COPY (index spaces)
      LOAD utility
        Input data
        Loading data using LOAD utility control statements
        Loading data described by a copybook or template
      REBUILD utility
        REBUILD utility (indexes)
        REBUILD utility (indexes for table spaces)
      RECOVER utility
        RECOVER (table spaces)
        RECOVER (index spaces)
      REORG utility
        REORG (table spaces)
        REORG (indexes)
      RUNSTATS utility
        RUNSTATS (table spaces)
        RUNSTATS (indexes)
      UNLOAD utility
        UNLOAD (tables)
          Null indicator byte processing
          UNLOAD (tables) with LISTDEF specified
        UNLOAD (table spaces)
          UNLOAD (table spaces) with LISTDEF specified
    Working with SQL statements
      Should you use basic or advanced SQL prototyping?
      Using basic SQL prototyping
        Specifying a predicate
        Example of using basic SELECT prototyping
      Using advanced SQL prototyping
        Tabbing and color-coding
          Syntax diagram color-coding
          Generated SELECT statement color-coding
        Using the advanced SELECT prototyping panels to build a SELECT statement
          Example 1 (Building a simple SQL statement)
        Changing the SQL statement
          Example 2 (Changing the SQL statement)
          Example 3 (Adding to the SQL statement)
          Example 4 (Removing part of the SQL statement)
        Handling repeatable items in the syntax
          Navigating through the repeatable items
          Inserting an extra repeatable item
          Changing a repeatable item
          Deleting a repeatable item
          Handling selectable repeat separators
          Points to consider when working with repeatable items
      Executing a SELECT statement after you have built it using prototyping
      Entering, executing, and explaining SQL statements
        Entering SQL statements
          Editing SQL
          Limiting the rows loaded into the ZDT/Db2 editor
          Scrolling the entry area
        Executing SQL statements
          SQL cost
          SQL errors
        Explaining SQL
          Additional considerations for EXPLAIN
      Editing and executing SQL statements from a data set
      Managing tables used by SQL explain
      Exiting SQL prototyping
    Interfacing with Db2 Interactive
  ZDT/Db2 reference
    Db2 data types
      Large objects (LOBs)
    ZDT/Db2 panels and fields
      Scrollable fields on ZDT/Db2 panels
      Action bar pull-down menu
      Additional LISTDEF Statements panel
      Additional TEMPLATE Statements panel
      Advanced SELECT Prototyping panel
      Alter Database panel
      Alter External Scalar Function panel
      Alter Index panel
      Alter Stored Procedure panel
      Alter Table panel
      Alter Table - ADD CHECK Constraint panel
      Alter Table - ADD Column panel
      Alter Table - ADD FOREIGN KEY Constraint panel
      Alter Table - ADD PRIMARY KEY panel
      Alter Table - AUDIT panel
      Alter Table - DATA CAPTURE panel
      Alter Table - DROP CHECK Constraint panel
      Alter Table - DROP FOREIGN KEY Constraint panel
      Alter Table - DROP PRIMARY KEY panel
      Alter Table - RESTRICT ON DROP panel
      Alter Table - VALIDPROC panel
      Alter Table Space panel
      Application Packages panel
      Application Plans panel
      Basic SELECT Prototyping panel
      Bind Application Plan panel
      Bind Package panel
      Children of Table panel
      Collections panel
      Column Attributes panel (alphanumeric)
      Column Attributes panel (DATE)
      Column Attributes panel (numeric)
      Column Attributes panel (TIME)
      Column Attributes panel (TIMESTAMP)
      Column Distribution panel
      Column Part Statistics panel
      Column Selection/Edit panel
      Columns panel
      Columns in Index panel
      Columns in Table panel
      Comment panels
      Compiler Language Selection panel
      Constraint Columns for panel
      Copy Options panel
      Copy Utility ("From") panel
      COPY Utility (Index Spaces) panel
      COPY Utility (Index Spaces) with LISTDEF panel
      Copy Utility ("To") panel
      COPY Utility (Table Spaces) panel
      COPY Utility (Table Spaces) with LISTDEF panel
      Create Alias panel
      Create Auxiliary Table panel
      Create Database panel
      Create Distinct Type panel
      Create Function: Option List (1/2) panel
      Create Function: Option List (2/2) panel
      Create Function panel
      Create Function: Parameter Types panel
      Create Function: Parameters panel
      Create Function: Returned Data Type panel
      Create Index panel
      Create Index: Allocation panel
      Create Index: Column Selection panel
      Create Index: Options panel
      Create Index: Partitions panel
      Create Index: Partition Values panel
      Create Index: Type panel
      Create Procedure panel
      Create Procedure: Option List (1/2) panel
      Create Procedure: Option List (2/2) panel
      Create Procedure: Parameter Types panel
      Create Procedure: Parameters panel
      Create Synonym panel
      Create Table panel
      Create Table Space panel
      Create Table Space: Allocation panel
      Create Table Space: Data Sharing Options panel
      Create Table Space: Data Storage Options panel
      Create Table Space: Define Partitions panel
      Create Table Space: Locking Options panel
      Create Table Space: Type panel
      Create Table: Column Check Constraints panel
      Create Table: Column Referential Constraints panel
      Create Table: Columns panel
      Create Table: Generate Values panel
      Create Table: Model Load panel
      Create Table: Nulls and Default Values panel
      Create Table: Options panel
      Create Table: Procedure Exits panel
      Create Table: Table Check Constraints panel
      Create Table: Table Referential Constraint panel
      Create Table: Table Referential Constraints panel
      Create Table: Unique Constraints panel
      Create Trigger panel
      Create Trigger: Details panel
      Create Trigger: Search Condition panel
      Create Trigger: SQL statement panel
      Create View panel
      Create View Source Statements panel
      Data Create Utility panel
      Database Request Modules panel
      Database Structure panel
      Databases panel
      Db2 Browse panel
      Db2 Edit panel
      Db2 Location Selection panel
      Db2 Object Functions panel
      Db2 Save Error Action panel
      Db2 Subsystem Selection panel
      Db2 Template Description panel
      Db2 Utilities panel
      Db2 View panel
      Db2I Primary Option Menu panel
      Details panels
      Display Row panel
      Distinct Types panel
      Drop panels
      Drop Confirmation panel
      Edit/Execute SQL (Data Set) panel
      Editor Options (1 of 8) panel
      Editor Options (2 of 8) panel
      Editor Options (3 of 8) panel
      Editor Options (4 of 8) panel
      Editor Options (5 of 8) panel
      Editor Options (6 of 8) panel
      Editor Options (7 of 8) panel
      Editor Options (8 of 8) panel
      Enter and Execute Db2 Commands panel
      Enter, Execute and Explain SQL Statements panel
      EXPLAIN Interpretation panel
      Explain Utilities panel
      Export Options (1 of 3) panel
      Export Options (2 of 3) panel
      Export Options (3 of 3) panel
      Export Utility ("From") panel
      Export Utility ("To") panel
      Field Selection/Edit panel
      ZDT/Db2 Release News panel
      Foreign Keys for Table panel
      Free Application Plan panel
      Free Package panel
      From Column Mapping panel
      Functions panel
      Grant privileges panels
      Import Options panel
      Import Utility ("From") panel
      Import Utility ("To") panel
      Index Parts panel
      Indexes panel
      Indexes and Columns for panel
      ISPF Primary Option panel
      ISPF Settings panel
      Label Column panel
      Label Table panel
      LISTCAT Output Display panel
      LISTDEF Options panel
      LOAD from panel
      LOAD Utility panel
      LOAD Utility panel using Db2 templates
      LOAD Utility - Using Templates panel
      LOAD Utility Options panel
      Manage Db2 Privileges panel
      Object List Line Commands panel
      Object List Options (1 of 2) panel
      Object List Options (2 of 2) panel
      Object List Utility panel
      OPTIONS Options panel
      Package Dependencies panel
      Package List panel
      Parents of Table panel
      Partitioned Table Statistics panel
      Plan Dependencies panel
      Plan Enabled/Disabled Connections panel
      Plan Table Rows panel
      Primary Key for Table panel
      Primary Option Menu panel
      Print Audit Trail panel
      Print Utility Options panel
      Print Utility panel
      Privilege details panels
      Privileges panels
      Rebind Application Plan panel
      Rebind Package panel
      REBUILD (Indexes for Table Spaces) panel
      REBUILD (Indexes for Table Spaces) with LISTDEF panel
      REBUILD Utility (Indexes) panel
      REBUILD (Indexes) with LISTDEF panel
      Record Type Selection panel
      RECOVER Utility (Index Spaces) panel
      RECOVER Utility (Index Spaces) with LISTDEF panel
      RECOVER Utility (Table Spaces) panel
      RECOVER Utility (Table Spaces) with LISTDEF panel
      Recovery Information panel
      Related tables panel
      Remote Db2 Location Selection panel
      REORG Utility (Indexes) panel
      REORG Utility (Indexes) with LISTDEF panel
      REORG Utility (Table Spaces) panel
      REORG Utility (Table Spaces) with LISTDEF panel
      Revoke privileges panels
      Routine Parameters panel
      Row Selection Criteria panel
      RUNSTATS Utility (Indexes) panel
      RUNSTATS Utility (Indexes) with LISTDEF panel
      RUNSTATS Utility (Table Spaces) panel
      RUNSTATS Utility (Table Spaces) with LISTDEF panel
      Schemas panel
      Scramble Exit Specification panel
      Select Statement Browse panel
      Select Statement Edit panel
      Sequences panel
      Set Batch Job Card Information panel
      Set COBOL Processing Options panel
      Set HLASM Processing Options panel
      Set Optimizer Hint panel
      Set Output Data Set Allocation Options panel
      Set PL/I Processing Options panel
      Set Print Processing Options panel
      Set Processing Options panel
      Set System Processing Options panel
      Set Temporary Data Set Allocation Options panel
      Set Trace options panel
      Set Utility Options panel
      Sort Fields panel
      SQL Prototyping, Execution and Analysis panel
      Statement Table Rows panel
      Storage Group(s) panel
      Storage Group Usage Privileges panel
      Stored Procedures panel
      Synonym Dependencies panel
      Synonyms panel
      Systems Options (1 of 4) panel
      Systems Options (2 of 4) panel
      Systems Options (3 of 4) panel
      Systems Options (4 of 4) panel
      Table Browse panel
      Table Check Constraint Dependencies panel
      Table Check Constraint Details panel
      Table Check Constraints panel
      Table Edit panel
      Table Edit (related) panel
      Table Selection panel
      Table Space Parts panel
      Table Spaces panel
      Table View panel
      Table/View/Alias Selection panel
      Tables, Views and Aliases panel
      TEMPLATE Options (1 of 2) panel
      TEMPLATE Options (2 of 2) panel
      Template Mapping panel
      Template Save panel
      Triggers panel
      UNLOAD Options panel
      UNLOAD Utility (Table Spaces) panel
      UNLOAD Utility (Table Spaces) with LISTDEF panel
      UNLOAD Utility (Tables) "From" panel
      UNLOAD Utility (Tables) "To" panel
      UNLOAD Utility (Tables) with LISTDEF panel
      Utility Functions panel
      Value List Edit panel
      Volumes panel
    ZDT/Db2 commands
      ABOUT primary command
      ALL primary command
      BACKWARD primary command
      BOTTOM primary command
      BROWSE primary command
      CANCEL primary command
      CAPS primary command
      CASE primary command
      CHANGE primary command
      COL primary command
      CHARPOS primary command
      DELCOL primary command
      DELETE primary command
      DESCRIBE primary command
      DESELECT primary command
      DOWN primary command
      EDIT primary command
      EDITCOL primary command
      END primary command
      EXCLUDE primary command
      EXECUTE primary command
      EXPAND primary command
      EXPLAIN primary command
      EXPORT primary command
      FILE primary command
      FIND primary command
      FMAP primary command
      FORMAT primary command
      FORWARD primary command
      FREE primary command
      FS primary command
      FT primary command
      HEX primary command
      HIDE primary command
      HINT primary command
      HOLD primary command
      INDEXINF primary command
      INSRPT primary command
      LEFT primary command
      LHEX primary command
      LOBBRWS primary command
      LOBEDIT primary command
      LOBLEN primary command
      LOBVIEW primary command
      LOCATE primary command
      NEW, NEWS primary command
      NEXT primary command
      NEXTRPT primary command
      ORDER primary command
      PB primary command
      PLAN primary command
      PREFIX primary command
      PREVIOUS primary command
      PREVRPT primary command
      PRINT primary command
      PROTCOL primary command
      PURGE primary command
      QUIT primary command
      RCHANGE primary command
      RD primary command
      REDIT primary command
      REFRESH primary command
      REFS primary command
      RESET primary command
      RFIND primary command
      RIGHT primary command
      RP primary command
      RUNTEMP primary command
      SAVE primary command
      SAVEAS primary command
      SHADOW primary command
      SHOW primary command
      SHOW primary command
      SHOWCOB primary command
      SORT primary command
      SQL primary command
      SQLID primary command
      TEDIT primary command
      TOP primary command
      TP primary command
      TYPE primary command
      UNDO primary command
      UP primary command
      VER primary command
      VIEW primary command
      WIDTH primary command
      XMLBRWS primary command
      XMLEDIT primary command
      XMLLEN primary command
      XMLVIEW primary command
      ZOOM primary command
    ZDT/Db2 functions
      How to use this reference chapter
      General tips about performance when you use Z Data Tools functions
      ZDT/Db2 batch functions
        BATSQL (Batch SQL) batch command
        DBC (Copy) batch command
        DBI (Import) batch command
        DBP (Print) batch command
        DBX (Export) batch command
        D2G (Data Generate) batch command
        D2TP (Template create/update) batch command
        Specifying a Db2 object name
        Specifying the template for a Db2 object
        Specifying the template/copybook for a data set
  ZDT/Db2 messages
    Messages
      HFMBF130
      HFMBF131
      HFMBF132
      HFMBF133
      HFMBF134
      HFMBF139
      HFMDA001
      HFMDA002
      HFMDA003
      HFMDA004
      HFMDA009
      HFMDA011
      HFMDA012
      HFMDA013
      HFMDA014
      HFMDA020
      HFMDA021
      HFMDA022
      HFMDA023
      HFMDA024
      HFMDA025
      HFMDA026
      HFMDA027
      HFMDA028
      HFMDA030
      HFMDA031
      HFMDA032
      HFMDA033
      HFMDA034
      HFMDA035
      HFMDA036
      HFMDA037
      HFMDA038
      HFMDA039
      HFMDA040
      HFMDA100
      HFMDA997
      HFMDA998
      HFMDB000
      HFMDB001
      HFMDB002
      HFMDB003
      HFMDB004
      HFMDB005
      HFMDB006
      HFMDB007
      HFMDB008
      HFMDB009
      HFMDB010
      HFMDB011
      HFMDB012
      HFMDB013
      HFMDB014
      HFMDB015
      HFMDB016
      HFMDB017
      HFMDB018
      HFMDB019
      HFMDB020
      HFMDB021
      HFMDB022
      HFMDB023
      HFMDB024
      HFMDB025
      HFMDB026
      HFMDB027
      HFMDB028
      HFMDB029
      HFMDB030
      HFMDB031
      HFMDB032
      HFMDB033
      HFMDB034
      HFMDB035
      HFMDB036
      HFMDB037
      HFMDB038
      HFMDB039
      HFMDB040
      HFMDB041
      HFMDB042
      HFMDB043
      HFMDB044
      HFMDB045
      HFMDB046
      HFMDB047
      HFMDB048
      HFMDB049
      HFMDB050
      HFMDB051
      HFMDB052
      HFMDB053
      HFMDB054
      HFMDB055
      HFMDB056
      HFMDB057
      HFMDB058
      HFMDB059
      HFMDB060
      HFMDB061
      HFMDB062
      HFMDB063
      HFMDB064
      HFMDB066
      HFMDB067
      HFMDB068
      HFMDB069
      HFMDB070
      HFMDB071
      HFMDB072
      HFMDB073
      HFMDB074
      HFMDB075
      HFMDB076
      HFMDB077
      HFMDB078
      HFMDB079
      HFMDB088
      HFMDB091
      HFMDB092
      HFMDB093
      HFMDB094
      HFMDB095
      HFMDB096
      HFMDB098
      HFMDB099
      HFMDB100
      HFMDB101
      HFMDB107
      HFMDB108
      HFMDB109
      HFMDB110
      HFMDB118
      HFMDB119
      HFMDB145
      HFMDB146
      HFMDB148
      HFMDB149
      HFMDB150
      HFMDB153
      HFMDB154
      HFMDB155
      HFMDB156
      HFMDB157
      HFMDB158
      HFMDB159
      HFMDB160
      HFMDB161
      HFMDB163
      HFMDB164
      HFMDB165
      HFMDB166
      HFMDB167
      HFMDB170
      HFMDB171
      HFMDB173
      HFMDB174
      HFMDB175
      HFMDB176
      HFMDB177
      HFMDB178
      HFMDB179
      HFMDB180
      HFMDB181
      HFMDB182
      HFMDB183
      HFMDB184
      HFMDB185
      HFMDB186
      HFMDB187
      HFMDB188
      HFMDB189
      HFMDB190
      HFMDB191
      HFMDB192
      HFMDB193
      HFMDB194
      HFMDB195
      HFMDB196
      HFMDB197
      HFMDB198
      HFMDB199
      HFMDB206
      HFMDB208
      HFMDB210
      HFMDB215
      HFMDB216
      HFMDB217
      HFMDB220
      HFMDB223
      HFMDB224
      HFMDB240
      HFMDB242
      HFMDB245
      HFMDB246
      HFMDB247
      HFMDB250
      HFMDB270
      HFMDB271
      HFMDB272
      HFMDB273
      HFMDB274
      HFMDB275
      HFMDB276
      HFMDB289
      HFMDB292
      HFMDB295
      HFMDB296
      HFMDB298
      HFMDB299
      HFMDB300
      HFMDB301
      HFMDB302
      HFMDB303
      HFMDB304
      HFMDB305
      HFMDB310
      HFMDB311
      HFMDB312
      HFMDB313
      HFMDB330
      HFMDB331
      HFMDB332
      HFMDB333
      HFMDB334
      HFMDB335
      HFMDB337
      HFMDB338
      HFMDB339
      HFMDB340
      HFMDB341
      HFMDB342
      HFMDB343
      HFMDB344
      HFMDB345
      HFMDB346
      HFMDB348
      HFMDB349
      HFMDB350
      HFMDB351
      HFMDB352
      HFMDB353
      HFMDB354
      HFMDB355
      HFMDB358
      HFMDB359
      HFMDB400
      HFMDB401
      HFMDB402
      HFMDB403
      HFMDB404
      HFMDB405
      HFMDB406
      HFMDB407
      HFMDB408
      HFMDB409
      HFMDB410
      HFMDB411
      HFMDB412
      HFMDB413
      HFMDB414
      HFMDB415
      HFMDB416
      HFMDB417
      HFMDB418
      HFMDB419
      HFMDB420
      HFMDB421
      HFMDB422
      HFMDB423
      HFMDB424
      HFMDB425
      HFMDB426
      HFMDB427
      HFMDB429
      HFMDB431
      HFMDB432
      HFMDB433
      HFMDB434
      HFMDB435
      HFMDB436
      HFMDB437
      HFMDB438
      HFMDB439
      HFMDB440
      HFMDB441
      HFMDB442
      HFMDB443
      HFMDB444
      HFMDB445
      HFMDB450
      HFMDB451
      HFMDB453
      HFMDB454
      HFMDB455
      HFMDB456
      HFMDB457
      HFMDB458
      HFMDB459
      HFMDB460
      HFMDB461
      HFMDB462
      HFMDB463
      HFMDB464
      HFMDB465
      HFMDB467
      HFMDB468
      HFMDB469
      HFMDB470
      HFMDB471
      HFMDB472
      HFMDB473
      HFMDB474
      HFMDB477
      HFMDB478
      HFMDB479
      HFMDB480
      HFMDB481
      HFMDB482
      HFMDB483
      HFMDB484
      HFMDB490
      HFMDB491
      HFMDB500
      HFMDB501
      HFMDB502
      HFMDB503
      HFMDB504
      HFMDB505
      HFMDB506
      HFMDB507
      HFMDB508
      HFMDB509
      HFMDB510
      HFMDB511
      HFMDB512
      HFMDB519
      HFMDB520
      HFMDB521
      HFMDB530
      HFMDB531
      HFMDB532
      HFMDB533
      HFMDB534
      HFMDB535
      HFMDB536
      HFMDB537
      HFMDB538
      HFMDB539
      HFMDB540
      HFMDB541
      HFMDB542
      HFMDB543
      HFMDB544
      HFMDB545
      HFMDB546
      HFMDB550
      HFMDB551
      HFMDB552
      HFMDB553
      HFMDB554
      HFMDB560
      HFMDB561
      HFMDB600
      HFMDB601
      HFMDB602
      HFMDB650
      HFMDB651
      HFMDB652
      HFMDB653
      HFMDB654
      HFMDB655
      HFMDB656
      HFMDB657
      HFMDB658
      HFMDB659
      HFMDB660
      HFMDB661
      HFMDB662
      HFMDB663
      HFMDB664
      HFMDB665
      HFMDB670
      HFMDB671
      HFMDB672
      HFMDB673
      HFMDB674
      HFMDB675
      HFMDB700
      HFMDB701
      HFMDB702
      HFMDB703
      HFMDB707
      HFMDB708
      HFMDB709
      HFMDB710
      HFMDB711
      HFMDB712
      HFMDB720
      HFMDB721
      HFMDB722
      HFMDB723
      HFMDB730
      HFMDB731
      HFMDB732
      HFMDB733
      HFMDB734
      HFMDB735
      HFMDB736
      HFMDB737
      HFMDB738
      HFMDB739
      HFMDB740
      HFMDB741
      HFMDB742
      HFMDB750
      HFMDB751
      HFMDB752
      HFMDB753
      HFMDB754
      HFMDB755
      HFMDB756
      HFMDB757
      HFMDB758
      HFMDB759
      HFMDB760
      HFMDB761
      HFMDB762
      HFMDB763
      HFMDB764
      HFMDB765
      HFMDB768
      HFMDB769
      HFMDB770
      HFMDB771
      HFMDB772
      HFMDB773
      HFMDB774
      HFMDB775
      HFMDB776
      HFMDB777
      HFMDB778
      HFMDB779
      HFMDB780
      HFMDB781
      HFMDB782
      HFMDB783
      HFMDB784
      HFMDB785
      HFMDB786
      HFMDB787
      HFMDB788
      HFMDB789
      HFMDB790
      HFMDB791
      HFMDB792
      HFMDB800
      HFMDB801
      HFMDB802
      HFMDB803
      HFMDB804
      HFMDB805
      HFMDB806
      HFMDB807
      HFMDB808
      HFMDB809
      HFMDB810
      HFMDB811
      HFMDB812
      HFMDB813
      HFMDB814
      HFMDB815
      HFMDB816
      HFMDB817
      HFMDB818
      HFMDB819
      HFMDB826
      HFMDB827
      HFMDB828
      HFMDB829
      HFMDB831
      HFMDB832
      HFMDB833
      HFMDB835
      HFMDB836
      HFMDB837
      HFMDB838
      HFMDB839
      HFMDB840
      HFMDB841
      HFMDB842
      HFMDB843
      HFMDB844
      HFMDB845
      HFMDB846
      HFMDB847
      HFMDB848
      HFMDB849
      HFMDB850
      HFMDB851
      HFMDB852
      HFMDB853
      HFMDB855
      HFMDB856
      HFMDB858
      HFMDB859
      HFMDB860
      HFMDB861
      HFMDB862
      HFMDB863
      HFMDB864
      HFMDB865
      HFMDB866
      HFMDB867
      HFMDB868
      HFMDB869
      HFMDB870
      HFMDB871
      HFMDB872
      HFMDB873
      HFMDB874
      HFMDB875
      HFMDB879
      HFMDB890
      HFMDB900
      HFMDB903
      HFMDB904
      HFMDB905
      HFMDB907
      HFMDB909
      HFMDB910
      HFMDB911
      HFMDB913
      HFMDB914
      HFMDB915
      HFMDB916
      HFMDB917
      HFMDB918
      HFMDB919
      HFMDB921
      HFMDB922
      HFMDB923
      HFMDB924
      HFMDB925
      HFMDB926
      HFMDB927
      HFMDB928
      HFMDB939
      HFMDB940
      HFMDB941
      HFMDB942
      HFMDB943
      HFMDB944
      HFMDB945
      HFMDB946
      HFMDB947
      HFMDB948
      HFMDB949
      HFMDB950
      HFMDB951
      HFMDB952
      HFMDB953
      HFMDB954
      HFMDB955
      HFMDB956
      HFMDB957
      HFMDB958
      HFMDB959
      HFMDB960
      HFMDB961
      HFMDB962
      HFMDB963
      HFMDB964
      HFMDB965
      HFMDB966
      HFMDB967
      HFMDB968
      HFMDB969
      HFMDB970
      HFMDB971
      HFMDB972
      HFMDB973
      HFMDB974
      HFMDB980
      HFMDB981
      HFMDB990
      HFMDB991
      HFMDB992
      HFMDB993
      HFMDB994
      HFMDC000
      HFMDC001
      HFMDC002
      HFMDC010
      HFMDC011
      HFMDC012
      HFMDC013
      HFMDC014
      HFMDC015
      HFMDC019
      HFMDC020
      HFMDC021
      HFMDC022
      HFMDC023
      HFMDC026
      HFMDC027
      HFMDC028
      HFMDC030
      HFMDC031
      HFMDC032
      HFMDC033
      HFMDC034
      HFMDC035
      HFMDC036
      HFMDC037
      HFMDC038
      HFMDC039
      HFMDC040
      HFMDC041
      HFMDC042
      HFMDC043
      HFMDC044
      HFMDC045
      HFMDC046
      HFMDC047
      HFMDC048
      HFMDC049
      HFMDC050
      HFMDC051
      HFMDC052
      HFMDC053
      HFMDC054
      HFMDC055
      HFMDC056
      HFMDC057
      HFMDC058
      HFMDC059
      HFMDC060
      HFMDC062
      HFMDC100
      HFMDC101
      HFMDC102
      HFMDC103
      HFMDC104
      HFMDC105
      HFMDC106
      HFMDC107
      HFMDC108
      HFMDC110
      HFMDC111
      HFMDC112
      HFMDC113
      HFMDC114
      HFMDC170
      HFMDC171
      HFMDC172
      HFMDC174
      HFMDC180
      HFMDC181
      HFMDC182
      HFMDC183
      HFMDC184
      HFMDC185
      HFMDC186
      HFMDC187
      HFMDC188
      HFMDC189
      HFMDC190
      HFMDC191
      HFMDC192
      HFMDC193
      HFMDC194
      HFMDC195
      HFMDC196
      HFMDC197
      HFMDC198
      HFMDC199
      HFMDC200
      HFMDC201
      HFMDC202
      HFMDC203
      HFMDC204
      HFMDC206
      HFMDC207
      HFMDC208
      HFMDC209
      HFMDC210
      HFMDC211
      HFMDC220
      HFMDC221
      HFMDC230
      HFMDC500
      HFMDC510
      HFMDC520
      HFMDC521
      HFMDC531
      HFMDC533
      HFMDC534
      HFMDC535
      HFMDC536
      HFMDC539
      HFMDC540
      HFMDC541
      HFMDC542
      HFMDC543
      HFMDC544
      HFMDC545
      HFMDC546
      HFMDC547
      HFMDC548
      HFMDC549
      HFMDC550
      HFMDC551
      HFMDC552
      HFMDC553
      HFMDC554
      HFMDC555
      HFMDC556
      HFMDC557
      HFMDC558
      HFMDC559
      HFMDC570
      HFMDC571
      HFMDC572
      HFMDC573
      HFMDC574
      HFMDC578
      HFMDC579
      HFMDC580
      HFMDC581
      HFMDC583
      HFMDC584
      HFMDC585
      HFMDC586
      HFMDC587
      HFMDC588
      HFMDC590
      HFMDC591
      HFMDC592
      HFMDC593
      HFMDC594
      HFMDC595
      HFMDC596
      HFMDC597
      HFMDC598
      HFMDC599
      HFMDC600
      HFMDC601
      HFMDC602
      HFMDC603
      HFMDC604
      HFMDC605
      HFMDC606
      HFMDC607
      HFMDC608
      HFMDC609
      HFMDC610
      HFMDC611
      HFMDC612
      HFMDC613
      HFMDC614
      HFMDC615
      HFMDC616
      HFMDC620
      HFMDC621
      HFMDC622
      HFMDC623
      HFMDC624
      HFMDC625
      HFMDC626
      HFMDC627
      HFMDC628
      HFMDC629
      HFMDC630
      HFMDC631
      HFMDC632
      HFMDC633
      HFMDC634
      HFMDC635
      HFMDC636
      HFMDC637
      HFMDC638
      HFMDC640
      HFMDC641
      HFMDC642
      HFMDC643
      HFMDC644
      HFMDC645
      HFMDC646
      HFMDC647
      HFMDC648
      HFMDC649
      HFMDC651
      HFMDC660
      HFMDC661
      HFMDC662
      HFMDC663
      HFMDC664
      HFMDC665
      HFMDC666
      HFMDC667
      HFMDC668
      HFMDC670
      HFMDC671
      HFMDC672
      HFMDC673
      HFMDC680
      HFMDC690
      HFMDC691
      HFMDC700
      HFMDC701
      HFMDC702
      HFMDC703
      HFMDC704
      HFMDC705
      HFMDC710
      HFMDC711
      HFMDC712
      HFMDC713
      HFMDC714
      HFMDC715
      HFMDC716
      HFMDC720
      HFMDC721
      HFMDC722
      HFMDC723
      HFMDC724
      HFMDC725
      HFMDC726
      HFMDC730
      HFMDC731
      HFMDC732
      HFMDC733
      HFMDC740
      HFMDD000
      HFMDD001
      HFMDD002
      HFMDD003
      HFMDD004
      HFMDD005
      HFMDD006
      HFMDD007
      HFMDD008
      HFMDD009
      HFMDD010
      HFMDD011
      HFMDD012
      HFMDD018
      HFMDD020
      HFMDD022
      HFMDD028
      HFMDD029
      HFMDD100
      HFMDD501
      HFMDD502
      HFMDD503
      HFMDD504
      HFMDD505
      HFMDD506
      HFMDD507
      HFMDD508
      HFMDD510
      HFMDD511
      HFMDD540
      HFMDD541
      HFMDD542
      HFMDD590
      HFMDD591
      HFMDD592
      HFMDD593
      HFMDD594
      HFMDD595
      HFMDD596
      HFMDD597
      HFMDE495
      HFMDE540
      HFMDE541
      HFMDE542
      HFMDE543
      HFMDE544
      HFMDE545
      HFMDE590
      HFMDE591
      HFMDE592
      HFMDE593
      HFMDE594
      HFMDE595
      HFMDE596
      HFMDE597
      HFMDE690
      HFMDE691
      HFMDE692
      HFMDE693
      HFMDE694
      HFMDE695
      HFMDF590
      HFMDF591
      HFMDF592
      HFMDF593
      HFMDF594
      HFMDF595
      HFMDF596
      HFMDF597
      HFMDH000
      HFMDH001
      HFMDH002
      HFMDH010
      HFMDH011
      HFMDH012
      HFMDH013
      HFMDH014
      HFMDH015
      HFMDH016
      HFMDH017
      HFMDH018
      HFMDH019
      HFMDH020
      HFMDH021
      HFMDH022
      HFMDH023
      HFMDH024
      HFMDH025
      HFMDH026
      HFMDH027
      HFMDH028
      HFMDH029
      HFMDH030
      HFMDH031
      HFMDH040
      HFMDH041
      HFMDH042
      HFMDH043
      HFMDH044
      HFMDH045
      HFMDH046
      HFMDH047
      HFMDH048
      HFMDH049
      HFMDH050
      HFMDH060
      HFMDH061
      HFMDH062
      HFMDH063
      HFMDH064
      HFMDH065
      HFMDH066
      HFMDH067
      HFMDH068
      HFMDI000
      HFMDI001
      HFMDI002
      HFMDI003
      HFMDI004
      HFMDI010
      HFMDI011
      HFMDI012
      HFMDI013
      HFMDI015
      HFMDI016
      HFMDI017
      HFMDI018
      HFMDI020
      HFMDI021
      HFMDI022
      HFMDI023
      HFMDI024
      HFMDI025
      HFMDI026
      HFMDI027
      HFMDI030
      HFMDI031
      HFMDI032
      HFMDI035
      HFMDI036
      HFMDI037
      HFMDI040
      HFMDI041
      HFMDI042
      HFMDI043
      HFMDI044
      HFMDI045
      HFMDI046
      HFMDI047
      HFMDI050
      HFMDI051
      HFMDI052
      HFMDI053
      HFMDI054
      HFMDI055
      HFMDI056
      HFMDJ000
      HFMDJ001
      HFMDJ002
      HFMDJ003
      HFMDJ004
      HFMDJ005
      HFMDJ006
      HFMDJ007
      HFMDJ008
      HFMDJ009
      HFMDJ010
      HFMDJ011
      HFMDJ019
      HFMDJ090
      HFMDJ091
      HFMDJ092
      HFMDJ093
      HFMDJ094
      HFMDJ095
      HFMDJ100
      HFMDJ101
      HFMDJ102
      HFMDJ103
      HFMDJ104
      HFMDJ105
      HFMDJ106
      HFMDJ107
      HFMDJ108
      HFMDJ109
      HFMDJ110
      HFMDJ111
      HFMDJ112
      HFMDJ113
      HFMDJ114
      HFMDJ115
      HFMDJ120
      HFMDJ121
      HFMDJ122
      HFMDJ123
      HFMDJ124
      HFMDJ125
      HFMDJ126
      HFMDJ127
      HFMDJ128
      HFMDJ129
      HFMDJ130
      HFMDJ131
      HFMDJ132
      HFMDJ133
      HFMDJ134
      HFMDJ140
      HFMDJ141
      HFMDJ142
      HFMDJ143
      HFMDJ144
      HFMDJ145
      HFMDJ146
      HFMDJ147
      HFMDJ148
      HFMDJ150
      HFMDJ151
      HFMDJ152
      HFMDJ153
      HFMDJ154
      HFMDJ155
      HFMDJ156
      HFMDJ157
      HFMDJ158
      HFMDJ159
      HFMDJ161
      HFMDJ162
      HFMDJ170
      HFMDJ171
      HFMDJ172
      HFMDJ173
      HFMDJ174
      HFMDJ175
      HFMDJ176
      HFMDJ177
      HFMDJ178
      HFMDJ179
      HFMDJ180
      HFMDJ181
      HFMDJ184
      HFMDJ185
      HFMDJ186
      HFMDJ187
      HFMDJ189
      HFMDJ190
      HFMDJ191
      HFMDJ192
      HFMDJ200
      HFMDJ201
      HFMDJ202
      HFMDJ203
      HFMDJ204
      HFMDJ205
      HFMDJ206
      HFMDJ207
      HFMDJ208
      HFMDJ209
      HFMDJ210
      HFMDJ211
      HFMDJ212
      HFMDJ213
      HFMDJ214
      HFMDJ215
      HFMDJ216
      HFMDJ217
      HFMDJ218
      HFMDJ219
      HFMDJ220
      HFMDJ221
      HFMDJ222
      HFMDJ223
      HFMDJ224
      HFMDJ225
      HFMDJ226
      HFMDJ227
      HFMDJ228
      HFMDJ229
      HFMDJ230
      HFMDJ231
      HFMDJ232
      HFMDJ233
      HFMDJ234
      HFMDJ235
      HFMDJ236
      HFMDJ237
      HFMDJ240
      HFMDJ241
      HFMDJ242
      HFMDJ243
      HFMDJ244
      HFMDJ245
      HFMDJ246
      HFMDJ247
      HFMDJ248
      HFMDJ250
      HFMDJ251
      HFMDJ252
      HFMDJ253
      HFMDJ254
      HFMDJ255
      HFMDJ256
      HFMDJ257
      HFMDJ258
      HFMDJ260
      HFMDJ261
      HFMDJ262
      HFMDJ263
      HFMDJ264
      HFMDJ265
      HFMDJ266
      HFMDJ267
      HFMDJ268
      HFMDJ269
      HFMDJ270
      HFMDJ271
      HFMDJ272
      HFMDJ279
      HFMDJ28x
      HFMDJ280
      HFMDJ290
      HFMDJ291
      HFMDJ300
      HFMDJ301
      HFMDJ302
      HFMDJ303
      HFMDJ309
      HFMDJ310
      HFMDJ311
      HFMDJ312
      HFMDJ313
      HFMDJ314
      HFMDJ320
      HFMDJ321
      HFMDJ322
      HFMDJ323
      HFMDJ324
      HFMDJ325
      HFMDJ326
      HFMDJ329
      HFMDJ330
      HFMDJ340
      HFMDJ341
      HFMDJ342
      HFMDJ343
      HFMDJ344
      HFMDJ350
      HFMDJ351
      HFMDJ352
      HFMDJ356
      HFMDJ357
      HFMDJ358
      HFMDJ360
      HFMDJ361
      HFMDJ362
      HFMDJ363
      HFMDJ364
      HFMDJ365
      HFMDJ366
      HFMDJ367
      HFMDJ368
      HFMDJ370
      HFMDJ371
      HFMDJ372
      HFMDJ373
      HFMDJ374
      HFMDJ380
      HFMDJ381
      HFMDJ382
      HFMDJ390
      HFMDJ400
      HFMDJ401
      HFMDJ402
      HFMDJ403
      HFMDJ404
      HFMDJ405
      HFMDJ406
      HFMDJ407
      HFMDJ411
      HFMDJ412
      HFMDJ413
      HFMDJ420
      HFMDJ421
      HFMDJ422
      HFMDJ423
      HFMDJ424
      HFMDJ425
      HFMDJ430
      HFMDJ431
      HFMDJ432
      HFMDJ433
      HFMDJ434
      HFMDJ435
      HFMDJ436
      HFMDJ437
      HFMDJ438
      HFMDJ439
      HFMDJ440
      HFMDJ441
      HFMDJ442
      HFMDJ450
      HFMDJ451
      HFMDJ452
      HFMDJ459
      HFMDJ460
      HFMDJ461
      HFMDJ462
      HFMDJ500
      HFMDJ501
      HFMDJ502
      HFMDJ503
      HFMDJ504
      HFMDJ505
      HFMDJ506
      HFMDJ507
      HFMDJ508
      HFMDJ509
      HFMDJ510
      HFMDJ511
      HFMDJ512
      HFMDJ513
      HFMDJ514
      HFMDJ515
      HFMDJ516
      HFMDJ517
      HFMDJ518
      HFMDJ519
      HFMDJ520
      HFMDJ521
      HFMDJ522
      HFMDJ523
      HFMDJ524
      HFMDJ525
      HFMDJ526
      HFMDJ527
      HFMDJ528
      HFMDJ529
      HFMDJ530
      HFMDJ531
      HFMDJ532
      HFMDJ533
      HFMDJ534
      HFMDJ535
      HFMDJ536
      HFMDJ537
      HFMDJ538
      HFMDJ539
      HFMDJ540
      HFMDJ541
      HFMDJ542
      HFMDJ543
      HFMDJ544
      HFMDJ545
      HFMDJ546
      HFMDJ547
      HFMDJ548
      HFMDJ549
      HFMDJ550
      HFMDJ551
      HFMDJ552
      HFMDJ553
      HFMDJ554
      HFMDJ555
      HFMDJ556
      HFMDJ557
      HFMDJ558
      HFMDJ559
      HFMDJ560
      HFMDJ561
      HFMDJ562
      HFMDJ563
      HFMDJ564
      HFMDJ565
      HFMDJ566
      HFMDJ567
      HFMDJ568
      HFMDJ569
      HFMDJ570
      HFMDJ571
      HFMDJ572
      HFMDJ573
      HFMDJ574
      HFMDJ575
      HFMDJ576
      HFMDJ577
      HFMDJ578
      HFMDJ580
      HFMDJ581
      HFMDJ582
      HFMDJ583
      HFMDJ584
      HFMDJ585
      HFMDJ586
      HFMDJ587
      HFMDJ588
      HFMDJ589
      HFMDJ590
      HFMDJ591
      HFMDJ595
      HFMDJ596
      HFMDJ597
      HFMDJ599
      HFMDJ600
      HFMDJ601
      HFMDJ602
      HFMDJ603
      HFMDJ606
      HFMDJ607
      HFMDJ608
      HFMDJ609
      HFMDJ610
      HFMDJ611
      HFMDJ612
      HFMDJ614
      HFMDJ615
      HFMDJ616
      HFMDJ620
      HFMDJ621
      HFMDJ622
      HFMDJ623
      HFMDJ624
      HFMDJ625
      HFMDJ626
      HFMDJ627
      HFMDJ628
      HFMDJ629
      HFMDJ630
      HFMDJ631
      HFMDJ632
      HFMDJ633
      HFMDJ634
      HFMDJ635
      HFMDJ640
      HFMDJ641
      HFMDJ642
      HFMDJ643
      HFMDJ644
      HFMDJ645
      HFMDJ646
      HFMDJ647
      HFMDJ648
      HFMDJ649
      HFMDJ650
      HFMDJ651
      HFMDJ652
      HFMDJ653
      HFMDJ654
      HFMDJ655
      HFMDJ660
      HFMDJ670
      HFMDJ671
      HFMDJ672
      HFMDJ673
      HFMDJ674
      HFMDJ675
      HFMDJ680
      HFMDJ681
      HFMDJ682
      HFMDJ683
      HFMDJ684
      HFMDJ685
      HFMDJ686
      HFMDJ687
      HFMDJ688
      HFMDJ689
      HFMDJ690
      HFMDJ691
      HFMDJ692
      HFMDJ693
      HFMDJ700
      HFMDJ701
      HFMDJ702
      HFMDJ703
      HFMDJ704
      HFMDJ705
      HFMDJ706
      HFMDJ707
      HFMDJ710
      HFMDJ711
      HFMDJ712
      HFMDJ713
      HFMDJ714
      HFMDJ720
      HFMDJ721
      HFMDJ730
      HFMDJ731
      HFMDJ732
      HFMDJ733
      HFMDJ734
      HFMDJ735
      HFMDJ738
      HFMDJ739
      HFMDJ740
      HFMDJ741
      HFMDJ742
      HFMDJ750
      HFMDJ751
      HFMDJ752
      HFMDJ753
      HFMDJ754
      HFMDJ755
      HFMDJ760
      HFMDJ765
      HFMDJ999
  Notices
    Programming interface information
  About this document
    Who should use this document
    Releases of Db2 supported
    National characters
    Prerequisite and related information
    How to read syntax diagrams
  Working with ZDT/Db2
    ZDT/Db2 overview
      What you can do with ZDT/Db2
      Templates
        What is a template?
        Where you can use templates
    Getting started with ZDT/Db2
      Starting and exiting ZDT/Db2
        TSO region size
        Starting ZDT/Db2
        Checking your ZDT/Db2 version
        Checking which COBOL compiler you're using
        Exiting from ZDT/Db2
      Selecting the Db2 subsystem when more than one is available
        Selecting the Db2 subsystem with the Db2 SSID field
        Selecting the Db2 subsystem by entering the SSID command
        Using the Db2 Subsystem Selection menu
          Selecting a subsystem
          Refreshing the list of Db2 subsystems
          Restricting the list of Db2 subsystems
      Using the ZDT/Db2 interface
        Navigating in ZDT/Db2
        ZDT/Db2 panel features
          Selecting an item from the action bar
        Screen size
        Scrollable input and display fields for long names
          Working with scrollable input fields
            Deleting data in scrollable input fields
          Working with scrollable display fields
        Selecting options on ZDT/Db2 panels
        Specifying a Db2 object name
          Using an asterisk (*) or a pattern in entry fields
        Specifying the SQLID
        Specifying a data set and a member name
          Examples of data set name patterns
          Examples of specifying a member name or pattern
        Canceling long-running Db2 queries
      Getting help
        Accessing Tutorial Help
        Displaying field-level help information
        Displaying the expanded form of error messages
      Setting default processing options
        System Options (option 0)
        Print settings (option 0.1)
        ZDT/Db2 system options (option 0.2)
        Job card specifications (option 0.3)
        Compiler language selection (option 0.4)
        COBOL compiler specifications (option 0.5)
        HLASM compiler specifications (option 0.6)
        PL/I compiler specifications (option 0.7)
        Temporary Data Set Allocations (option 0.8)
        Output Data Set Allocations (option 0.9)
        Trace options (option 0.10)
        ISPF settings (option 0.11)
        View and Edit options (options 1 and 2)
        Utilities (option 3)
        Print utility options (option 3.1)
        Copy utility options (option 3.3)
        Object List Options (option 3.4)
        Export utility options (option 3.7)
        Db2 LOAD utility options (option 3.L)
        Db2 Utility LISTDEF options (option 3.UL)
        Db2 Utility OPTIONS options (option 3.UO)
        Db2 Utility TEMPLATE options (option 3.UT)
        Db2 Unload utility options (option 3.UU)
        Displaying or editing DBCS characters
      SAF-rule controlled auditing
        Determining when SAF-rule controlled auditing is in effect
        SAF rules for auditing
        SAF-rule controlled auditing not in effect
        SAF-rule controlled auditing in effect, no auditing
        SAF-rule controlled auditing in effect, auditing possible
    Working with templates
      Associating a template with a Db2 object
      Information stored in a template
        Printing a template
      Using templates with non-Db2 data
        How ZDT/Db2 compiles a copybook into a template
        Support for COBOL data description entries
        Support for HLASM data description entries
        Support for PL/I data description entries
        Support for variable-length arrays
      Editing a template
        Adding a description to a template
      Selecting rows
        Row selection by column
          Changing the display (80-character screens only)
          Verifying the format of DATE, TIME, and TIMESTAMP columns
        Row selection criteria in freeform style
        Scrolling the Row Selection Criteria field
        Expanding the Row Selection Criteria field
        Using the SQL Edit session
          Making changes
          Saving changes
          Long WHERE clauses
      Manipulating columns
        Selecting columns
          Toggling the selection status of more than one column at a time
        Holding columns (when scrolling left or right)
          Toggling the hold status of more than one column at a time
        Changing the sequence of displayed or printed data
          Changing the sequence of displayed or printed columns
          Changing the sequence of displayed or printed rows
        Changing column attributes
          Changing the attributes for an alphanumeric column
            Changing the column heading
            Changing the output width
          Changing the attributes for a numeric column
            Changing the output width
            Showing leading zeros
        ROWID columns
      Specifying scrambling options
        Selecting a column for specifying scrambling options
          Specifying the scramble type
          Specifying the value option
          Specifying value input and out columns
          Specifying range values
          Specifying a value data set name
          Specifying and editing a value list
      Mapping data
        Where you can map data
        Letting ZDT/Db2 do the mapping
        Specifying your own mapping
          Setting up mapping for a column
          Changing the attributes for a "To" column
          Creating data for a column
          Mapping using different templates
          Mapping contiguous columns
        Column mapping rules
      Creating a copybook from a ZDT/Db2 Template
    Viewing and changing Db2 data
      ZDT/Db2 editor sessions
        Starting a ZDT/Db2 editor session
        Specifying the editor session mode: "normal mode" or "large mode"
          Choosing the appropriate editor mode
        Specifying the start position for your ZDT/Db2 editor session
        Setting options for the current ZDT/Db2 editor session
        Validating and saving changes with a ZDT/Db2 editor session
          Ordering of rows within a Db2 object is not guaranteed
          Viewing and changing LOB data and XML documents
            XML differences
          Db2-related considerations when changing data in a ZDT/Db2 Edit session
        Ending a ZDT/Db2 editor session
        Starting another ZDT/Db2 editor session
      Specifying the Db2 object you want to view
      Restricting the data that ZDT/Db2 loads from Db2
        Storage considerations
        Viewing large tables or views
          Restricting the rows to view by specifying row selection criteria
          Interactively developing row selection criteria
          Restricting the rows to view with the "Row count" entry field
          Restricting the rows to view with the "Start position" entry field
          Using Select Statement Edit to limit the data retrieved by ZDT/Db2
      Viewing data in a ZDT/Db2 editor session
        Count of rows fetched in a ZDT/Db2 editor session
        Locating a row
        Locating a column
          Specifying the column number or column name
            Using the FLD parameter
          Specifying the search direction and starting point
            Using the NEXT parameter
            Using the PREV parameter
            Using the FIRST parameter
            Using the LAST parameter
        Finding a string
          Repeating the search
          Handling long strings
        Finding data within specific columns
          Specifying a list of columns
          Specifying ranges of columns
        Finding a string within specific portions of the data
        Finding data within excluded or non-excluded rows
        Finding data within a label range
          Assigning labels to rows
        Searching numeric columns
        Changing the view of displayed data
          Selecting a display format
          TABL display format
          SNGL display format
          Zooming in to see all of a row
          Scrolling
            Controlling how far you scroll
            Scrolling to the first or last row or column
          Excluding rows
            Showing or hiding excluded rows
          Sorting the data
          Displaying data in hexadecimal format
          Managing the prefix area
          Displaying the column number
          Displaying the data type
      Handling special data
        DATE and TIME columns
          DATE columns
          TIME columns
        Large numeric fields
        Working with large tables
          SQL optimization options
          Large table options
          Data sampling
            Clustered data sampling
            Random data sampling
        Null values and VARCHAR processing
          Null column indicator character
          Varying-length columns
        Unicode data
      Changing data
        Installation settings that affect CAPS
        Changing data by overtyping
        Changing data with the CHANGE command
          "From" and "To" strings of different lengths
          Handling long strings
          Changing numeric columns
          Changing data within excluded or non-excluded rows
          Changing data within a label range
          Limiting the change to specific portions of the data
        Changing data using prefix commands
          Overlaying data in existing rows
        Converting data to uppercase
        "Read-only" views, non-updateable columns
      Deleting rows
        Deleting rows within excluded or non-excluded rows
        Deleting rows within a label range
      Editing related tables
        Listing related tables
        Self-referencing constraints
        Referential integrity errors
        Starting an Edit session of a related table
        Differences when you edit a related table
        Differences when saving or canceling while editing a related table
        Navigating between Edit sessions
        Deleting a primary key
        Inserting a new foreign key
        Updating a primary key
        Adding a primary key
      Issuing Db2 commands from within a ZDT/Db2 session
        Issuing Db2 commands from the Enter and Execute Db2 Commands panel
        Issuing Db2 commands from the command line
      Handling errors during an Edit session
        Determining why an error occurred
        "Duplicate Row" errors
        "No Primary Key" errors
        "Delete Restrict Rule" errors
        "Check Constraint" errors
        "Row Not Found" errors
        Deadlocks or timeouts
        Example of correcting an error during an Edit session
    Creating and dropping Db2 objects
      Working with the Create and Drop panels
        SQL Keywords
      Creating a database
      Creating a table space
        Table Space Type (Create Table Space)
        Table Space Allocation (Create Table Space)
        Data Storage (Create Table Space)
        Locking (Create Table Space)
        Data Sharing (Create Table Space)
        Partitions (Create Table Space)
      Creating a table
        Creating a table using a model
        Creating a table without using a model
        Table Creation options
        1. Columns (Create Table)
        2. Nulls and default values (Create Table)
        3. Options (Create Table)
        4. Unique constraints (Create Table)
        5. Referential constraints (Create Table)
          Column referential constraints and table referential constraints
        6. Check constraints (Create Table)
          Column check constraints and table check constraints
        7. Procedure exits (Create Table)
        8. Generate values (Create Table)
      Creating a view
      Creating an alias
      Creating an index
        Index type (Create Index)
        Index Column Selection (Create Index)
        Allocation (Create Index)
        Index (Create Index)
        Index Partitions (Create Index)
        Partition Values Option (Create Index)
      Creating a synonym
      Creating a distinct type
      Creating a function
        Parameters (Create Function)
        Parameter Types (Create Function)
        Returned Data Type (Create Function)
        Option List 1/2 (Create Function)
        Option List 2/2 (Create Function)
      Creating a procedure
        Procedure Parameters (Create Procedure)
        Parameter Types (Create Procedure)
        Option List 1/2 (Create Procedure)
        Option List 2/2 (Create Procedure)
      Creating a trigger
        Details (Create Trigger)
        Search Conditions (Create Trigger)
        SQL Statement (Create Trigger)
      Creating an auxiliary table
      Dropping Db2 objects
    Populating a Db2 table with data
      Editing the template
    Copying data
      Copying data from one Db2 object to another
        Specifying details for the "From" table
          Editing the template for the "From" table
        Specifying details for the "To" table
          Setting options for the current Copy session
          Running Copy in batch
      Copying data from a VSAM or QSAM file
        When (and when not) to use the Import utility
        Specifying details for the "From" data set
          Editing the template for the "From" data set
        Specifying details for the "To" table
          Running Import in batch
        Using a REXX procedure with the Import utility
        General information about REXX
          Overview of REXX expressions
          Comparison operators
          Arithmetic operators
          Logical (boolean) operators
          Useful functions
          Performance tips
          Examples
        Enhancing the Import utility using a REXX procedure
          Supplying a REXX procedure when using the Import utility
          How enhanced processing works
            Using templates with enhanced processing
            Dropping a record from further processing
          External REXX functions
            CHANGE
            CONTAINS
            FLD
            NCONTAIN
            PRINT
            PRTCOUNT
            RECSIN
            RECSOUT
            TALLY
            TM
            WRITE
          RETURN values
            DROP
            STOP
            STOP IMMEDIATE
      Copying data to a VSAM or QSAM file
        Specifying details for the "From" table
          Setting options for the current Export session
          Editing the template for the "From" table
        Specifying details for the "To" data set
          Exported data formats
          Running Export in batch
          Notes on using Export
        Copying data from a ZDT/Db2 editor session, or from an SQL statement
          Specifying the source for the exported data
          Specifying the format of the exported data
          Limiting the rows exported with a label range
          Differences compared with the export utility
          Ways that you can use the EXPORT primary command
      Scrambling data
        When can you scramble data?
        Scrambling rules
      How do I…?
        How do I copy data from one Db2 table to another on the same Db2 system?
        How do I copy data from one Db2 table to another on a different (connectable) Db2 system?
        How do I copy data from one Db2 table to another on a different (non-connectable) Db2 system?
        How do I copy and reorder selected data from a Db2 table to a sequential file?
        How do I define a copybook that describes data exported to a sequential file?
        How do I export data using a copybook that describes a different data format to that used by the ZDT/Db2 Export Utility?
    Working with lists of Db2 objects
      Displaying or printing a list of objects
      Working with object list panels
        Limiting the data displayed
          Using the filter line
          Using the operator line
        Locating a row or column in a list of Db2 objects
        Finding a string in a list of Db2 objects
        Using the line command area (Cmd)
          Line command
          Line command query (?)
          Equal (=)
          ROW
        Sorting the displayed data
    Printing
      Printing the contents of a Db2 table
        Formatting the print output
        Editing the template
        Running Print in batch
      Printing rows from a Db2 table
      Looking at the print output from your ZDT/Db2 session
      Printing an audit trail report
        Audit Trail Report
    Managing Db2 privileges
      Using the Manage Db2 Privileges panel
      Displaying privileges
      Granting privileges
      Revoking privileges
    Generating batch JCL for Db2 utility jobs
      Setting options for Db2 utilities
      Generating a LISTDEF statement in the Db2 utility job
      Generating a Db2 utility job
        Working with LISTDEF utility panels
      COPY utility
        Default values
        COPY (table spaces)
        COPY (index spaces)
      LOAD utility
        Input data
        Loading data using LOAD utility control statements
        Loading data described by a copybook or template
      REBUILD utility
        REBUILD utility (indexes)
        REBUILD utility (indexes for table spaces)
      RECOVER utility
        RECOVER (table spaces)
        RECOVER (index spaces)
      REORG utility
        REORG (table spaces)
        REORG (indexes)
      RUNSTATS utility
        RUNSTATS (table spaces)
        RUNSTATS (indexes)
      UNLOAD utility
        UNLOAD (tables)
          Null indicator byte processing
          UNLOAD (tables) with LISTDEF specified
        UNLOAD (table spaces)
          UNLOAD (table spaces) with LISTDEF specified
    Working with SQL statements
      Should you use basic or advanced SQL prototyping?
      Using basic SQL prototyping
        Specifying a predicate
        Example of using basic SELECT prototyping
      Using advanced SQL prototyping
        Tabbing and color-coding
          Syntax diagram color-coding
          Generated SELECT statement color-coding
        Using the advanced SELECT prototyping panels to build a SELECT statement
          Example 1 (Building a simple SQL statement)
        Changing the SQL statement
          Example 2 (Changing the SQL statement)
          Example 3 (Adding to the SQL statement)
          Example 4 (Removing part of the SQL statement)
        Handling repeatable items in the syntax
          Navigating through the repeatable items
          Inserting an extra repeatable item
          Changing a repeatable item
          Deleting a repeatable item
          Handling selectable repeat separators
          Points to consider when working with repeatable items
      Executing a SELECT statement after you have built it using prototyping
      Entering, executing, and explaining SQL statements
        Entering SQL statements
          Editing SQL
          Limiting the rows loaded into the ZDT/Db2 editor
          Scrolling the entry area
        Executing SQL statements
          SQL cost
          SQL errors
        Explaining SQL
          Additional considerations for EXPLAIN
      Editing and executing SQL statements from a data set
      Managing tables used by SQL explain
      Exiting SQL prototyping
    Interfacing with Db2 Interactive
  ZDT/Db2 reference
    Db2 data types
      Large objects (LOBs)
    ZDT/Db2 panels and fields
      Scrollable fields on ZDT/Db2 panels
      Action bar pull-down menu
      Additional LISTDEF Statements panel
      Additional TEMPLATE Statements panel
      Advanced SELECT Prototyping panel
      Alter Database panel
      Alter External Scalar Function panel
      Alter Index panel
      Alter Stored Procedure panel
      Alter Table panel
      Alter Table - ADD CHECK Constraint panel
      Alter Table - ADD Column panel
      Alter Table - ADD FOREIGN KEY Constraint panel
      Alter Table - ADD PRIMARY KEY panel
      Alter Table - AUDIT panel
      Alter Table - DATA CAPTURE panel
      Alter Table - DROP CHECK Constraint panel
      Alter Table - DROP FOREIGN KEY Constraint panel
      Alter Table - DROP PRIMARY KEY panel
      Alter Table - RESTRICT ON DROP panel
      Alter Table - VALIDPROC panel
      Alter Table Space panel
      Application Packages panel
      Application Plans panel
      Basic SELECT Prototyping panel
      Bind Application Plan panel
      Bind Package panel
      Children of Table panel
      Collections panel
      Column Attributes panel (alphanumeric)
      Column Attributes panel (DATE)
      Column Attributes panel (numeric)
      Column Attributes panel (TIME)
      Column Attributes panel (TIMESTAMP)
      Column Distribution panel
      Column Part Statistics panel
      Column Selection/Edit panel
      Columns panel
      Columns in Index panel
      Columns in Table panel
      Comment panels
      Compiler Language Selection panel
      Constraint Columns for panel
      Copy Options panel
      Copy Utility ("From") panel
      COPY Utility (Index Spaces) panel
      COPY Utility (Index Spaces) with LISTDEF panel
      Copy Utility ("To") panel
      COPY Utility (Table Spaces) panel
      COPY Utility (Table Spaces) with LISTDEF panel
      Create Alias panel
      Create Auxiliary Table panel
      Create Database panel
      Create Distinct Type panel
      Create Function: Option List (1/2) panel
      Create Function: Option List (2/2) panel
      Create Function panel
      Create Function: Parameter Types panel
      Create Function: Parameters panel
      Create Function: Returned Data Type panel
      Create Index panel
      Create Index: Allocation panel
      Create Index: Column Selection panel
      Create Index: Options panel
      Create Index: Partitions panel
      Create Index: Partition Values panel
      Create Index: Type panel
      Create Procedure panel
      Create Procedure: Option List (1/2) panel
      Create Procedure: Option List (2/2) panel
      Create Procedure: Parameter Types panel
      Create Procedure: Parameters panel
      Create Synonym panel
      Create Table panel
      Create Table Space panel
      Create Table Space: Allocation panel
      Create Table Space: Data Sharing Options panel
      Create Table Space: Data Storage Options panel
      Create Table Space: Define Partitions panel
      Create Table Space: Locking Options panel
      Create Table Space: Type panel
      Create Table: Column Check Constraints panel
      Create Table: Column Referential Constraints panel
      Create Table: Columns panel
      Create Table: Generate Values panel
      Create Table: Model Load panel
      Create Table: Nulls and Default Values panel
      Create Table: Options panel
      Create Table: Procedure Exits panel
      Create Table: Table Check Constraints panel
      Create Table: Table Referential Constraint panel
      Create Table: Table Referential Constraints panel
      Create Table: Unique Constraints panel
      Create Trigger panel
      Create Trigger: Details panel
      Create Trigger: Search Condition panel
      Create Trigger: SQL statement panel
      Create View panel
      Create View Source Statements panel
      Data Create Utility panel
      Database Request Modules panel
      Database Structure panel
      Databases panel
      Db2 Browse panel
      Db2 Edit panel
      Db2 Location Selection panel
      Db2 Object Functions panel
      Db2 Save Error Action panel
      Db2 Subsystem Selection panel
      Db2 Template Description panel
      Db2 Utilities panel
      Db2 View panel
      Db2I Primary Option Menu panel
      Details panels
      Display Row panel
      Distinct Types panel
      Drop panels
      Drop Confirmation panel
      Edit/Execute SQL (Data Set) panel
      Editor Options (1 of 8) panel
      Editor Options (2 of 8) panel
      Editor Options (3 of 8) panel
      Editor Options (4 of 8) panel
      Editor Options (5 of 8) panel
      Editor Options (6 of 8) panel
      Editor Options (7 of 8) panel
      Editor Options (8 of 8) panel
      Enter and Execute Db2 Commands panel
      Enter, Execute and Explain SQL Statements panel
      EXPLAIN Interpretation panel
      Explain Utilities panel
      Export Options (1 of 3) panel
      Export Options (2 of 3) panel
      Export Options (3 of 3) panel
      Export Utility ("From") panel
      Export Utility ("To") panel
      Field Selection/Edit panel
      ZDT/Db2 Release News panel
      Foreign Keys for Table panel
      Free Application Plan panel
      Free Package panel
      From Column Mapping panel
      Functions panel
      Grant privileges panels
      Import Options panel
      Import Utility ("From") panel
      Import Utility ("To") panel
      Index Parts panel
      Indexes panel
      Indexes and Columns for panel
      ISPF Primary Option panel
      ISPF Settings panel
      Label Column panel
      Label Table panel
      LISTCAT Output Display panel
      LISTDEF Options panel
      LOAD from panel
      LOAD Utility panel
      LOAD Utility panel using Db2 templates
      LOAD Utility - Using Templates panel
      LOAD Utility Options panel
      Manage Db2 Privileges panel
      Object List Line Commands panel
      Object List Options (1 of 2) panel
      Object List Options (2 of 2) panel
      Object List Utility panel
      OPTIONS Options panel
      Package Dependencies panel
      Package List panel
      Parents of Table panel
      Partitioned Table Statistics panel
      Plan Dependencies panel
      Plan Enabled/Disabled Connections panel
      Plan Table Rows panel
      Primary Key for Table panel
      Primary Option Menu panel
      Print Audit Trail panel
      Print Utility Options panel
      Print Utility panel
      Privilege details panels
      Privileges panels
      Rebind Application Plan panel
      Rebind Package panel
      REBUILD (Indexes for Table Spaces) panel
      REBUILD (Indexes for Table Spaces) with LISTDEF panel
      REBUILD Utility (Indexes) panel
      REBUILD (Indexes) with LISTDEF panel
      Record Type Selection panel
      RECOVER Utility (Index Spaces) panel
      RECOVER Utility (Index Spaces) with LISTDEF panel
      RECOVER Utility (Table Spaces) panel
      RECOVER Utility (Table Spaces) with LISTDEF panel
      Recovery Information panel
      Related tables panel
      Remote Db2 Location Selection panel
      REORG Utility (Indexes) panel
      REORG Utility (Indexes) with LISTDEF panel
      REORG Utility (Table Spaces) panel
      REORG Utility (Table Spaces) with LISTDEF panel
      Revoke privileges panels
      Routine Parameters panel
      Row Selection Criteria panel
      RUNSTATS Utility (Indexes) panel
      RUNSTATS Utility (Indexes) with LISTDEF panel
      RUNSTATS Utility (Table Spaces) panel
      RUNSTATS Utility (Table Spaces) with LISTDEF panel
      Schemas panel
      Scramble Exit Specification panel
      Select Statement Browse panel
      Select Statement Edit panel
      Sequences panel
      Set Batch Job Card Information panel
      Set COBOL Processing Options panel
      Set HLASM Processing Options panel
      Set Optimizer Hint panel
      Set Output Data Set Allocation Options panel
      Set PL/I Processing Options panel
      Set Print Processing Options panel
      Set Processing Options panel
      Set System Processing Options panel
      Set Temporary Data Set Allocation Options panel
      Set Trace options panel
      Set Utility Options panel
      Sort Fields panel
      SQL Prototyping, Execution and Analysis panel
      Statement Table Rows panel
      Storage Group(s) panel
      Storage Group Usage Privileges panel
      Stored Procedures panel
      Synonym Dependencies panel
      Synonyms panel
      Systems Options (1 of 4) panel
      Systems Options (2 of 4) panel
      Systems Options (3 of 4) panel
      Systems Options (4 of 4) panel
      Table Browse panel
      Table Check Constraint Dependencies panel
      Table Check Constraint Details panel
      Table Check Constraints panel
      Table Edit panel
      Table Edit (related) panel
      Table Selection panel
      Table Space Parts panel
      Table Spaces panel
      Table View panel
      Table/View/Alias Selection panel
      Tables, Views and Aliases panel
      TEMPLATE Options (1 of 2) panel
      TEMPLATE Options (2 of 2) panel
      Template Mapping panel
      Template Save panel
      Triggers panel
      UNLOAD Options panel
      UNLOAD Utility (Table Spaces) panel
      UNLOAD Utility (Table Spaces) with LISTDEF panel
      UNLOAD Utility (Tables) "From" panel
      UNLOAD Utility (Tables) "To" panel
      UNLOAD Utility (Tables) with LISTDEF panel
      Utility Functions panel
      Value List Edit panel
      Volumes panel
    ZDT/Db2 commands
      ABOUT primary command
      ALL primary command
      BACKWARD primary command
      BOTTOM primary command
      BROWSE primary command
      CANCEL primary command
      CAPS primary command
      CASE primary command
      CHANGE primary command
      COL primary command
      CHARPOS primary command
      DELCOL primary command
      DELETE primary command
      DESCRIBE primary command
      DESELECT primary command
      DOWN primary command
      EDIT primary command
      EDITCOL primary command
      END primary command
      EXCLUDE primary command
      EXECUTE primary command
      EXPAND primary command
      EXPLAIN primary command
      EXPORT primary command
      FILE primary command
      FIND primary command
      FMAP primary command
      FORMAT primary command
      FORWARD primary command
      FREE primary command
      FS primary command
      FT primary command
      HEX primary command
      HIDE primary command
      HINT primary command
      HOLD primary command
      INDEXINF primary command
      INSRPT primary command
      LEFT primary command
      LHEX primary command
      LOBBRWS primary command
      LOBEDIT primary command
      LOBLEN primary command
      LOBVIEW primary command
      LOCATE primary command
      NEW, NEWS primary command
      NEXT primary command
      NEXTRPT primary command
      ORDER primary command
      PB primary command
      PLAN primary command
      PREFIX primary command
      PREVIOUS primary command
      PREVRPT primary command
      PRINT primary command
      PROTCOL primary command
      PURGE primary command
      QUIT primary command
      RCHANGE primary command
      RD primary command
      REDIT primary command
      REFRESH primary command
      REFS primary command
      RESET primary command
      RFIND primary command
      RIGHT primary command
      RP primary command
      RUNTEMP primary command
      SAVE primary command
      SAVEAS primary command
      SHADOW primary command
      SHOW primary command
      SHOW primary command
      SHOWCOB primary command
      SORT primary command
      SQL primary command
      SQLID primary command
      TEDIT primary command
      TOP primary command
      TP primary command
      TYPE primary command
      UNDO primary command
      UP primary command
      VER primary command
      VIEW primary command
      WIDTH primary command
      XMLBRWS primary command
      XMLEDIT primary command
      XMLLEN primary command
      XMLVIEW primary command
      ZOOM primary command
    ZDT/Db2 functions
      How to use this reference chapter
      General tips about performance when you use Z Data Tools functions
      ZDT/Db2 batch functions
        BATSQL (Batch SQL) batch command
        DBC (Copy) batch command
        DBI (Import) batch command
        DBP (Print) batch command
        DBX (Export) batch command
        D2G (Data Generate) batch command
        D2TP (Template create/update) batch command
        Specifying a Db2 object name
        Specifying the template for a Db2 object
        Specifying the template/copybook for a data set
  ZDT/Db2 messages
    Messages
      HFMBF130
      HFMBF131
      HFMBF132
      HFMBF133
      HFMBF134
      HFMBF139
      HFMDA001
      HFMDA002
      HFMDA003
      HFMDA004
      HFMDA009
      HFMDA011
      HFMDA012
      HFMDA013
      HFMDA014
      HFMDA020
      HFMDA021
      HFMDA022
      HFMDA023
      HFMDA024
      HFMDA025
      HFMDA026
      HFMDA027
      HFMDA028
      HFMDA030
      HFMDA031
      HFMDA032
      HFMDA033
      HFMDA034
      HFMDA035
      HFMDA036
      HFMDA037
      HFMDA038
      HFMDA039
      HFMDA040
      HFMDA100
      HFMDA997
      HFMDA998
      HFMDB000
      HFMDB001
      HFMDB002
      HFMDB003
      HFMDB004
      HFMDB005
      HFMDB006
      HFMDB007
      HFMDB008
      HFMDB009
      HFMDB010
      HFMDB011
      HFMDB012
      HFMDB013
      HFMDB014
      HFMDB015
      HFMDB016
      HFMDB017
      HFMDB018
      HFMDB019
      HFMDB020
      HFMDB021
      HFMDB022
      HFMDB023
      HFMDB024
      HFMDB025
      HFMDB026
      HFMDB027
      HFMDB028
      HFMDB029
      HFMDB030
      HFMDB031
      HFMDB032
      HFMDB033
      HFMDB034
      HFMDB035
      HFMDB036
      HFMDB037
      HFMDB038
      HFMDB039
      HFMDB040
      HFMDB041
      HFMDB042
      HFMDB043
      HFMDB044
      HFMDB045
      HFMDB046
      HFMDB047
      HFMDB048
      HFMDB049
      HFMDB050
      HFMDB051
      HFMDB052
      HFMDB053
      HFMDB054
      HFMDB055
      HFMDB056
      HFMDB057
      HFMDB058
      HFMDB059
      HFMDB060
      HFMDB061
      HFMDB062
      HFMDB063
      HFMDB064
      HFMDB066
      HFMDB067
      HFMDB068
      HFMDB069
      HFMDB070
      HFMDB071
      HFMDB072
      HFMDB073
      HFMDB074
      HFMDB075
      HFMDB076
      HFMDB077
      HFMDB078
      HFMDB079
      HFMDB088
      HFMDB091
      HFMDB092
      HFMDB093
      HFMDB094
      HFMDB095
      HFMDB096
      HFMDB098
      HFMDB099
      HFMDB100
      HFMDB101
      HFMDB107
      HFMDB108
      HFMDB109
      HFMDB110
      HFMDB118
      HFMDB119
      HFMDB145
      HFMDB146
      HFMDB148
      HFMDB149
      HFMDB150
      HFMDB153
      HFMDB154
      HFMDB155
      HFMDB156
      HFMDB157
      HFMDB158
      HFMDB159
      HFMDB160
      HFMDB161
      HFMDB163
      HFMDB164
      HFMDB165
      HFMDB166
      HFMDB167
      HFMDB170
      HFMDB171
      HFMDB173
      HFMDB174
      HFMDB175
      HFMDB176
      HFMDB177
      HFMDB178
      HFMDB179
      HFMDB180
      HFMDB181
      HFMDB182
      HFMDB183
      HFMDB184
      HFMDB185
      HFMDB186
      HFMDB187
      HFMDB188
      HFMDB189
      HFMDB190
      HFMDB191
      HFMDB192
      HFMDB193
      HFMDB194
      HFMDB195
      HFMDB196
      HFMDB197
      HFMDB198
      HFMDB199
      HFMDB206
      HFMDB208
      HFMDB210
      HFMDB215
      HFMDB216
      HFMDB217
      HFMDB220
      HFMDB223
      HFMDB224
      HFMDB240
      HFMDB242
      HFMDB245
      HFMDB246
      HFMDB247
      HFMDB250
      HFMDB270
      HFMDB271
      HFMDB272
      HFMDB273
      HFMDB274
      HFMDB275
      HFMDB276
      HFMDB289
      HFMDB292
      HFMDB295
      HFMDB296
      HFMDB298
      HFMDB299
      HFMDB300
      HFMDB301
      HFMDB302
      HFMDB303
      HFMDB304
      HFMDB305
      HFMDB310
      HFMDB311
      HFMDB312
      HFMDB313
      HFMDB330
      HFMDB331
      HFMDB332
      HFMDB333
      HFMDB334
      HFMDB335
      HFMDB337
      HFMDB338
      HFMDB339
      HFMDB340
      HFMDB341
      HFMDB342
      HFMDB343
      HFMDB344
      HFMDB345
      HFMDB346
      HFMDB348
      HFMDB349
      HFMDB350
      HFMDB351
      HFMDB352
      HFMDB353
      HFMDB354
      HFMDB355
      HFMDB358
      HFMDB359
      HFMDB400
      HFMDB401
      HFMDB402
      HFMDB403
      HFMDB404
      HFMDB405
      HFMDB406
      HFMDB407
      HFMDB408
      HFMDB409
      HFMDB410
      HFMDB411
      HFMDB412
      HFMDB413
      HFMDB414
      HFMDB415
      HFMDB416
      HFMDB417
      HFMDB418
      HFMDB419
      HFMDB420
      HFMDB421
      HFMDB422
      HFMDB423
      HFMDB424
      HFMDB425
      HFMDB426
      HFMDB427
      HFMDB429
      HFMDB431
      HFMDB432
      HFMDB433
      HFMDB434
      HFMDB435
      HFMDB436
      HFMDB437
      HFMDB438
      HFMDB439
      HFMDB440
      HFMDB441
      HFMDB442
      HFMDB443
      HFMDB444
      HFMDB445
      HFMDB450
      HFMDB451
      HFMDB453
      HFMDB454
      HFMDB455
      HFMDB456
      HFMDB457
      HFMDB458
      HFMDB459
      HFMDB460
      HFMDB461
      HFMDB462
      HFMDB463
      HFMDB464
      HFMDB465
      HFMDB467
      HFMDB468
      HFMDB469
      HFMDB470
      HFMDB471
      HFMDB472
      HFMDB473
      HFMDB474
      HFMDB477
      HFMDB478
      HFMDB479
      HFMDB480
      HFMDB481
      HFMDB482
      HFMDB483
      HFMDB484
      HFMDB490
      HFMDB491
      HFMDB500
      HFMDB501
      HFMDB502
      HFMDB503
      HFMDB504
      HFMDB505
      HFMDB506
      HFMDB507
      HFMDB508
      HFMDB509
      HFMDB510
      HFMDB511
      HFMDB512
      HFMDB519
      HFMDB520
      HFMDB521
      HFMDB530
      HFMDB531
      HFMDB532
      HFMDB533
      HFMDB534
      HFMDB535
      HFMDB536
      HFMDB537
      HFMDB538
      HFMDB539
      HFMDB540
      HFMDB541
      HFMDB542
      HFMDB543
      HFMDB544
      HFMDB545
      HFMDB546
      HFMDB550
      HFMDB551
      HFMDB552
      HFMDB553
      HFMDB554
      HFMDB560
      HFMDB561
      HFMDB600
      HFMDB601
      HFMDB602
      HFMDB650
      HFMDB651
      HFMDB652
      HFMDB653
      HFMDB654
      HFMDB655
      HFMDB656
      HFMDB657
      HFMDB658
      HFMDB659
      HFMDB660
      HFMDB661
      HFMDB662
      HFMDB663
      HFMDB664
      HFMDB665
      HFMDB670
      HFMDB671
      HFMDB672
      HFMDB673
      HFMDB674
      HFMDB675
      HFMDB700
      HFMDB701
      HFMDB702
      HFMDB703
      HFMDB707
      HFMDB708
      HFMDB709
      HFMDB710
      HFMDB711
      HFMDB712
      HFMDB720
      HFMDB721
      HFMDB722
      HFMDB723
      HFMDB730
      HFMDB731
      HFMDB732
      HFMDB733
      HFMDB734
      HFMDB735
      HFMDB736
      HFMDB737
      HFMDB738
      HFMDB739
      HFMDB740
      HFMDB741
      HFMDB742
      HFMDB750
      HFMDB751
      HFMDB752
      HFMDB753
      HFMDB754
      HFMDB755
      HFMDB756
      HFMDB757
      HFMDB758
      HFMDB759
      HFMDB760
      HFMDB761
      HFMDB762
      HFMDB763
      HFMDB764
      HFMDB765
      HFMDB768
      HFMDB769
      HFMDB770
      HFMDB771
      HFMDB772
      HFMDB773
      HFMDB774
      HFMDB775
      HFMDB776
      HFMDB777
      HFMDB778
      HFMDB779
      HFMDB780
      HFMDB781
      HFMDB782
      HFMDB783
      HFMDB784
      HFMDB785
      HFMDB786
      HFMDB787
      HFMDB788
      HFMDB789
      HFMDB790
      HFMDB791
      HFMDB792
      HFMDB800
      HFMDB801
      HFMDB802
      HFMDB803
      HFMDB804
      HFMDB805
      HFMDB806
      HFMDB807
      HFMDB808
      HFMDB809
      HFMDB810
      HFMDB811
      HFMDB812
      HFMDB813
      HFMDB814
      HFMDB815
      HFMDB816
      HFMDB817
      HFMDB818
      HFMDB819
      HFMDB826
      HFMDB827
      HFMDB828
      HFMDB829
      HFMDB831
      HFMDB832
      HFMDB833
      HFMDB835
      HFMDB836
      HFMDB837
      HFMDB838
      HFMDB839
      HFMDB840
      HFMDB841
      HFMDB842
      HFMDB843
      HFMDB844
      HFMDB845
      HFMDB846
      HFMDB847
      HFMDB848
      HFMDB849
      HFMDB850
      HFMDB851
      HFMDB852
      HFMDB853
      HFMDB855
      HFMDB856
      HFMDB858
      HFMDB859
      HFMDB860
      HFMDB861
      HFMDB862
      HFMDB863
      HFMDB864
      HFMDB865
      HFMDB866
      HFMDB867
      HFMDB868
      HFMDB869
      HFMDB870
      HFMDB871
      HFMDB872
      HFMDB873
      HFMDB874
      HFMDB875
      HFMDB879
      HFMDB890
      HFMDB900
      HFMDB903
      HFMDB904
      HFMDB905
      HFMDB907
      HFMDB909
      HFMDB910
      HFMDB911
      HFMDB913
      HFMDB914
      HFMDB915
      HFMDB916
      HFMDB917
      HFMDB918
      HFMDB919
      HFMDB921
      HFMDB922
      HFMDB923
      HFMDB924
      HFMDB925
      HFMDB926
      HFMDB927
      HFMDB928
      HFMDB939
      HFMDB940
      HFMDB941
      HFMDB942
      HFMDB943
      HFMDB944
      HFMDB945
      HFMDB946
      HFMDB947
      HFMDB948
      HFMDB949
      HFMDB950
      HFMDB951
      HFMDB952
      HFMDB953
      HFMDB954
      HFMDB955
      HFMDB956
      HFMDB957
      HFMDB958
      HFMDB959
      HFMDB960
      HFMDB961
      HFMDB962
      HFMDB963
      HFMDB964
      HFMDB965
      HFMDB966
      HFMDB967
      HFMDB968
      HFMDB969
      HFMDB970
      HFMDB971
      HFMDB972
      HFMDB973
      HFMDB974
      HFMDB980
      HFMDB981
      HFMDB990
      HFMDB991
      HFMDB992
      HFMDB993
      HFMDB994
      HFMDC000
      HFMDC001
      HFMDC002
      HFMDC010
      HFMDC011
      HFMDC012
      HFMDC013
      HFMDC014
      HFMDC015
      HFMDC019
      HFMDC020
      HFMDC021
      HFMDC022
      HFMDC023
      HFMDC026
      HFMDC027
      HFMDC028
      HFMDC030
      HFMDC031
      HFMDC032
      HFMDC033
      HFMDC034
      HFMDC035
      HFMDC036
      HFMDC037
      HFMDC038
      HFMDC039
      HFMDC040
      HFMDC041
      HFMDC042
      HFMDC043
      HFMDC044
      HFMDC045
      HFMDC046
      HFMDC047
      HFMDC048
      HFMDC049
      HFMDC050
      HFMDC051
      HFMDC052
      HFMDC053
      HFMDC054
      HFMDC055
      HFMDC056
      HFMDC057
      HFMDC058
      HFMDC059
      HFMDC060
      HFMDC062
      HFMDC100
      HFMDC101
      HFMDC102
      HFMDC103
      HFMDC104
      HFMDC105
      HFMDC106
      HFMDC107
      HFMDC108
      HFMDC110
      HFMDC111
      HFMDC112
      HFMDC113
      HFMDC114
      HFMDC170
      HFMDC171
      HFMDC172
      HFMDC174
      HFMDC180
      HFMDC181
      HFMDC182
      HFMDC183
      HFMDC184
      HFMDC185
      HFMDC186
      HFMDC187
      HFMDC188
      HFMDC189
      HFMDC190
      HFMDC191
      HFMDC192
      HFMDC193
      HFMDC194
      HFMDC195
      HFMDC196
      HFMDC197
      HFMDC198
      HFMDC199
      HFMDC200
      HFMDC201
      HFMDC202
      HFMDC203
      HFMDC204
      HFMDC206
      HFMDC207
      HFMDC208
      HFMDC209
      HFMDC210
      HFMDC211
      HFMDC220
      HFMDC221
      HFMDC230
      HFMDC500
      HFMDC510
      HFMDC520
      HFMDC521
      HFMDC531
      HFMDC533
      HFMDC534
      HFMDC535
      HFMDC536
      HFMDC539
      HFMDC540
      HFMDC541
      HFMDC542
      HFMDC543
      HFMDC544
      HFMDC545
      HFMDC546
      HFMDC547
      HFMDC548
      HFMDC549
      HFMDC550
      HFMDC551
      HFMDC552
      HFMDC553
      HFMDC554
      HFMDC555
      HFMDC556
      HFMDC557
      HFMDC558
      HFMDC559
      HFMDC570
      HFMDC571
      HFMDC572
      HFMDC573
      HFMDC574
      HFMDC578
      HFMDC579
      HFMDC580
      HFMDC581
      HFMDC583
      HFMDC584
      HFMDC585
      HFMDC586
      HFMDC587
      HFMDC588
      HFMDC590
      HFMDC591
      HFMDC592
      HFMDC593
      HFMDC594
      HFMDC595
      HFMDC596
      HFMDC597
      HFMDC598
      HFMDC599
      HFMDC600
      HFMDC601
      HFMDC602
      HFMDC603
      HFMDC604
      HFMDC605
      HFMDC606
      HFMDC607
      HFMDC608
      HFMDC609
      HFMDC610
      HFMDC611
      HFMDC612
      HFMDC613
      HFMDC614
      HFMDC615
      HFMDC616
      HFMDC620
      HFMDC621
      HFMDC622
      HFMDC623
      HFMDC624
      HFMDC625
      HFMDC626
      HFMDC627
      HFMDC628
      HFMDC629
      HFMDC630
      HFMDC631
      HFMDC632
      HFMDC633
      HFMDC634
      HFMDC635
      HFMDC636
      HFMDC637
      HFMDC638
      HFMDC640
      HFMDC641
      HFMDC642
      HFMDC643
      HFMDC644
      HFMDC645
      HFMDC646
      HFMDC647
      HFMDC648
      HFMDC649
      HFMDC651
      HFMDC660
      HFMDC661
      HFMDC662
      HFMDC663
      HFMDC664
      HFMDC665
      HFMDC666
      HFMDC667
      HFMDC668
      HFMDC670
      HFMDC671
      HFMDC672
      HFMDC673
      HFMDC680
      HFMDC690
      HFMDC691
      HFMDC700
      HFMDC701
      HFMDC702
      HFMDC703
      HFMDC704
      HFMDC705
      HFMDC710
      HFMDC711
      HFMDC712
      HFMDC713
      HFMDC714
      HFMDC715
      HFMDC716
      HFMDC720
      HFMDC721
      HFMDC722
      HFMDC723