Ziele Untersuchung
mit Columbo Integrität von
Datenbanken Interaktion und
Portierbarkeit Ergonomie der
Schnittstellen

Angebot Produkte Projekt Beratung

Mittel Analytik Modellierung Sprachen Algebra Logik Hardware Denken Kreativität

Zusammenhänge Gesellschaft Wirtschaft Branche Firma


products/Sources/formale Sprachen/Cobol/Test-Suite/SQL M/ Datei vom 4.1.2008 mit Größe 1 kB

Quelle dml180.mco Sprache: unbekannt

-- SQL Test Suite, V6.0, SQL Module dml180.mco
-- 59-byte ID
--
MODULE DML180
LANGUAGE COBOL
AUTHORIZATION FLATER

PROCEDURE SUB1 (SQLCODE, SQLSTATE,
    :UIDX CHAR(18));
      SELECT USER INTO :UIDX FROM HU.ECCO;

PROCEDURE SUB2 (SQLCODE, SQLSTATE);
      ROLLBACK WORK;

PROCEDURE SUB3 (SQLCODE, SQLSTATE);
      ALLOCATE DESCRIPTOR 'L100';

PROCEDURE SUB4 (SQLCODE, SQLSTATE,
    :LONGST CHAR(999));
      PREPARE S100 FROM :LONGST;

PROCEDURE SUB5 (SQLCODE, SQLSTATE);
      DESCRIBE S100 USING SQL DESCRIPTOR 'L100';

PROCEDURE SUB6 (SQLCODE, SQLSTATE,
    :INT1 NUMERIC (9));
      GET DESCRIPTOR 'L100'
                    :INT1 = COUNT;

PROCEDURE SUB7 (SQLCODE, SQLSTATE,
    :INT1 NUMERIC (9));
      GET DESCRIPTOR 'L100'
                    VALUE 100
                    :INT1 = TYPE;

PROCEDURE SUB8 (SQLCODE, SQLSTATE,
    :INT1 NUMERIC (9));
      GET DESCRIPTOR 'L100'
                    VALUE 99
                    :INT1 = TYPE;

PROCEDURE SUB9 (SQLCODE, SQLSTATE);
      COMMIT WORK;

PROCEDURE SUB10 (SQLCODE, SQLSTATE);
      INSERT INTO HU.TESTREPORT
                      VALUES('0893','pass','MCO');

PROCEDURE SUB11 (SQLCODE, SQLSTATE);
      INSERT INTO HU.TESTREPORT
                      VALUES('0893','fail','MCO');

PROCEDURE SUB12 (SQLCODE, SQLSTATE);
      COMMIT WORK;