zOs/TX/WK952DDS
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : SRC CZ03022C 0 --
-- --
-- Input prepared on : DBAF (915) Extract time : 2010-03-17 08:49 --
-- --
-- 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 RO=N TC=N --
-- Grants : SG=N DB=N TS=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=S444A In Database DGDB0133 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DGDB0133 Stogroup=G001 (for partition 1)
-- Table space=DGDB0133.S444A
------------------------------------------------------------------------
--
SET CURRENT SQLID='GDB0133';
--
CREATE TABLESPACE S444A
IN DGDB0133
USING STOGROUP G001
PRIQTY 12 SECQTY 40
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
NUMPARTS 8
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS NO
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=GDB0133.TCZ444A1 In DGDB0133.S444A
------------------------------------------------------------------------
--
CREATE TABLE GDB0133.TCZ444A1
(CZ44401 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CZ44402 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CZ44403 TIMESTAMP NOT NULL WITH DEFAULT,
CZ44404 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CZ44405 INTEGER NOT NULL WITH DEFAULT,
CZ44406 CHAR(20) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CZ44407 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CZ44408 DECIMAL(31, 8) NOT NULL WITH DEFAULT,
CZ44409 DECIMAL(31, 8) NOT NULL WITH DEFAULT,
CZ44410 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
CZ44411 DECIMAL(31, 8) NOT NULL WITH DEFAULT,
CZ44412 DECIMAL(31, 8) NOT NULL WITH DEFAULT,
CZ44413 DATE NOT NULL WITH DEFAULT)
IN DGDB0133.S444A
PARTITION BY (CZ44402 ASC)
(PART 1 VALUES(X'1F'),
PART 2 VALUES(X'3F'),
PART 3 VALUES(X'5F'),
PART 4 VALUES(X'7F'),
PART 5 VALUES(X'9F'),
PART 6 VALUES(X'BF'),
PART 7 VALUES(X'DF'),
PART 8 VALUES(MAXVALUE))
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB0133
-- Index=GDB0133.ICZ444A0 On GDB0133.TCZ444A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX GDB0133.ICZ444A0
ON GDB0133.TCZ444A1
(CZ44401 ASC,
CZ44402 ASC,
CZ44403 DESC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB0133
-- Index=GDB0133.ICZ444A1 On GDB0133.TCZ444A1
------------------------------------------------------------------------
--
CREATE INDEX GDB0133.ICZ444A1
ON GDB0133.TCZ444A1
(CZ44402 ASC)
USING STOGROUP G001
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=DGDB0133
-- Index=GDB0133.ICZ444A2 On GDB0133.TCZ444A1
------------------------------------------------------------------------
--
CREATE INDEX GDB0133.ICZ444A2
ON GDB0133.TCZ444A1
(CZ44402 ASC,
CZ44405 ASC,
CZ44406 ASC,
CZ44413 DESC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- View=GDB0133.VCZ444A1V
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","GDB0133" ;
--
CREATE VIEW GDB0133.VCZ444A1V(I_CALCULATION_ID, I_OBJECT_UUID,
D_TIME_CREATED, I_ID_CREATOR, I_CALC_ELEMENT_T,
I_CALC_ELEMENT_VLE, I_CRNCY_ISO_3, A_VLE_EFF_31_8,
A_VLE_CAL_31_8, I_CRNCY_CNV_ISO_3, A_VLE_EFF_CNV_31_8,
A_VLE_CAL_CNV_31_8, D_END) AS
SELECT ALL CZ44401, CZ44402, CZ44403, CZ44404, CZ44405, CZ44406,
CZ44407, CZ44408, CZ44409, CZ44410, CZ44411, CZ44412,
CZ44413
FROM GDB0133.TCZ444A1 ;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--