Spracherkennung für: .mco vermutete Sprache: Python {Python[76] Pl1[114] Fortran[118]} [Methode: Schwerpunktbildung, einfache Gewichte, sechs Dimensionen]
-- SQL Test Suite, V6.0, SQL Module xts760.mco
-- 59-byte ID
--
MODULE XTS760
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);
CREATE VIEW V000V AS
SELECT DEPTNO, AVG(SALARY) AS AVSAL
FROM CTS1.TABX760 GROUP BY DEPTNO;
PROCEDURE SUB4 (SQLCODE, SQLSTATE);
COMMIT WORK;
PROCEDURE SUB5 (SQLCODE, SQLSTATE,
:MAXSAL NUMERIC (9));
SELECT MAX(AVSAL) INTO :MAXSAL FROM V000V;
PROCEDURE SUB6 (SQLCODE, SQLSTATE);
COMMIT WORK;
PROCEDURE SUB7 (SQLCODE, SQLSTATE);
DROP VIEW V000V CASCADE;
PROCEDURE SUB8 (SQLCODE, SQLSTATE);
COMMIT WORK;
PROCEDURE SUB9 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7060','pass','MCO');
PROCEDURE SUB10 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7060','fail','MCO');
PROCEDURE SUB11 (SQLCODE, SQLSTATE);
COMMIT WORK;
[ Dauer der Verarbeitung: 0.106 Sekunden
]
