zOs/SQL/XXRTCXD

------------------------------------------------------------------------
--                                                                    --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C)  --
--                                                                    --
-- ADB2GEN  -  Extract object definitions from the DB2 Catalog tables --
--                                                                    --
-- Input prepared on : DBTF (810)     Extract time : 2006-09-29 11:59 --
--                                                                    --
-- Catalog values overridden : none
--                                                                    --
-- Generate : SG=N DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y  --
--            TG=Y UT=N UF=N SP=N SQ=N                                --
-- Grants   : SG=N DB=Y TS=Y TB=N VW=N SC=N UT=N UF=N SP=N SQ=N       --
--                                                                    --
------------------------------------------------------------------------
--
  SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
CREATE DATABASE SU01A1Z
  BUFFERPOOL BP2
  INDEXBP    BP1
  CCSID      EBCDIC
  STOGROUP   GSMS;
COMMIT;
--                                                                    --
-- ADB2GEN: Generate DDL for Tablespace=XXRSCXD In Database SU01A1T   --
--                                                                    --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=SU01A1Z   Stogroup=GSMS
-- Tablespace=SU01A1Z.XXRSCXD
------------------------------------------------------------------------
--
  CREATE TABLESPACE XXRSCXD
    IN SU01A1Z
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 7200
    ERASE  NO
    FREEPAGE 0 PCTFREE 0
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE NO
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
--
------------------------------------------------------------------------
--    Table=OA1Z.XXRTCXD In SU01A1Z.XXRSCXD
------------------------------------------------------------------------
--
  CREATE TABLE OA1Z.XXRTCXD
     (XXRDATCLIENT         CHAR(8) FOR SBCS DATA NOT NULL,
      XXRDATENV            CHAR(8) FOR SBCS DATA NOT NULL,
      XXRDATINFO           CHAR(8) FOR SBCS DATA NOT NULL,
      CXDKEYCTM            CHAR(20) FOR SBCS DATA NOT NULL,
      CXDKEYLIB            CHAR(44) FOR SBCS DATA NOT NULL,
      CXDAPPL              CHAR(20) FOR SBCS DATA NOT NULL,
      CXDKEYTABLE          CHAR(20) FOR SBCS DATA NOT NULL,
      CXDKEYTYP            CHAR(1) FOR SBCS DATA NOT NULL,
      CXDKEYNUM            INTEGER NOT NULL,
      CXDMEMNAME           CHAR(30) FOR SBCS DATA NOT NULL,
      CXDCONDNAME          CHAR(100) FOR SBCS DATA NOT NULL,
      CXDSOCDATE           CHAR(4) FOR SBCS DATA NOT NULL,
      CXDOPTION            CHAR(2) FOR SBCS DATA NOT NULL,
      CXDOWNER             CHAR(30) FOR SBCS DATA NOT NULL,
      CXDTASKTYPE          CHAR(3) FOR SBCS DATA NOT NULL,
      CXDGROUP             CHAR(20) FOR SBCS DATA NOT NULL,
      CXDDESC              CHAR(50) FOR SBCS DATA NOT NULL)
    IN SU01A1Z.XXRSCXD
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
--
  LABEL ON TABLE OA1Z.XXRTCXD IS 'CTM - IN-/OUT-CONDITIONS';
--
  LABEL ON OA1Z.XXRTCXD
   (CXDDESC IS 'DESCRIPTION',
    CXDGROUP IS 'GROUP',
    CXDTASKTYPE IS 'TASKTYPE',
    CXDOWNER IS 'OWNER',
    CXDOPTION IS 'OPTION (+,-,O,A,'''')',
    CXDSOCDATE IS 'OCCURRENCE-DATE',
    CXDCONDNAME IS 'CONDITION-NAME',
    CXDMEMNAME IS 'MEMBER/JOBNAME',
    CXDKEYNUM IS 'UNIQUE NUMBER',
    CXDKEYTYP IS 'TYPE (JOB/GROUP)',
    CXDKEYTABLE IS 'TABLE',
    CXDAPPL IS 'APPLICATION',
    CXDKEYLIB IS 'SCHEDULE-LIBRARY',
    CXDKEYCTM IS 'SUBSYS/DATACENTER',
    XXRDATINFO IS 'DATADDINFO',
    XXRDATENV IS 'ENVIRONMENT',
    XXRDATCLIENT IS 'CLIENT');
--
------------------------------------------------------------------------
-- Database=SU01A1Z
--    Index=OA1Z.XXRXCXD0 On OA1Z.XXRTCXD
------------------------------------------------------------------------
--
  CREATE INDEX OA1Z.XXRXCXD0
    ON OA1Z.XXRTCXD
     (CXDMEMNAME            ASC,
      CXDKEYTABLE           ASC)
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 7200
    ERASE  NO
    FREEPAGE 0 PCTFREE 0
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE NO
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
--
------------------------------------------------------------------------
-- Database=SU01A1Z
--    Index=OA1Z.XXRXCXD1 On OA1Z.XXRTCXD
------------------------------------------------------------------------
--
  CREATE INDEX OA1Z.XXRXCXD1
    ON OA1Z.XXRTCXD
     (CXDCONDNAME           ASC)
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 7200
    ERASE  NO
    FREEPAGE 0 PCTFREE 0
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE NO
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL                                     --
------------------------------------------------------------------------
--