zOs/SQL/WK009

------------------------------------------------------------------------
--                                                                    --
-- 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-07-28 12:00 --
--                                                                    --
-- 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=Y DB=Y TS=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N       --
--                                                                    --
------------------------------------------------------------------------
------------------------------------------------------------------------
--                                                                    --
-- ADB2GEN: Generate DDL for Tablespace=A003A In Database DA540769    --
--                                                                    --
------------------------------------------------------------------------
--
  SET CURRENT SQLID='S100447';
--
--
------------------------------------------------------------------------
-- Database=DA540769   Stogroup=GSMS
-- Tablespace=DA540769.A009A
------------------------------------------------------------------------
--
  SET CURRENT SQLID='s100447';
--
  CREATE TABLESPACE A009A
    IN DA540769
    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;
--
  COMMIT;
--
------------------------------------------------------------------------
--    Table=A540769.TWK009A In DA540769.A009A
------------------------------------------------------------------------
--
  SET CURRENT SQLID='A540769';
--
  CREATE TABLE A540769.TWK009A
     (WK009ID              CHAR(10) FOR SBCS DATA NOT NULL,
      WK009TXT             CHAR(20) FOR SBCS DATA WITH DEFAULT NULL,
      WK009FOR             CHAR(10) FOR SBCS DATA WITH DEFAULT NULL,
      WK009GEN             DECIMAL(25, 0) NOT NULL
        GENERATED BY DEFAULT
        AS IDENTITY
          (START WITH -9999999999999999999999999, INCREMENT BY 1,
           CACHE 20, NO CYCLE, MAXVALUE 9999999999999999999999999,
           MINVALUE -9999999999999999999999999),
      CONSTRAINT WK003PRIM
      PRIMARY KEY (WK009ID))
    IN DA540769.A009A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC;
--
  LABEL ON TABLE A540769.TWK009A IS 'table drei mit foreign key';
--
  COMMIT;
--
  SET CURRENT SQLID='S100447';
--
  GRANT USE OF STOGROUP GSMS TO PUBLIC;
--
------------------------------------------------------------------------
-- Database=DA540769
--    Index=A540769.IWK009A0 On A540769.TWK009A
------------------------------------------------------------------------
--
  SET CURRENT SQLID='A540769';
--
  CREATE UNIQUE INDEX A540769.IWK009A0
    ON A540769.TWK009A
     (WK009ID               ASC)
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 7200
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    BUFFERPOOL BP1
    CLOSE YES
    COPY NO
    DEFINE YES
    PIECESIZE 2 G;
--
  COMMIT;
--
  ALTER TABLE A540769.TWK009A FOREIGN KEY WK009FOR
     (WK009FOR)
    REFERENCES A540769.TWK009A
     (WK009ID)
    ON DELETE CASCADE  ;
--
  COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL                                     --
------------------------------------------------------------------------
--