|
-- SQL Test Suite, V6.0, SQL Module yts790.mco
-- 59-byte ID
--
MODULE YTS790
LANGUAGE COBOL
AUTHORIZATION CTS1
PROCEDURE SUB1 (SQLCODE, SQLSTATE,
:UIDX CHAR(18));
SELECT USER INTO :UIDX FROM CTS1.ECCO;
PROCEDURE SUB2 (SQLCODE, SQLSTATE);
ROLLBACK WORK;
PROCEDURE SUB3 (SQLCODE, SQLSTATE);
GRANT USAGE ON CHARACTER SET CS
TO CTS2 WITH GRANT OPTION;
PROCEDURE SUB4 (SQLCODE, SQLSTATE);
COMMIT WORK;
PROCEDURE SUB5 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7524','pass','MCO');
PROCEDURE SUB6 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7524','fail','MCO');
PROCEDURE SUB7 (SQLCODE, SQLSTATE);
COMMIT WORK;
[ Dauer der Verarbeitung: 0.14 Sekunden
(vorverarbeitet)
]
|
