zOs/SQL/CREFOR

set current sqlid = 's100447';
drop         TABLESPACE             DA540769.a003a
;
commit
;
CREATE       TABLESPACE A003A    IN DA540769
       USING STOGROUP GSMS
             PRIQTY 48
             SECQTY 7200
             ERASE NO
             FREEPAGE   0
             PCTFREE 10
             COMPRESS YES
             GBPCACHE CHANGED
             TRACKMOD YES
       BUFFERPOOL BP2
       LOCKSIZE ANY
       LOCKMAX SYSTEM
       CCSID EBCDIC
       MAXROWS 255
       CLOSE YES
       SEGSIZE 64
                                                                      ;
CREATE TABLE    A540769.TWK003A
   (WK003ID CHAR(10)                             NOT NULL             ,
    WK003TXT CHAR(20)                                                 ,
    WK003FOR CHAR(10)                                                 ,
    WK003GEN DECIMAL(25)                         NOT NULL
     GENERATED BY DEFAULT
     AS IDENTITY
     ( START WITH -9999999999999999999999999         ,
       INCREMENT BY +1                               ,
       CACHE 20                                                       ,
       NO CYCLE                                                       ,
       MAXVALUE +9999999999999999999999999                            ,
       MINVALUE -9999999999999999999999999                            )
                                                                      ,
CONSTRAINT WK003PRIM            PRIMARY KEY (WK003ID             )    )
       IN DA540769.A003A
       AUDIT NONE
       CCSID EBCDIC
                                                                      ;
LABEL ON TABLE A540769.TWK003A
       IS 'table drei mit foreign key'
                                                                      ;
CREATE UNIQUE INDEX A540769.IWK003A0
       ON A540769.TWK003A
     ( WK003ID              ASC  )
       USING STOGROUP GSMS
             PRIQTY      48
             SECQTY    7200
       ERASE NO
       FREEPAGE   0
       PCTFREE 10
       GBPCACHE CHANGED
       BUFFERPOOL BP1
       CLOSE YES
       PIECESIZE 2       G
       COPY NO
                                                                      ;
ALTER TABLE A540769.TWK003A                  FOREIGN KEY WK003FOR
      (WK003FOR                  )
       REFERENCES A540769.TWK003A
      (WK003ID                   )
       ON DELETE NO ACTION                                            ;