rahmenlose Ansicht.mco DruckansichtPython {Python[87] Lex[101] Fortran[105]}zum Wurzelverzeichnis wechseln
-- SQL Test Suite, V6.0, SQL Module yts771.mco
-- 59-byte ID
--
MODULE YTS771
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,
:CO NUMERIC (4));
SELECT COUNT (*) INTO :CO
FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_SCHEMA = 'INFORMATION_SCHEMA'
AND CHARACTER_SET_NAME = 'SQL_TEXT';
PROCEDURE SUB4 (SQLCODE, SQLSTATE,
:CSC CHAR(128),
:DCC CHAR(128),
:DCS CHAR(128),
:DCN CHAR(128));
SELECT CHARACTER_SET_CATALOG,
DEFAULT_COLLATE_CATALOG,
DEFAULT_COLLATE_SCHEMA, DEFAULT_COLLATE_NAME
INTO :CSC, :DCC, :DCS, :DCN
FROM INFORMATION_SCHEMA.CHARACTER_SETS
WHERE CHARACTER_SET_SCHEMA = 'INFORMATION_SCHEMA'
AND CHARACTER_SET_NAME = 'SQL_TEXT';
PROCEDURE SUB5 (SQLCODE, SQLSTATE);
ROLLBACK WORK;
PROCEDURE SUB6 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7553','pass','MCO');
PROCEDURE SUB7 (SQLCODE, SQLSTATE);
INSERT INTO CTS1.TESTREPORT
VALUES('7553','fail','MCO');
PROCEDURE SUB8 (SQLCODE, SQLSTATE);
COMMIT WORK;
[ Verzeichnis aufwärts0.356unsichere Verbindung
]
