zOs/SQL/CRETAWK3

------------------------------------------------------------------------
--                                                                    --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C)  --
--                                                                    --
-- ADB2GEN  -  Extract object definitions from the DB2 Catalog tables --
--                                                                    --
-- Input prepared on : DBAF (810)     Extract time : 2006-09-14 16:43 --
--                                                                    --
-- 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=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N       --
--                                                                    --
------------------------------------------------------------------------
--
  SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
--                                                                    --
-- ADB2GEN: Generate DDL for Tablespace=A003A In Database dgdb9998    --
--                                                                    --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=dgdb9998   Stogroup=GSMS
-- Tablespace=dgdb9998.A003A
------------------------------------------------------------------------
--
  CREATE TABLESPACE A003A
    IN dgdb9998
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 7200
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE 64
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
--
------------------------------------------------------------------------
--    Table=gdb9998.TWK003A In dgdb9998.A003A
------------------------------------------------------------------------
--
  CREATE TABLE gdb9998.TWK003A
     (WK003ID              CHAR(10) FOR SBCS DATA NOT NULL,
      WK003TXT             CHAR(20) FOR SBCS DATA WITH DEFAULT NULL,
      WK003FOR             CHAR(10) FOR SBCS DATA WITH DEFAULT NULL,
      WK003GEN             DECIMAL(25, 0) NOT NULL
        GENERATED BY DEFAULT
        AS IDENTITY
          (START WITH -9999999999999999999999999, INCREMENT BY 1,
           CACHE 20, NO CYCLE, NO ORDER,
           MAXVALUE 9999999999999999999999999,
           MINVALUE -9999999999999999999999999),
      CONSTRAINT WK003PRIM
      PRIMARY KEY (WK003ID))
    IN dgdb9998.A003A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
--
  LABEL ON TABLE gdb9998.TWK003A IS 'table drei mit foreign key';
--
------------------------------------------------------------------------
-- Database=dgdb9998
--    Index=gdb9998.IWK003A0 On gdb9998.TWK003A
------------------------------------------------------------------------
--
  CREATE UNIQUE INDEX gdb9998.IWK003A0
    ON gdb9998.TWK003A
     (WK003ID               ASC)
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 7200
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    NOT CLUSTER
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
--
  ALTER TABLE gdb9998.TWK003A FOREIGN KEY WK003FOR
     (WK003FOR)
    REFERENCES gdb9998.TWK003A
     (WK003ID)
    ON DELETE CASCADE ENFORCED ;
--
  COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL                                     --
------------------------------------------------------------------------
--