Quellcode-Bibliothek
© Kompilation durch diese Firma
[Weder Korrektheit noch Funktionsfähigkeit der Software werden zugesichert.]
Datei:
dml062.mco
Sprache: Unknown
Spracherkennung für: .mco vermutete Sprache: SQL {SQL[66] Scala[77] Pl1[86]} [Methode: Schwerpunktbildung, einfache Gewichte, sechs Dimensionen] -- SQL Test Suite, V6.0, SQL Module xts716.mco
-- 59-byte ID
--
MODULE XTS716
LANGUAGE COBOL
AUTHORIZATION CTS1
DECLARE ALPHA CURSOR FOR S
PROCEDURE SUB1 (SQLCODE, SQLSTATE,
:UIDX CHAR(18));
SELECT USER INTO :UIDX FROM CTS1.ECCO;
PROCEDURE SUB2 (SQLCODE, SQLSTATE);
ROLLBACK WORK;
PROCEDURE SUB3 (SQLCODE, SQLSTATE,
:COUN NUMERIC (9));
SELECT COUNT(*) INTO :COUN FROM CTS1.STAFF
;
PROCEDURE SUB4 (SQLCODE, SQLSTATE);
COMMIT WORK;
PROCEDURE SUB5 (SQLCODE, SQLSTATE,
:XUSER CHAR(20));
SET SESSION AUTHORIZATION :XUSER;
PROCEDURE SUB6 (SQLCODE, SQLSTATE,
:COUN NUMERIC (9));
SELECT COUNT(*) INTO :COUN FROM CTS1.STAFF
;
PROCEDURE SUB7 (SQLCODE, SQLSTATE);
COMMIT WORK;
PROCEDURE SUB8 (SQLCODE, SQLSTATE);
SET SESSION AUTHORIZATION USER;
PROCEDURE SUB9 (SQLCODE, SQLSTATE,
:SQLSM2 CHAR(31));
PREPARE S FROM :SQLSM2;
PROCEDURE SUB10 (SQLCODE, SQLSTATE);
OPEN ALPHA;
PROCEDURE SUB11 (SQLCODE, SQLSTATE,
:COUN NUMERIC (9));
FETCH ALPHA INTO :COUN;
PROCEDURE SUB12 (SQLCODE, SQLSTATE);
CLOSE ALPHA;
PROCEDURE SUB13 (SQLCODE, SQLSTATE);
ROLLBACK WORK;
PROCEDURE SUB14 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7016','pass','MCO');
PROCEDURE SUB15 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7016','fail','MCO');
PROCEDURE SUB16 (SQLCODE, SQLSTATE);
COMMIT WORK;
[ Dauer der Verarbeitung: 0.88 Sekunden
]
|
|