zOs/TX/WK989CDL

SQLID     SET CURRENT SQLID = 'S100447' ;
DROP      SET CURRENT SCHEMA='OA1T';
DROP      DROP INDEX OA1T.INI301A3 ;
DROP      COMMIT ;
DROP      DROP INDEX OA1T.INI301A4 ;
DROP      COMMIT ;
DROP      SET CURRENT SCHEMA='OA1T';
DROP      ALTER TABLE OA1T.TNI301A101A
DROP        ADD
DROP          VLTNCCYCD            CHAR(4) FOR SBCS DATA NOT NULL
DROP            WITH DEFAULT ;
DROP      SET CURRENT SCHEMA='OA1T';
DROP      ALTER TABLE OA1T.TNI301A101A
DROP        ADD
DROP          REFCLSTRID           CHAR(21) FOR SBCS DATA NOT NULL
DROP            WITH DEFAULT ;
DROP      SET CURRENT SCHEMA='OA1T';
DROP      ALTER TABLE OA1T.TNI301A101A
DROP        ADD
DROP          REFTRXID             CHAR(71) FOR SBCS DATA NOT NULL
DROP            WITH DEFAULT ;
CREATE    ALTER INDEX OA1T.INI301A1
CREATE      BUFFERPOOL BP1 ;
DROP      ADMIN DROP INDEX OA1T.INI301A2;
CREATE    SET CURRENT SCHEMA='OA1T';
CREATE    CREATE INDEX INI301A2
CREATE      ON OA1T.TNI301A101A
CREATE       (REFCLSTRID            ASC,
CREATE        REFTRXID              ASC)
CREATE      USING STOGROUP GSMS
CREATE      PRIQTY -1 SECQTY -1
CREATE      ERASE  NO
CREATE      FREEPAGE 5 PCTFREE 10
CREATE      GBPCACHE CHANGED
CREATE      NOT CLUSTER
CREATE      COMPRESS NO
CREATE      BUFFERPOOL BP1
CREATE      CLOSE NO
CREATE      COPY NO
CREATE      DEFER NO
CREATE      DEFINE YES;
CREATE    COMMIT ;
DROP      DROP TRIGGER OA1T.NI300AAI ;
DROP      COMMIT ;
DROP      DROP TRIGGER OA1T.NI300AAD ;
DROP      COMMIT ;
DROP      DROP TRIGGER OA1T.NI300AAU ;
DROP      COMMIT ;
DROP      DROP TRIGGER OA1T.NI660AAI ;
DROP      COMMIT ;
CREATE    SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","A540769" ;
DROP      ADMIN DROP VIEW OA1T.VNI301A101A ;
CREATE    SET CURRENT SCHEMA = 'OA1T' ;
CREATE    CREATE VIEW OA1T.VNI301A101A AS
CREATE      SELECT CLSTRID, TRXID, BESL, BESLSEQ, BOOKFLAG, PRODUCTCD,
CREATE             PROCESSINGTYP, PRICECOMP, BESLAMTTC, BESLAMTPC, BESLAMTVC,
CREATE             BESLUNITS, BESLNBRS, PROCCD, EKGRPCD, BESLCCYCD,
CREATE             TIMESTMPENTRY, POSKEY, SAFEKACCNBR, CONSIGNMENT, VLTNCCYCD,
CREATE             REFCLSTRID, REFTRXID
CREATE        FROM OA1T.TNI301A101A ;
CREATE    LABEL   ON TABLE OA1T.VNI301A101A IS 'TRANSACTION DETAIL' ;
CREATE    GRANT SELECT ON TABLE OA1T.VNI301A101A TO OA1T;