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 Thinking Intellekt

Zusammenhänge Gesellschaft Wirtschaft Branche Firma


products/Sources/formale Sprachen/COBOL/Test-Suite/SQL M/

Quellcode-Bibliothek

^© Kompilation durch diese Firma

[Weder Korrektheit noch Funktionsfähigkeit der Software werden zugesichert.]

Datei: mpb011.mco Sprache: Unknown

Untersuchungsergebnis.mco Download desShell {Shell[50] CS[71] Ada[134]}zum Wurzelverzeichnis wechseln

-- SQL Test Suite, V6.0, SQL Module dml012.mco
-- 59-byte ID

MODULE DML012
LANGUAGE COBOL
AUTHORIZATION HU

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

PROCEDURE SUB1 SQLCODE
    :I NUMERIC (9);
      SELECT COUNT(*)
                  INTO    :I
                  FROM   STAFF;

PROCEDURE SUB2 SQLCODE;
      DELETE FROM STAFF;

PROCEDURE SUB3 SQLCODE
    :II NUMERIC (9);
      SELECT COUNT(*)
                  INTO    :II
                  FROM   STAFF;

PROCEDURE SUB4 SQLCODE;
      ROLLBACK WORK;

PROCEDURE SUB5 SQLCODE
    :III NUMERIC (9);
      SELECT COUNT(*)
                  INTO    :III
                  FROM   STAFF;

PROCEDURE SUB6 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0037','pass','MCO');

PROCEDURE SUB7 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0037','fail','MCO');

PROCEDURE SUB8 SQLCODE;
      COMMIT WORK;

PROCEDURE SUB9 SQLCODE
    :I NUMERIC (9);
      SELECT COUNT(*)
                  INTO    :I
                  FROM   WORKS;

PROCEDURE SUB10 SQLCODE;
      DELETE FROM WORKS
                  WHERE WORKS.PNUM IN
                  (SELECT PROJ.PNUM
                  FROM   PROJ
                  WHERE  PROJ.PNUM=WORKS.PNUM
                  AND PROJ.CITY='Tampa');

PROCEDURE SUB11 SQLCODE
    :II NUMERIC (9);
      SELECT COUNT(*)
                  INTO    :II
                  FROM   WORKS;

PROCEDURE SUB12 SQLCODE;
      ROLLBACK WORK;

PROCEDURE SUB13 SQLCODE
    :III NUMERIC (9);
      SELECT COUNT(*)
                  INTO    :III
                  FROM   WORKS;

PROCEDURE SUB14 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0038','pass','MCO');

PROCEDURE SUB15 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0038','fail','MCO');

PROCEDURE SUB16 SQLCODE;
      COMMIT WORK;