Untersuchungsergebnis.mco Download desPython {Python[84] Fortran[101] CS[138]}zum Wurzelverzeichnis wechseln
-- SQL Test Suite, V6.0, SQL Module yts795.mco
-- 59-byte ID
--
MODULE YTS795
LANGUAGE COBOL
AUTHORIZATION CTS4
PROCEDURE SUB1 (SQLCODE, SQLSTATE,
:UIDX CHAR(18));
SELECT USER INTO :UIDX FROM CTS1.ECCO;
PROCEDURE SUB2 (SQLCODE, SQLSTATE);
ROLLBACK WORK;
PROCEDURE SUB3 (SQLCODE, SQLSTATE);
CREATE TABLE TC
( TCC CHARACTER(3) CHARACTER SET CTS1.CS2);
PROCEDURE SUB4 (SQLCODE, SQLSTATE);
COMMIT WORK;
PROCEDURE SUB5 (SQLCODE, SQLSTATE,
:CO NUMERIC (4));
SELECT COUNT (*) INTO :CO FROM
INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA LIKE 'CTS4%' AND TABLE_NAME LIKE 'TC%'
;
PROCEDURE SUB6 (SQLCODE, SQLSTATE);
ROLLBACK WORK;
PROCEDURE SUB7 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7529','pass','MCO');
PROCEDURE SUB8 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7529','fail','MCO');
PROCEDURE SUB9 (SQLCODE, SQLSTATE);
COMMIT WORK;
[ zur Elbe Produktseite wechseln0.186Quellennavigators
]
