zOs/TX/WK952DDT
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Title : TRG CZ03022C 0 --
-- --
-- Input prepared on : DBAF (915) Extract time : 2010-03-17 08:50 --
-- --
-- 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 --
-- Grants : SG=N DB=Y TS=Y TB=Y VW=Y SC=Y UT=Y UF=Y SP=Y SQ=Y --
-- --
------------------------------------------------------------------------
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Table space=A444A In Database CZ03A1A --
-- --
------------------------------------------------------------------------
--
--
------------------------------------------------------------------------
-- Stogroup=GSMS
------------------------------------------------------------------------
--
SET CURRENT SQLID='A547484';
--
CREATE STOGROUP GSMS
VOLUMES("*")
VCAT DBAF ;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=CZ03A1A Stogroup=GSMS (for partition 1)
-- Table space=CZ03A1A.A444A
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
--
CREATE TABLESPACE A444A
IN CZ03A1A
USING STOGROUP GSMS
PRIQTY 180 SECQTY 7200
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
NUMPARTS 8
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
COMMIT;
--
------------------------------------------------------------------------
-- Table=OA1A.TCZ444A1 In CZ03A1A.A444A
------------------------------------------------------------------------
--
SET CURRENT SQLID='OA1A';
--
CREATE TABLE OA1A.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,
CONSTRAINT CZ44401
PRIMARY KEY (CZ44401,
CZ44402,
CZ44403))
IN CZ03A1A.A444A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE OA1A.TCZ444A1 IS 'EAD Value';
--
LABEL ON OA1A.TCZ444A1
(CZ44413 IS 'D_END',
CZ44412 IS 'A_VLE_CAL_CNV_31_8',
CZ44411 IS 'A_VLE_EFF_CNV_31_8',
CZ44410 IS 'I_CRNCY_CNV_ISO_3',
CZ44409 IS 'A_VLE_CAL_31_8',
CZ44408 IS 'A_VLE_EFF_31_8',
CZ44407 IS 'I_CRNCY_ISO_3',
CZ44406 IS 'I_CALC_ELEMENT_VLE',
CZ44405 IS 'I_CALC_ELEMENT_T',
CZ44404 IS 'I_ID_CREATOR',
CZ44403 IS 'D_TIME_CREATED',
CZ44402 IS 'I_OBJECT_UUID',
CZ44401 IS 'I_CALCULATION_ID');
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=CZ03A1A
-- Index=OA1A.ICZ444A0 On OA1A.TCZ444A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1A.ICZ444A0
ON OA1A.TCZ444A1
(CZ44401 ASC,
CZ44402 ASC,
CZ44403 DESC)
USING STOGROUP GSMS
PRIQTY 180 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=CZ03A1A
-- Index=OA1A.ICZ444A1 On OA1A.TCZ444A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.ICZ444A1
ON OA1A.TCZ444A1
(CZ44402 ASC)
USING STOGROUP GSMS
PRIQTY 180 SECQTY 7200
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
(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(X'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF'))
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFER NO
DEFINE YES;
--
COMMIT;
--
------------------------------------------------------------------------
-- Database=CZ03A1A
-- Index=OA1A.ICZ444A2 On OA1A.TCZ444A1
------------------------------------------------------------------------
--
CREATE INDEX OA1A.ICZ444A2
ON OA1A.TCZ444A1
(CZ44402 ASC,
CZ44405 ASC,
CZ44406 ASC,
CZ44413 DESC)
USING STOGROUP GSMS
PRIQTY 12 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=OA1A.VCZ444A1V
------------------------------------------------------------------------
--
--
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","GDB0133" ;
--
CREATE VIEW OA1A.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 OA1A.TCZ444A1 ;
--
SET CURRENT SQLID='S100447';
--
GRANT SELECT ON TABLE OA1A.VCZ444A1V TO OA1A;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--