zOs/TX/WK995DDL
set current sqlid = 'S100447';
drop TABLESPACE $db.a995A;
commit;
$@[
if $phase = 1 then $@=[
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5655-W34 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : TRG WK09901C 2 --
-- --
-- Input prepared on : DBTF (1015 ) Extract time : 2012-08-23 11:27 --
-- --
-- Catalog values overridden : none
-- --
-- Generate : SG=Y DB=Y TS=Y TB=Y VW=Y IX=Y SY=Y AL=Y LB=Y CM=Y FK=Y --
-- TG=Y UT=Y UF=Y SP=Y SQ=Y RO=Y TC=Y MK=Y PM=Y AC=Y --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=a995a In Database $db --
-- --
------------------------------------------------------------------------
--
--
------------------------------------------------------------------------
-- Stogroup=GSMS
------------------------------------------------------------------------
--
--CREATE STOGROUP GSMS
-- VOLUMES("*")
-- VCAT DBTF ;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db Stogroup=GSMS
-- Table space=$db.a995a
------------------------------------------------------------------------
--
CREATE TABLESPACE a995a
IN $db
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 30
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=$creator.Twk995a1 In $db.a995a
------------------------------------------------------------------------
--
CREATE TABLE $creator.Twk995a1
(WU401001 CHAR(20) FOR SBCS DATA NOT NULL,
WU401002 CHAR(20) FOR SBCS DATA NOT NULL,
WU401003 CHAR(2) FOR SBCS DATA NOT NULL,
WU401004 TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL,
WU401005 CHAR(1) FOR SBCS DATA NOT NULL,
WU401006 INTEGER NOT NULL,
WU401007 CHAR(1) FOR SBCS DATA NOT NULL,
WU401008 TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL,
WU401009 SMALLINT NOT NULL,
WU401010 CHAR(8) FOR SBCS DATA NOT NULL,
WU401011 TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL,
WU401012 INTEGER NOT NULL WITH DEFAULT 0,
WU401013 INTEGER NOT NULL WITH DEFAULT 0,
WU401014 SMALLINT NOT NULL WITH DEFAULT 0,
WU401015 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WU401016 CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WU401017 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CONSTRAINT WU401001
PRIMARY KEY (WU401001,
WU401009,
WU401002,
WU401012,
WU401003,
WU401013,
WU401014,
WU401015,
WU401016,
WU401017))
IN $db.a995a
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
--
LABEL ON TABLE $creator.Twk995a1 IS 'Termine';
--
LABEL ON $creator.Twk995a1
(WU401017 IS 'DST',
WU401016 IS 'VALORNR',
WU401015 IS 'DEPOT_UUID',
WU401014 IS 'TERMIN_LNR',
WU401013 IS 'POSLNR',
WU401012 IS 'SHNR_INT',
WU401011 IS 'MUT_TS',
WU401010 IS 'MUTPID',
WU401009 IS 'APPLID',
WU401008 IS 'ERLEDIGT_TS',
WU401007 IS 'FREIGABECODE',
WU401006 IS 'TERMINART',
WU401005 IS 'TERMIN_STC',
WU401004 IS 'TERMIN_TS',
WU401003 IS 'TERMINID',
WU401002 IS 'SHNR',
WU401001 IS 'AHNR');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk995a0 On $creator.Twk995a1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX $creator.Iwk995a0
ON $creator.Twk995a1
(WU401001 ASC,
WU401009 ASC,
WU401002 ASC,
WU401012 ASC,
WU401003 ASC,
WU401013 ASC,
WU401014 ASC,
WU401015 ASC,
WU401016 ASC,
WU401017 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 30
GBPCACHE CHANGED
CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk995a4 On $creator.Twk995a1
------------------------------------------------------------------------
--
CREATE INDEX $creator.Iwk995a4
ON $creator.Twk995a1
(WU401004 ASC,
WU401005 ASC,
WU401003 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk995a3 On $creator.Twk995a1
------------------------------------------------------------------------
--
CREATE INDEX $creator.Iwk995a3
ON $creator.Twk995a1
(WU401003 ASC,
WU401004 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk995a2 On $creator.Twk995a1
------------------------------------------------------------------------
--
CREATE INDEX $creator.Iwk995a2
ON $creator.Twk995a1
(WU401005 ASC,
WU401003 ASC,
WU401004 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk995a1 On $creator.Twk995a1
------------------------------------------------------------------------
--
CREATE INDEX $creator.Iwk995a1
ON $creator.Twk995a1
(WU401004 DESC,
WU401006 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table=$creator.Twk995a1
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- View=$creator.Vwk995a1V
------------------------------------------------------------------------
--
SET CURRENT SCHEMA='$creator';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","A754048" ;
--
CREATE VIEW $creator.Vwk995a1V(AHNR, APPLID, SHNR, SHNR_INT, TERMINID,
DEPOT_UUID, VALORNR, DST, POSLNR, TERMIN_LNR, TERMIN_TS,
TERMIN_STC, TERMINART, FREIGABECODE, ERLEDIGT_TS, MUTPID, MUT_TS)
AS
SELECT ALL WU401001, WU401009, WU401002, WU401012, WU401003,
WU401015, WU401016, WU401017, WU401013, WU401014, WU401004,
WU401005, WU401006, WU401007, WU401008, WU401010, WU401011
FROM $creator.Twk995a1 ;
--
--
COMMIT;
--
$] else if $phase = 2 then $@=[
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5655-W34 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : SRC WK09901C 2 --
-- --
-- Input prepared on : DX0G (1015 ) Extract time : 2012-08-23 11:26 --
-- --
-- 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=Y UF=Y SP=Y SQ=Y RO=N TC=N MK=N PM=N AC=N --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=a995a In Database $db --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=$db Stogroup=GSMS
-- Table space=$db.a995a
------------------------------------------------------------------------
--
CREATE TABLESPACE a995a
IN $db
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 0 PCTFREE 30
GBPCACHE CHANGED
TRACKMOD YES
LOGGED
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE NO
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=$creator.Twk995a1 In $db.a995a
------------------------------------------------------------------------
--
CREATE TABLE $creator.Twk995a1
(WU401001 CHAR(20) FOR SBCS DATA NOT NULL,
WU401002 CHAR(20) FOR SBCS DATA NOT NULL,
WU401003 CHAR(2) FOR SBCS DATA NOT NULL,
WU401004 TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL,
WU401005 CHAR(1) FOR SBCS DATA NOT NULL,
WU401006 INTEGER NOT NULL,
WU401007 CHAR(1) FOR SBCS DATA NOT NULL,
WU401008 TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL,
WU401009 SMALLINT NOT NULL,
WU401010 CHAR(8) FOR SBCS DATA NOT NULL,
WU401011 TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL,
WU401012 INTEGER NOT NULL WITH DEFAULT 0,
WU401013 INTEGER NOT NULL WITH DEFAULT 0,
WU401014 SMALLINT NOT NULL WITH DEFAULT 0,
WU401015 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WU401016 CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WU401017 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
WU401018 SMALLINT NOT NULL WITH DEFAULT,
WU401019 TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL
WITH DEFAULT '0001-01-01-00.00.00.000000',
WU401020 TIMESTAMP (6) WITHOUT TIME ZONE NOT NULL
WITH DEFAULT '9999-12-31-23.59.59.999999',
CONSTRAINT WU401001
PRIMARY KEY (WU401001,
WU401009,
WU401002,
WU401012,
WU401003,
WU401013,
WU401014,
WU401015,
WU401016,
WU401017,
WU401019))
IN $db.a995a
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE
APPEND NO ;
--
LABEL ON TABLE $creator.Twk995a1 IS 'Termine';
--
LABEL ON $creator.Twk995a1
(WU401020 IS 'VALID TO',
WU401019 IS 'VALID FROM',
WU401018 IS 'ROW STATUS',
WU401017 IS 'DST',
WU401016 IS 'VALORNR',
WU401015 IS 'DEPOT_UUID',
WU401014 IS 'TERMIN_LNR',
WU401013 IS 'POSLNR',
WU401012 IS 'SHNR_INT',
WU401011 IS 'MUT_TS',
WU401010 IS 'MUTPID',
WU401009 IS 'APPLID',
WU401008 IS 'ERLEDIGT_TS',
WU401007 IS 'FREIGABECODE',
WU401006 IS 'TERMINART',
WU401005 IS 'TERMIN_STC',
WU401004 IS 'TERMIN_TS',
WU401003 IS 'TERMINID',
WU401002 IS 'SHNR',
WU401001 IS 'AHNR');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk995a1 On $creator.Twk995a1
------------------------------------------------------------------------
--
CREATE INDEX $creator.Iwk995a1
ON $creator.Twk995a1
(WU401004 DESC,
WU401006 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk995a2 On $creator.Twk995a1
------------------------------------------------------------------------
--
CREATE INDEX $creator.Iwk995a2
ON $creator.Twk995a1
(WU401005 ASC,
WU401003 ASC,
WU401004 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk995a3 On $creator.Twk995a1
------------------------------------------------------------------------
--
CREATE INDEX $creator.Iwk995a3
ON $creator.Twk995a1
(WU401003 ASC,
WU401004 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk995a4 On $creator.Twk995a1
------------------------------------------------------------------------
--
CREATE INDEX $creator.Iwk995a4
ON $creator.Twk995a1
(WU401004 ASC,
WU401005 ASC,
WU401003 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 30
GBPCACHE CHANGED
NOT CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=$db
-- Index=$creator.Iwk995a0 On $creator.Twk995a1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX $creator.Iwk995a0
ON $creator.Twk995a1
(WU401001 ASC,
WU401009 ASC,
WU401002 ASC,
WU401012 ASC,
WU401003 ASC,
WU401013 ASC,
WU401014 ASC,
WU401015 ASC,
WU401016 ASC,
WU401017 ASC,
WU401019 ASC)
USING STOGROUP GSMS
PRIQTY -1 SECQTY -1
ERASE NO
FREEPAGE 10 PCTFREE 30
GBPCACHE CHANGED
CLUSTER
COMPRESS NO
BUFFERPOOL BP1
CLOSE NO
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=$creator.Vwk995a1V
------------------------------------------------------------------------
--
SET CURRENT SCHEMA='G747607';
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","G747607" ;
--
CREATE VIEW $creator.Vwk995a1V(AHNR, APPLID, SHNR, SHNR_INT, TERMINID,
DEPOT_UUID, VALORNR, DST, POSLNR, TERMIN_LNR, TERMIN_TS,
TERMIN_STC, TERMINART, FREIGABECODE, ERLEDIGT_TS, MUTPID,
MUT_TS, ROW_STATUS, VALID_FROM, VALID_TO) AS
SELECT ALL $creator.Twk995a1.WU401001, $creator.Twk995a1.WU401009,
$creator.Twk995a1.WU401002, $creator.Twk995a1.WU401012,
$creator.Twk995a1.WU401003, $creator.Twk995a1.WU401015,
$creator.Twk995a1.WU401016, $creator.Twk995a1.WU401017,
$creator.Twk995a1.WU401013, $creator.Twk995a1.WU401014,
$creator.Twk995a1.WU401004, $creator.Twk995a1.WU401005,
$creator.Twk995a1.WU401006, $creator.Twk995a1.WU401007,
$creator.Twk995a1.WU401008, $creator.Twk995a1.WU401010,
$creator.Twk995a1.WU401011, $creator.Twk995a1.WU401018,
$creator.Twk995a1.WU401019, $creator.Twk995a1.WU401020
FROM $creator.Twk995a1 ;
--
COMMIT;
$]
$]