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 Windows-Programme und andere 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 xts725.mco Sprache: unbekannt

-- SQL Test Suite, V6.0, SQL Module xts725.mco
-- 59-byte ID
--
MODULE XTS725
LANGUAGE COBOL
AUTHORIZATION CTS1

DECLARE CLCURS  INSENSITIVE CURSOR
               FOR SELECT COL_NUM1, COL_CH1, COL_NUM2,COL_CH2
               FROM CL_STANDARD
               ORDER BY COL_NUM1 DESC

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

PROCEDURE SUB2 (SQLCODE, SQLSTATE);
      ROLLBACK WORK;

PROCEDURE SUB3 (SQLCODE, SQLSTATE);
    OPEN CLCURS;

PROCEDURE SUB4 (SQLCODE, SQLSTATE);
      INSERT INTO CL_STANDARD
                    VALUES(1005,'KEVIN',4005,'XIOS');

PROCEDURE SUB5 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      SELECT COL_NUM1,COL_CH1,COL_NUM2,COL_CH2
                    INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                    FROM CL_STANDARD WHERE COL_NUM1 = 1005;

PROCEDURE SUB6 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB7 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB8 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB9 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB10 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB11 (SQLCODE, SQLSTATE);
      CLOSE CLCURS;

PROCEDURE SUB13 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB14 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB15 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB16 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB17 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB18 (SQLCODE, SQLSTATE,
    :C_NUM1 NUMERIC (9),
    :C_CH1 CHAR(10),
    :C_NUM2 NUMERIC (9),
    :C_CH2 CHAR(10));
      FETCH CLCURS INTO :C_NUM1, :C_CH1, :C_NUM2, :C_CH2
                 ;

PROCEDURE SUB19 (SQLCODE, SQLSTATE);
      CLOSE CLCURS;

PROCEDURE SUB20 (SQLCODE, SQLSTATE);
      ROLLBACK WORK;

PROCEDURE SUB21 (SQLCODE, SQLSTATE);
      INSERT INTO CTS1.TESTREPORT
                      VALUES('7025','pass','MCO');

PROCEDURE SUB22 (SQLCODE, SQLSTATE);
      INSERT INTO CTS1.TESTREPORT
                      VALUES('7025','NOGO','MCO');

PROCEDURE SUB23 (SQLCODE, SQLSTATE);
      COMMIT WORK;