zOs/SQL/DBATST51

set current sqlid = 'S100447';
-- drop tablespace QQ99a1a.A051A;
commit ;
--
  CREATE TABLESPACE A051A
    IN QQ99a1a
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 48
    erase no
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE 16
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
--
------------------------------------------------------------------------
--    Table=oa1t.TQQ051A In QQ99a1a.A051A
------------------------------------------------------------------------
--
  CREATE TABLE oa1t.TQQ051A
     (QQ051ID              CHAR(10) FOR SBCS DATA NOT NULL,
      QQ051TXT             CHAR(20) FOR SBCS DATA WITH DEFAULT NULL,
      QQ051FOR             CHAR(10) FOR SBCS DATA WITH DEFAULT NULL)
    IN QQ99a1a.A051A
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
--
------------------------------------------------------------------------
-- Database=QQ99a1a
--    Index=oa1t.IQQ051A0 On oa1t.TQQ051A
------------------------------------------------------------------------
--
  CREATE UNIQUE INDEX oa1t.IQQ051A0
    ON oa1t.TQQ051A
     (QQ051ID               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;
--
------------------------------------------------------------------------
--    View=oa1t.VQQ051V1
------------------------------------------------------------------------
--
--
  SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","s100447" ;
--
  CREATE VIEW oa1t.VQQ051V1 AS
    SELECT *
      FROM oa1t.TQQ051A ;
--
------------------------------------------------------------------------
--    View=oa1t.VQQ051V2
------------------------------------------------------------------------
--
--
  CREATE VIEW oa1t.VQQ051V2 AS
    SELECT *
      FROM oa1t.TQQ051A ;
--
--#SET TERMINATOR ?
--
------------------------------------------------------------------------
--    Triggers for Table=oa1t.TQQ051A
------------------------------------------------------------------------
--
  SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","S100447" ?
--
  CREATE TRIGGER oa1t.QQ051TRIG
    AFTER DELETE ON oa1t.TQQ051A
    REFERENCING OLD AS OLD
    FOR EACH ROW MODE DB2SQL
      INSERT INTO oa1t.TQQ051A("QQ051ID", "QQ051TXT", "QQ051FOR")
        VALUES(OLD.QQ051ID, 'deleteTriggerEins', OLD.QQ051FOR) ?
--
------------------------------------------------------------------------
--    Triggers for Table=oa1t.TQQ051A
------------------------------------------------------------------------
--
  CREATE TRIGGER oa1t.QQ051TRIG2
    AFTER DELETE ON oa1t.TQQ051A
    REFERENCING OLD AS OLD
    FOR EACH ROW MODE DB2SQL
      INSERT INTO oa1t.TQQ051A("QQ051ID", "QQ051TXT", "QQ051FOR")
        VALUES(OLD.QQ051ID, 'deleteTriggerZwei', OLD.QQ051FOR) ?
--
--#SET TERMINATOR ;
--
  COMMIT;
--
--  REBIND TRIGGER PACKAGE(oa1t.QQ051TRIG)
--
--  REBIND TRIGGER PACKAGE(oa1t.QQ051TRIG2)
--
------------------------------------------------------------------------
-- ADB2GEN - End of generated DDL                                     --
------------------------------------------------------------------------
--