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 3 kB

Quelle dml028.mco Sprache: unbekannt

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

MODULE DML028
LANGUAGE COBOL
AUTHORIZATION HU

DECLARE X CURSOR
             FOR SELECT EMPNUM,HOURS
             FROM   WORKS
             ORDER  BY EMPNUM DESC,HOURS DESC
DECLARE Y CURSOR
             FOR SELECT EMPNUM,PNUM
             FROM   WORKS
             ORDER  BY EMPNUM DESC,PNUM DESC
DECLARE Z CURSOR
             FOR SELECT CITY
             FROM   STAFF
             WHERE  EMPNUM =  :EMPNO1
DECLARE A CURSOR
             FOR SELECT CITY
             FROM   PROJ
             WHERE  PNUM =  :PNO1
DECLARE B CURSOR
             FOR SELECT EMPNUM,PNUM
             FROM   WORKS
             ORDER  BY EMPNUM ASC,PNUM ASC
DECLARE D CURSOR
             FOR SELECT CITY
             FROM   STAFF
             WHERE  EMPNUM =  :EMPNO1
DECLARE E CURSOR
             FOR SELECT CITY
             FROM   PROJ
             WHERE  PNUM =  :PNO1

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

PROCEDURE SUB1 SQLCODE;
    OPEN X;

PROCEDURE SUB2 SQLCODE;
      CLOSE X;

PROCEDURE SUB4 SQLCODE
    :EMPNO1 CHAR(3)
    :HOURS1 NUMERIC (9);
      FETCH X INTO  :EMPNO1, :HOURS1;

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

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

PROCEDURE SUB7 SQLCODE;
      COMMIT WORK;

PROCEDURE SUB8 SQLCODE;
    OPEN Y;

PROCEDURE SUB9 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0127','pass','MCO');

PROCEDURE SUB10 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0127','fail','MCO');

PROCEDURE SUB11 SQLCODE;
      COMMIT WORK;

PROCEDURE SUB12 SQLCODE;
    OPEN B;

PROCEDURE SUB13 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0128','pass','MCO');

PROCEDURE SUB14 SQLCODE;
      INSERT INTO TESTREPORT
                    VALUES('0128','fail','MCO');

PROCEDURE SUB15 SQLCODE;
      COMMIT WORK;

PROCEDURE SUB16 SQLCODE
    :EMPNO1 CHAR(3)
    :HOURS1 NUMERIC (9);
      FETCH X INTO  :EMPNO1, :HOURS1;

PROCEDURE SUB17 SQLCODE
    :EMPNO1 CHAR(3)
    :PNO1 CHAR(3);
      FETCH Y INTO  :EMPNO1, :PNO1;

PROCEDURE SUB18 SQLCODE
    :EMPNO1 CHAR(3);
    OPEN Z;

PROCEDURE SUB19 SQLCODE
    :SCITY CHAR(15);
      FETCH Z INTO  :SCITY;

PROCEDURE SUB20 SQLCODE;
      CLOSE Z;

PROCEDURE SUB21 SQLCODE
    :PNO1 CHAR(3);
    OPEN A;

PROCEDURE SUB22 SQLCODE
    :PCITY CHAR(15);
      FETCH A INTO  :PCITY;

PROCEDURE SUB23 SQLCODE;
      CLOSE A;

PROCEDURE SUB24 SQLCODE
    :EMPNO1 CHAR(3)
    :PNO1 CHAR(3);
      FETCH B INTO  :EMPNO1, :PNO1;

PROCEDURE SUB25 SQLCODE
    :EMPNO1 CHAR(3);
    OPEN D;

PROCEDURE SUB26 SQLCODE
    :PNO1 CHAR(3);
    OPEN E;

PROCEDURE SUB27 SQLCODE
    :SCITY CHAR(15);
      FETCH D INTO  :SCITY;

PROCEDURE SUB28 SQLCODE
    :PCITY CHAR(15);
      FETCH E INTO  :PCITY;

PROCEDURE SUB29 SQLCODE;
      CLOSE D;

PROCEDURE SUB30 SQLCODE;
      CLOSE E;