zOs/SQL/MF200LA
------------------------------------------------------------------------
-- --
-- Database 2 Administration Tool (DB2 Admin) , program 5697-L90 (C) --
-- --
-- ADB2GEN - Extract object definitions from the DB2 Catalog tables --
-- --
-- Input prepared on : DBTF (810) Extract time : 2006-08-29 15: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=N TB=N VW=N SC=N UT=N UF=N SP=N SQ=N --
-- --
------------------------------------------------------------------------
--
SET CURRENT SQLID='S100447';
------------------------------------------------------------------------
-- --
-- ADB2GEN: Generate DDL for Tablespace=A200A In Database DA540769 --
-- --
------------------------------------------------------------------------
--
------------------------------------------------------------------------
-- Database=DA540769 Stogroup=GSMS (for partition 1)
-- Tablespace=DA540769.A200A
------------------------------------------------------------------------
--
CREATE TABLESPACE A200A
IN DA540769
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
FREEPAGE 10 PCTFREE 10
GBPCACHE CHANGED
TRACKMOD YES
DSSIZE 64G
NUMPARTS 32
(PART 16 FREEPAGE 0 PCTFREE 5)
BUFFERPOOL BP2
LOCKSIZE ANY
LOCKMAX SYSTEM
CLOSE YES
COMPRESS YES
CCSID EBCDIC
DEFINE YES
MAXROWS 255;
--
------------------------------------------------------------------------
-- Table=A540769.twk200A1 In DA540769.A200A
------------------------------------------------------------------------
--
CREATE TABLE A540769.TWK200A1
(MF200001 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200002 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200003 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200004 CHAR(25) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200005 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200006 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200007 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200008 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200009 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200010 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200011 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200012 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200013 DATE NOT NULL WITH DEFAULT,
MF200014 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200015 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200016 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200017 CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200018 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF200019 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF200020 CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200021 TIMESTAMP NOT NULL WITH DEFAULT,
MF200022 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200023 CHAR(12) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200024 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200025 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200026 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200027 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200028 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200029 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200030 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200031 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200032 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200033 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200034 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200035 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200036 CHAR(18) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200037 DECIMAL(15, 0) NOT NULL WITH DEFAULT,
MF200038 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200039 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200040 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200041 CHAR(2) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200042 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200043 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF200044 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200045 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200046 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200047 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200051 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200052 CHAR(3) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200053 DECIMAL(15, 3) NOT NULL WITH DEFAULT,
MF200054 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200055 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200056 CHAR(8) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200059 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200060 TIMESTAMP NOT NULL WITH DEFAULT,
MF200062 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200063 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200064 DATE NOT NULL WITH DEFAULT,
MF200065 DATE NOT NULL WITH DEFAULT,
MF200066 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200067 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200068 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200069 CHAR(4) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200070 CHAR(7) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200071 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200072 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200073 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200074 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200075 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200076 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200077 CHAR(6) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200078 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200079 CHAR(1) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200080 DATE NOT NULL WITH DEFAULT,
MF200081 CHAR(5) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200082 CHAR(26) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200083 SMALLINT NOT NULL WITH DEFAULT,
MF200084 SMALLINT NOT NULL WITH DEFAULT,
MF200085 SMALLINT NOT NULL WITH DEFAULT,
MF200086 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200087 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200088 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200089 CHAR(35) FOR SBCS DATA NOT NULL
WITH DEFAULT,
MF200090 SMALLINT NOT NULL WITH DEFAULT,
MF200091 SMALLINT NOT NULL WITH DEFAULT,
MF200092 CHAR(16) FOR SBCS DATA NOT NULL
WITH DEFAULT
-- CONSTRAINT MF200001
-- PRIMARY KEY (MF200001)
)
IN DA540769.A200A
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC
NOT VOLATILE;
--
LABEL ON TABLE A540769.twk200A1 IS 'dokumentierende Mittelflüsse';
--
LABEL ON A540769.TWK200A1
(MF200092 IS 'RM-PID international',
MF200091 IS 'Limiten-Hierarchie',
MF200090 IS 'Limiten-Typ',
MF200089 IS 'Ort Begünstigter',
MF200088 IS 'Name Begünstigter',
MF200087 IS 'Ort Auftraggeber',
MF200086 IS 'Name Auftraggeber',
MF200085 IS 'Life-Cycle-Status',
MF200084 IS 'Relevant-Group',
MF200083 IS 'Transaction-Typ',
MF200082 IS 'Lade_Timestamp_ID',
MF200081 IS 'Preiskomponente',
MF200080 IS 'mutierbar bis',
MF200079 IS 'Depot_Uebertrag',
MF200078 IS 'Vorheriger GP-Typ',
MF200077 IS 'Bankenclearing-Nr',
MF200076 IS 'Kommentar_Status',
MF200075 IS 'Edit-Status Gesamt',
MF200074 IS 'Edit-Status Hauptgruppe',
MF200073 IS 'Edit-Status Untergruppe',
MF200072 IS 'Edit-Status Gegenpartei',
MF200071 IS 'Prüfziffer Kundencif',
MF200070 IS 'Stammnummer Kundencif',
MF200069 IS 'Bankstelle Kundencif',
MF200068 IS 'int. Form OE Kundenbüro GP',
MF200067 IS 'int. Form OE Kundenbüro',
MF200066 IS 'int. Form OE-ID KV',
MF200065 IS 'Cif-Saldierungsdatum',
MF200064 IS 'Cif-Eröffnungsdatum',
MF200063 IS 'Mittelfluss-Identifikation',
MF200062 IS 'Coupon-Mantel',
MF200060 IS 'Erstellungstimestamp',
MF200059 IS 'Auftragslaufnummer',
MF200056 IS 'Policennr.',
MF200055 IS 'Richtung des Mittelflusses',
MF200054 IS 'Leitweg',
MF200053 IS 'Volumen in Nominal/Stück',
MF200052 IS 'Bearbeitungscode',
MF200051 IS 'Domizil Gegenpartei',
MF200047 IS 'Buchungsart',
MF200046 IS 'Programm_ID des Corbaservices',
MF200045 IS 'Depotstelle bzw. GMF_Laufnr.',
MF200044 IS 'Sequenz-Nummer zu Valor',
MF200043 IS 'Betrag zu Bestandeswährung',
MF200042 IS 'Bestandeswährung',
MF200041 IS 'Untergruppe Gegenpartei',
MF200040 IS 'Hauptgruppe Gegenpartei',
MF200039 IS 'Gegenpartei-Geldmarktzusatz',
MF200038 IS 'Gegenpartei-Beziehungsnummer',
MF200037 IS 'CSID Gegenpartei',
MF200036 IS 'Gegenpartei',
MF200035 IS 'Gegenpartei-Typ',
MF200034 IS 'BUID Gegenpartei',
MF200033 IS 'KundenverantwortlicheR',
MF200032 IS 'Kundenbüro Kunde',
MF200031 IS 'Kunden-Geldmarktzusatz',
MF200030 IS 'Kunden-Beziehungsnummer',
MF200029 IS 'Depotartenschlüssel',
MF200028 IS 'Kontoartenschlüssel',
MF200027 IS 'Kundendomizil',
MF200026 IS 'Kundensegment',
MF200025 IS 'Kundenart',
MF200024 IS 'PVV-Kunde',
MF200023 IS 'Cifnummer Kunde',
MF200022 IS 'BUID Kunde',
MF200021 IS 'Mutationsdatum',
MF200020 IS 'MutationsPID',
MF200019 IS 'Betrag in CHF',
MF200018 IS 'Betrag in FWhrg',
MF200017 IS 'Valor',
MF200016 IS 'Währung',
MF200015 IS 'Urheber',
MF200014 IS 'Grund',
MF200013 IS 'Buchungsdatum',
MF200012 IS 'Bewegungsverdichtung',
MF200011 IS 'Produkteklassifizierung',
MF200010 IS 'MF-Produkt',
MF200009 IS 'Produktenr_Prok/Bew.Art Depot',
MF200008 IS 'Bewegungsart Depot/Edelmetall',
MF200007 IS 'zu bewerten',
MF200006 IS 'nachzuerfassen',
MF200005 IS 'Storno',
MF200004 IS 'Auftragsnummer',
MF200003 IS 'Lieferantentyp',
MF200002 IS 'RZ-Herkunft',
MF200001 IS 'ID Mittelfluss (UUID)');
--
--
------------------------------------------------------------------------
-- Database=DA540769
-- Index=A540769.IMF200A1 On A540769.twk200A1
------------------------------------------------------------------------
--
CREATE INDEX A540769.IWK200A1
ON A540769.TWK200A1
(MF200067 ASC,
MF200013 DESC)
USING STOGROUP GSMS
PRIQTY 48 SECQTY 7200
FREEPAGE 0 PCTFREE 10
GBPCACHE CHANGED
CLUSTER
(PART 1 VALUES('0010ZZZZZZZZ9999'),
PART 2 VALUES('0011BACOBACO1299'),
PART 3 VALUES('0011BACOBACO1399'),
PART 4 VALUES('0011BACOBACO1599'),
PART 5 VALUES('0011BACOBACO1699'),
PART 6 VALUES('0011BACOBACO1799'),
PART 7 VALUES('0011BACOBACO2299'),
PART 8 VALUES('0011BACOBACO2599'),
PART 9 VALUES('0011BACOBACO2799'),
PART 10 VALUES('0011BAHEBAHE9999'),
PART 11 VALUES('0011BAHTBAHT9999'),
PART 12 VALUES('0011BCMBBCMB9999'),
PART 13 VALUES('0011BCMSBCMS9999'),
PART 14 VALUES('0011BCRFBCRF9999'),
PART 15 VALUES('0011BCTLBCTL9999'),
PART 16 VALUES('0011BCZTBCZT9999'),
PART 17 VALUES('0011BCZWBCZW9999'),
PART 18 VALUES('0011BDNUBDNU9999'),
PART 19 VALUES('0011BGBABGBA9999'),
PART 20 VALUES('0011CKZFCKZF9999'),
PART 21 VALUES('0012PZZZPZZZ9999'),
PART 22 VALUES('0012SCNNSCNN9999'),
PART 23 VALUES('0012SCRRSCRR9999'),
PART 24 VALUES('0012SCZSSCZS9999'),
PART 25 VALUES('0012SWESSWES9999'),
PART 26 VALUES('0012SWLNSWLN9999'),
PART 27 VALUES('0013ZZZZZZZZ9999'),
PART 28 VALUES('0014ZZZZZZZZ9999'),
PART 29 VALUES('0015NCZZNCZZ9999'),
PART 30 VALUES('0015NZZZNZZZ9999'),
PART 31 VALUES('0020ZZZZZZZZ9999'),
PART 32 VALUES('9999ZZZZZZZZ9999'))
BUFFERPOOL BP1
CLOSE YES
COPY NO
DEFINE YES;
commit;