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: Sprache: Unknown

Columbo aufrufen.mco zum Wurzelverzeichnis wechselnLex {Lex[79] Fortran[87] CS[110]}Datei anzeigen

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

MODULE CDR005
LANGUAGE COBOL
AUTHORIZATION SUN

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

PROCEDURE SUB1 SQLCODE;
      DELETE FROM STAFF5;

PROCEDURE SUB2 SQLCODE;
      INSERT INTO STAFF5
                  VALUES('E2','Tom',14,'Newyork');

PROCEDURE SUB3 SQLCODE;
      UPDATE STAFF5
                  SET GRADE = 20;

PROCEDURE SUB4 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1
                  FROM STAFF5
                  WHERE GRADE = 14;

PROCEDURE SUB5 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0313','pass','MCO');

PROCEDURE SUB6 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0313','fail','MCO');

PROCEDURE SUB7 SQLCODE;
      COMMIT WORK;

PROCEDURE SUB8 SQLCODE;
      DELETE FROM STAFF6;

PROCEDURE SUB9 SQLCODE;
      INSERT INTO STAFF6
                  VALUES('E2','Tom',14,'Newyork');

PROCEDURE SUB10 SQLCODE;
      UPDATE STAFF6
                  SET GRADE = 20;

PROCEDURE SUB11 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1
                  FROM STAFF6
                  WHERE GRADE = 14;

PROCEDURE SUB12 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0314','pass','MCO');

PROCEDURE SUB13 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0314','fail','MCO');

PROCEDURE SUB14 SQLCODE;
      COMMIT WORK;

PROCEDURE SUB15 SQLCODE;
      DELETE FROM STAFF7;

PROCEDURE SUB16 SQLCODE;
      INSERT INTO STAFF7
                  VALUES('E2','Tom',14,'Newyork');

PROCEDURE SUB17 SQLCODE;
      UPDATE STAFF7
                  SET GRADE = 21;

PROCEDURE SUB18 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1
                  FROM STAFF7
                  WHERE GRADE = 14;

PROCEDURE SUB19 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0315','pass','MCO');

PROCEDURE SUB20 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0315','fail','MCO');

PROCEDURE SUB21 SQLCODE;
      COMMIT WORK;