Untersuchungsergebnis.mco Download desPython {Python[69] Fortran[120] CS[139]}zum Wurzelverzeichnis wechseln
-- SQL Test Suite, V6.0, SQL Module yts800.mco
-- 59-byte ID
--
MODULE YTS800
LANGUAGE COBOL
AUTHORIZATION CTS1
DECLARE CRA CURSOR FOR
SELECT TTA FROM TT2
WHERE TTB+CAST(TTC AS INTERVAL MONTH) IS NULL
PROCEDURE SUB1 (SQLCODE, SQLSTATE,
:UIDX CHAR(18));
SELECT USER INTO :UIDX FROM CTS1.ECCO;
PROCEDURE SUB2 (SQLCODE, SQLSTATE);
ROLLBACK WORK;
PROCEDURE SUB3 (SQLCODE, SQLSTATE);
OPEN CRA;
PROCEDURE SUB4 (SQLCODE, SQLSTATE,
:CO NUMERIC (4));
SELECT COUNT (*) INTO :CO FROM TT2
WHERE NOT TTB+CAST(TTC AS INTERVAL MONTH) IS NULL
;
PROCEDURE SUB5 (SQLCODE, SQLSTATE);
CLOSE CRA;
PROCEDURE SUB6 (SQLCODE, SQLSTATE);
ROLLBACK WORK;
PROCEDURE SUB7 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7532','pass','MCO');
PROCEDURE SUB8 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7532','fail','MCO');
PROCEDURE SUB9 (SQLCODE, SQLSTATE);
COMMIT WORK;
PROCEDURE SUB10 (SQLCODE, SQLSTATE,
:COL1 NUMERIC (4));
FETCH CRA INTO :COL1;
[ zur Elbe Produktseite wechseln0.102Quellennavigators
]
