zOs/SQL/ELSER
------------------------------------------------------------------------
-- --
-- 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-12-12 14:29 --
-- --
-- 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';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Tablespace=S100A In Database DGDB0338 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=CW10A1A Stogroup=GSMS
-- Tablespace=CW10A1A.A100A
------------------------------------------------------------------------
--
CREATE TABLESPACE A100A
IN CW10A1A
USING STOGROUP GSMS
PRIQTY 12 SECQTY 12
ERASE NO
FREEPAGE 0 PCTFREE 15
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 8
BUFFERPOOL BP0
LOCKSIZE PAGE
LOCKMAX 0
CLOSE YES
COMPRESS NO
CCSID EBCDIC
DEFINE YES
MAXROWS 3;
--
------------------------------------------------------------------------
-- Table=OA1A.TCW100A1 In CW10A1A.A100A
------------------------------------------------------------------------
--
CREATE TABLE OA1A.TCW100A1
(CW10000 INTEGER NOT NULL,
CW10001 CHAR(4) FOR SBCS DATA NOT NULL,
CW10002 CHAR(20) FOR SBCS DATA NOT NULL,
CW10003 CHAR(18) FOR SBCS DATA NOT NULL,
CW10004 CHAR(16) FOR SBCS DATA NOT NULL,
CW10005 CHAR(3) FOR SBCS DATA NOT NULL,
CW10006 CHAR(3) FOR SBCS DATA NOT NULL,
CW10007 CHAR(4) FOR SBCS DATA NOT NULL,
CW10008 CHAR(4) FOR SBCS DATA NOT NULL,
CW10009 TIMESTAMP NOT NULL,
CW10010 TIMESTAMP NOT NULL,
CW10011 INTEGER NOT NULL,
CW10012 INTEGER NOT NULL,
CW10013 INTEGER NOT NULL,
CW10014 CHAR(10) FOR SBCS DATA NOT NULL,
CW10015D TIMESTAMP NOT NULL,
CW10016D TIMESTAMP NOT NULL,
CW10017D TIMESTAMP NOT NULL,
CW10018D TIMESTAMP NOT NULL,
CW10019D TIMESTAMP NOT NULL,
CW10020D TIMESTAMP NOT NULL,
CW10021D TIMESTAMP NOT NULL,
CW10022D TIMESTAMP NOT NULL,
CW10023D TIMESTAMP NOT NULL,
CW10024D TIMESTAMP NOT NULL,
CW10025 CHAR(12) FOR SBCS DATA NOT NULL,
CW10026 CHAR(5) FOR SBCS DATA NOT NULL,
CW10027 CHAR(1) FOR SBCS DATA NOT NULL,
CW10028 DECIMAL(15, 3) NOT NULL,
CW10029 CHAR(3) FOR SBCS DATA NOT NULL,
CW10030 CHAR(3) FOR SBCS DATA NOT NULL,
CW10031 CHAR(12) FOR SBCS DATA NOT NULL,
CW10032 DECIMAL(15, 3) NOT NULL,
CW10033 CHAR(18) FOR SBCS DATA NOT NULL,
CW10034 CHAR(8) FOR SBCS DATA NOT NULL,
CONSTRAINT CW10000
PRIMARY KEY (CW10000))
IN CW10A1A.A100A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE OA1A.TCW100A1 IS 'STEUERUNGSDATEN CW2-AUFTR_MAN';
--
LABEL ON OA1A.TCW100A1
(CW10033 IS 'DATUM POSITIONSEROEFFNUNG ',
CW10032 IS 'CASH-ABRECHNUNG ',
CW10031 IS 'CIF-NUMMER ',
CW10030 IS 'DEPOTART ',
CW10029 IS 'TITELART ',
CW10028 IS 'BESTAND NOMINAL/STÜCK ',
CW10027 IS 'POSITIONSKATEGORIE ',
CW10026 IS 'POSITIONSSEQUENZ ',
CW10025 IS 'VALORENNUMMER ',
CW10024D IS 'SERVICE 10 VERARB.-TIMESTAMP ',
CW10023D IS 'SERVICE 09 VERARB.-TIMESTAMP ',
CW10022D IS 'SERVICE 08 VERARB.-TIMESTAMP ',
CW10021D IS 'SERVICE 07 VERARB.-TIMESTAMP ',
CW10020D IS 'SERVICE 06 VERARB.-TIMESTAMP ',
CW10019D IS 'SERVICE 05 VERARB.-TIMESTAMP ',
CW10018D IS 'SERVICE 04 VERARB.-TIMESTAMP ',
CW10017D IS 'SERVICE 03 VERARB.-TIMESTAMP ',
CW10016D IS 'SERVICE 02 VERARB.-TIMESTAMP ',
CW10015D IS 'SERVICE 01 VERARB.-TIMESTAMP ',
CW10014 IS 'SERVICES ZEIGER ',
CW10013 IS 'TYP DES DB2-EINTRAGES ',
CW10012 IS 'BESTAND-MERKMALE ',
CW10011 IS 'PROZESS-MERKMALE ',
CW10010 IS 'MUTATIONS TIMESTAMP ',
CW10009 IS 'ERSTELLUNGS TIMESTAMP ',
CW10008 IS 'RUBRIK ',
CW10007 IS 'DEPOTSTELLE ',
CW10006 IS 'KUNDENDOMIZIL ',
CW10005 IS 'KUNDENART ',
CW10004 IS 'DEPOTNUMMER ',
CW10003 IS 'AUFTRAGSNR ',
CW10002 IS 'AKTIONSHEADERNR ',
CW10001 IS 'MANDANT ',
CW10000 IS 'ZUFALLSZAHL ');
--
------------------------------------------------------------------------
-- Database=CW10A1A
-- Index=OA1A.ICW100A6 On OA1A.TCW100A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.ICW100A6
ON OA1A.TCW100A1
(CW10031 ASC,
CW10012 ASC,
CW10014 ASC)
USING STOGROUP GSMS
PRIQTY 100 SECQTY 152
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
------------------------------------------------------------------------
-- Database=CW10A1A
-- Index=OA1A.ICW100A5 On OA1A.TCW100A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.ICW100A5
ON OA1A.TCW100A1
(CW10002 ASC,
CW10012 ASC,
CW10014 ASC)
USING STOGROUP GSMS
PRIQTY 100 SECQTY 152
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
------------------------------------------------------------------------
-- Database=CW10A1A
-- Index=OA1A.ICW100A3 On OA1A.TCW100A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.ICW100A3
ON OA1A.TCW100A1
(CW10009 ASC)
USING STOGROUP GSMS
PRIQTY 100 SECQTY 152
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
------------------------------------------------------------------------
-- Database=CW10A1A
-- Index=OA1A.ICW100A2 On OA1A.TCW100A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.ICW100A2
ON OA1A.TCW100A1
(CW10002 ASC,
CW10004 ASC)
USING STOGROUP GSMS
PRIQTY 100 SECQTY 152
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
------------------------------------------------------------------------
-- Database=CW10A1A
-- Index=OA1A.ICW100A1 On OA1A.TCW100A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.ICW100A1
ON OA1A.TCW100A1
(CW10003 ASC)
USING STOGROUP GSMS
PRIQTY 100 SECQTY 152
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
------------------------------------------------------------------------
-- Database=CW10A1A
-- Index=OA1A.ICW100A0 On OA1A.TCW100A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1A.ICW100A0
ON OA1A.TCW100A1
(CW10000 ASC)
USING STOGROUP GSMS
PRIQTY 100 SECQTY 152
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--