zOs/SQL/FZ01001
------------------------------------------------------------------------
-- --
-- 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-11-21 10:00 --
-- --
-- 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=A023A In Database FZ01A1A --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=FZ01A1P Stogroup=GSMS
-- Tablespace=FZ01A1P.A023A
------------------------------------------------------------------------
--
CREATE TABLESPACE A023A
IN FZ01A1P
USING STOGROUP GSMS
PRIQTY 720 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 5
GBPCACHE CHANGED
TRACKMOD YES
SEGSIZE 64
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 40;
--
------------------------------------------------------------------------
-- Table=OA1P.TFZ023A1 In FZ01A1P.A023A
------------------------------------------------------------------------
--
CREATE TABLE OA1P.TFZ023A1
(FZ02300 TIMESTAMP NOT NULL,
FZ02301 CHAR(16) FOR SBCS DATA NOT NULL,
FZ02302 INTEGER NOT NULL,
FZ02303 CHAR(3) FOR SBCS DATA NOT NULL,
FZ02304 CHAR(3) FOR SBCS DATA NOT NULL,
FZ02305 INTEGER NOT NULL,
FZ02306 INTEGER NOT NULL,
FZ02307 INTEGER NOT NULL,
FZ02308 CHAR(1) FOR SBCS DATA NOT NULL,
FZ02309 CHAR(2) FOR SBCS DATA NOT NULL,
FZ02310 CHAR(16) FOR SBCS DATA NOT NULL,
FZ02311 CHAR(20) FOR SBCS DATA NOT NULL,
FZ02312 CHAR(1) FOR SBCS DATA NOT NULL,
FZ02313 CHAR(5) FOR SBCS DATA NOT NULL,
FZ02314 CHAR(2) FOR SBCS DATA NOT NULL,
FZ02315 CHAR(11) FOR SBCS DATA NOT NULL,
CONSTRAINT FZ02301
PRIMARY KEY (FZ02301,
FZ02305,
FZ02302,
FZ02304))
IN FZ01A1P.A023A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE OA1P.TFZ023A1 IS 'Buchungsposten ';
--
LABEL ON OA1P.TFZ023A1
(FZ02315 IS 'Zahlungs-Empfänger ',
FZ02314 IS 'TP-Status-Code',
FZ02313 IS 'Zahlungs-Meldungs-Typ',
FZ02312 IS 'KONTO-MERKMALE',
FZ02311 IS 'CIF-UWI KONTOINHABER',
FZ02310 IS 'KONTO-GUTSCHRIFT/BELAST',
FZ02309 IS 'ZAHLUNGSVERKEHRSFALL',
FZ02308 IS 'EINGANG/AUSGANG',
FZ02307 IS 'ANZAHL POSTEN ',
FZ02306 IS 'POSTEN-GEGENSEITE',
FZ02305 IS 'POSTEN-NR.CODE',
FZ02304 IS 'VERARBEITUNGS-ART',
FZ02303 IS 'STATUS-CODE ',
FZ02302 IS 'LAUF-NUMMER ',
FZ02301 IS 'UUID ',
FZ02300 IS 'TIMESTAMP ');
--
------------------------------------------------------------------------
-- Database=FZ01A1P
-- Index=OA1P.IFZ023A0 On OA1P.TFZ023A1
------------------------------------------------------------------------
--
CREATE UNIQUE INDEX OA1P.IFZ023A0
ON OA1P.TFZ023A1
(FZ02301 ASC,
FZ02305 ASC,
FZ02302 ASC,
FZ02304 ASC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
NOT CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
------------------------------------------------------------------------
-- Database=FZ01A1P
-- Index=OA1P.IFZ023A1 On OA1P.TFZ023A1
------------------------------------------------------------------------
--
CREATE INDEX OA1P.IFZ023A1
ON OA1P.TFZ023A1
(FZ02305 ASC,
FZ02310 ASC,
FZ02301 ASC)
USING STOGROUP GSMS
PRIQTY 720 SECQTY 720
ERASE NO
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES
PIECESIZE 2 G;
--
COMMIT;
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL --
------------------------------------------------------------------------
--