zOs/SQL/WKCMPDN

set current sqlid = 'S100447';
DROP   TABLE    OA1L.TDE032A1;
CREATE TABLE    OA1L.TDE032A1
   (DE03200 TIMESTAMP                            NOT NULL             ,
    DE03204U CHAR(20)                            NOT NULL
    DE03204T CHAR(2)                             NOT NULL             ,
    DE03204V CHAR(3)                             NOT NULL             ,
    DE03205 CHAR(12)                             NOT NULL             ,
    DE03206 CHAR(12)                             NOT NULL             ,
    DE03207 CHAR(1)                              NOT NULL             ,
    DE03208 CHAR(1)                              NOT NULL             ,
    DE03209 DECIMAL(15,3)                        NOT NULL             ,
    DE03210 FLOAT(53)                            NOT NULL             ,
    DE03211 CHAR(1)                              NOT NULL             ,
    DE03212 CHAR(7)                              NOT NULL             ,
    DE03213 CHAR(9)                              NOT NULL WITH DEFAULT,
    DE03214 CHAR(1)                              NOT NULL WITH DEFAULT,
    DE03215 CHAR(3)                              NOT NULL WITH DEFAULT,
    DE03216 CHAR(1)                              NOT NULL WITH DEFAULT,
       PRIMARY KEY (DE03204U                    ,
                    DE03204T                    ,
                    DE03204V                    )                     ,
       FOREIGN KEY CDE031A    (DE03204U            )
     REFERENCES OA1L.TDE031A1                   (DE03104U            )
               ON DELETE CASCADE                                      )
       IN DE03A1L.A032A
       AUDIT NONE
       CCSID EBCDIC
                                                                      ;
LABEL ON TABLE OA1L.TDE032A1
       IS 'HANDELSVERTRAG'
                                                                      ;
LABEL ON OA1L.TDE032A1
  (DE03200 IS 'Timestamp'                                             ,
   DE03204U IS 'UWI Handelsvereinbarung'                              ,
   DE03204T IS 'Vertragsnummer'                                       ,
   DE03204V IS 'Versionsnummer'                                       ,
   DE03205 IS 'gültig-ab'                                             ,
   DE03206 IS 'gültig-bis'                                            ,
   DE03207 IS 'Vertragsart (Termin/Kasse)'                            ,
   DE03208 IS 'Handelstyp (S=sell/B=buy)'                             ,
   DE03209 IS 'CHF-Gegenwert (Gesamt)'                                ,
   DE03210 IS 'direkter Kurs'                                         ,
   DE03211 IS 'Preiseinheit (ED)'                                     ,
   DE03212 IS 'Souchennummer'                                         ,
   DE03213 IS 'GLS-T Nummer'                                          ,
   DE03214 IS 'CLS-Flag (J=CLS/N=kein CLS)'                           ,
   DE03215 IS 'CLS-Status'                                            ,
   DE03216 IS 'CLS-Inhouse-Deal (J/N)'                                )
                                                                      ;