zOs/SQL/TTTT
------------------------------------------------------------------------
-- --
-- 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 : 2007-03-13 13:13 --
-- --
-- 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=S002A01T In Database DGOWM301 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DGOWM301 Stogroup=G001
-- Tablespace=DGOWM301.S002A01T
------------------------------------------------------------------------
--
CREATE TABLESPACE S002A01T
IN DGOWM301
USING STOGROUP G001
PRIQTY 12 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
TRACKMOD YES
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS NO
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=GOWM301.TWL002A101T In DGOWM301.S002A01T
------------------------------------------------------------------------
--
CREATE TABLE GOWM301.TWL002A101T
(WL00201 CHAR(4) FOR SBCS DATA NOT NULL,
WL00202 CHAR(11) FOR SBCS DATA NOT NULL,
WL00203 CHAR(4) FOR SBCS DATA NOT NULL,
WL00204T CHAR(4) FOR SBCS DATA NOT NULL,
WL00204D CHAR(8) FOR SBCS DATA NOT NULL,
WL00204L CHAR(5) FOR SBCS DATA NOT NULL,
WL00204R CHAR(1) FOR SBCS DATA NOT NULL,
WL00204I CHAR(2) FOR SBCS DATA NOT NULL,
WL00205 CHAR(4) FOR SBCS DATA NOT NULL,
WL00206 CHAR(4) FOR SBCS DATA NOT NULL,
WL00207 CHAR(7) FOR SBCS DATA NOT NULL,
WL00202U CHAR(4) FOR SBCS DATA NOT NULL,
WL00206U CHAR(4) FOR SBCS DATA NOT NULL,
WL00208 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
PRIMARY KEY (WL00201,
WL00202,
WL00203,
WL00204T,
WL00204D,
WL00204L,
WL00204R,
WL00204I))
IN DGOWM301.S002A01T
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE GOWM301.TWL002A101T IS 'am Geschäft beteiligte OE';
--
LABEL ON GOWM301.TWL002A101T
(WL00208 IS 'PID',
WL00206U IS 'Reserve',
WL00202U IS 'BUID zu KEY zur OE',
WL00207 IS 'Instrad_zur_OE',
WL00206 IS 'BKST_zur_OE',
WL00205 IS 'Art/Typ des Keys zur OE',
WL00204I IS 'Interne Auftragslaufnummer',
WL00204R IS 'Reserve (Auftrags-Nummer)',
WL00204L IS 'Laufnummer',
WL00204D IS 'Datum (JJJJMMTT)',
WL00204T IS 'Auftrag: Terminalnummer',
WL00203 IS 'Rolle der OE',
WL00202 IS 'Key zur Organisationseinheit',
WL00201 IS 'Periode');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGOWM301
-- Index=GOWM301.IWL002A001T On GOWM301.TWL002A101T
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX GOWM301.IWL002A001T
ON GOWM301.TWL002A101T
(WL00201 ASC,
WL00202 ASC,
WL00203 ASC,
WL00204T ASC,
WL00204D ASC,
WL00204L ASC,
WL00204R ASC,
WL00204I ASC)
USING STOGROUP G001
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGOWM301
-- Index=GOWM301.IWL002A101T On GOWM301.TWL002A101T
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX GOWM301.IWL002A101T
ON GOWM301.TWL002A101T
(WL00204T ASC,
WL00204D ASC,
WL00204L ASC,
WL00204R ASC,
WL00204I ASC,
WL00203 ASC)
USING STOGROUP G001
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGOWM301
-- Index=GOWM301.IWL002A201T On GOWM301.TWL002A101T
------------------------------------------------------------------------
--
CREATE INDEX GOWM301.IWL002A201T
ON GOWM301.TWL002A101T
(WL00201 ASC,
WL00203 ASC,
WL00206 ASC,
WL00207 ASC)
USING STOGROUP G001
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGOWM301
-- Index=GOWM301.IWL002A301T On GOWM301.TWL002A101T
------------------------------------------------------------------------
--
CREATE INDEX GOWM301.IWL002A301T
ON GOWM301.TWL002A101T
(WL00201 ASC,
WL00203 ASC,
WL00207 ASC)
USING STOGROUP G001
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 0
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=GOWM301.VWL002A101TV
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","GOWM301" ;
--
CREATE VIEW GOWM301.VWL002A101TV("Periode", "Key_zur_Orgeinheit",
"Rolle_der_OE", "Terminal_Nr", "Datum", "Laufnummer", "Reserve",
"Int_Auftr_Lnr", "Art_Typ_Key_zur_OE", "BKST_zur_OE",
"Instrad_zur_OE", "BUID_Key_OE", "Reserve_Char4", PID) AS
SELECT ALL GOWM301.TWL002A101T.WL00201,
GOWM301.TWL002A101T.WL00202, GOWM301.TWL002A101T.WL00203,
GOWM301.TWL002A101T.WL00204T, GOWM301.TWL002A101T.WL00204D,
GOWM301.TWL002A101T.WL00204L, GOWM301.TWL002A101T.WL00204R,
GOWM301.TWL002A101T.WL00204I, GOWM301.TWL002A101T.WL00205,
GOWM301.TWL002A101T.WL00206, GOWM301.TWL002A101T.WL00207,
GOWM301.TWL002A101T.WL00202U, GOWM301.TWL002A101T.WL00206U,
GOWM301.TWL002A101T.WL00208
FROM GOWM301.TWL002A101T ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--