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: IO.vdmpp Sprache: Unknown

Untersuchungsergebnis.mco Download desIsabelle {Isabelle[42] CS[118] Cobol[144]}zum Wurzelverzeichnis wechseln

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

MODULE SUNTAB2
LANGUAGE COBOL
AUTHORIZATION SUN

PROCEDURE SUB1 SQLCODE;
      DELETE FROM SIZ1_F;

PROCEDURE SUB2 SQLCODE;
      DELETE FROM SIZ1_P;

PROCEDURE SUB3 SQLCODE;
      DELETE FROM SIZ2_F1;

PROCEDURE SUB4 SQLCODE;
      DELETE FROM SIZ2_F2;

PROCEDURE SUB5 SQLCODE;
      DELETE FROM SIZ2_F3;

PROCEDURE SUB6 SQLCODE;
      DELETE FROM SIZ2_F4;

PROCEDURE SUB7 SQLCODE;
      DELETE FROM SIZ2_F5;

PROCEDURE SUB8 SQLCODE;
      DELETE FROM SIZ2_F6;

PROCEDURE SUB9 SQLCODE;
      DELETE FROM SIZ2_F7;

PROCEDURE SUB10 SQLCODE;
      DELETE FROM SIZ2_F8;

PROCEDURE SUB11 SQLCODE;
      DELETE FROM SIZ2_F9;

PROCEDURE SUB12 SQLCODE;
      DELETE FROM SIZ2_F10;

PROCEDURE SUB13 SQLCODE;
      DELETE FROM SIZ2_P;

PROCEDURE SUB14 SQLCODE;
      DELETE FROM SIZ3_F;

PROCEDURE SUB15 SQLCODE;
      DELETE FROM SIZ3_P1;

PROCEDURE SUB16 SQLCODE;
      DELETE FROM SIZ3_P2;

PROCEDURE SUB17 SQLCODE;
      DELETE FROM SIZ3_P3;

PROCEDURE SUB18 SQLCODE;
      DELETE FROM SIZ3_P4;

PROCEDURE SUB19 SQLCODE;
      DELETE FROM SIZ3_P5;

PROCEDURE SUB20 SQLCODE;
      DELETE FROM SIZ3_P6;

PROCEDURE SUB21 SQLCODE;
      DELETE FROM SIZ3_P7;

PROCEDURE SUB22 SQLCODE;
      DELETE FROM SIZ3_P8;

PROCEDURE SUB23 SQLCODE;
      DELETE FROM SIZ3_P9;

PROCEDURE SUB24 SQLCODE;
      DELETE FROM SIZ3_P10;

PROCEDURE SUB25 SQLCODE;
      INSERT INTO SIZ1_P VALUES
                    ('E1','TTT',1,'SSS',10,'RRR','HHH','YYY',20);

PROCEDURE SUB26 SQLCODE;
      INSERT INTO SIZ1_P VALUES
                    ('E1','TTS',1,'SSS',10,'RRR','HHH','YYY',21);

PROCEDURE SUB27 SQLCODE;
      INSERT INTO SIZ1_P VALUES
                    ('E2','TTT',1,'SSS',10,'RRR','HHH','YYY',22);

PROCEDURE SUB28 SQLCODE;
      INSERT INTO SIZ1_P VALUES
                    ('E3','TTT',1,'SSS',11,'RRR','HHH','YYY',23);

PROCEDURE SUB29 SQLCODE;
      INSERT INTO SIZ1_P VALUES
                    ('E4','TTT',2,'SSS',10,'RRR','HHH','YYY',24);

PROCEDURE SUB30 SQLCODE;
      INSERT INTO SIZ1_P VALUES
                    ('E1','TTS',3,'SSS',10,'RRR','HHH','YYY',25);

PROCEDURE SUB31 SQLCODE;
      INSERT INTO SIZ1_P VALUES
                    ('E2','TTT',1,'SSS',10,'TRR','HHH','YYY',26);

PROCEDURE SUB32 SQLCODE;
      INSERT INTO SIZ1_P VALUES
                    ('E3','TTT',4,'SSS',11,'RRR','HHH','YYY',27);

PROCEDURE SUB33 SQLCODE;
      INSERT INTO SIZ1_F VALUES
                    ('E1','TTT',1,'SSS',10,'RRR','YYY',90,20);

PROCEDURE SUB34 SQLCODE;
      INSERT INTO SIZ1_F VALUES
                    ('E1','TTS',1,'SSS',10,'RRR','YYY',91,20);

PROCEDURE SUB35 SQLCODE;
      INSERT INTO SIZ1_F VALUES
                    ('E2','TTT',1,'SSS',10,'RRR','YYY',92,20);

PROCEDURE SUB36 SQLCODE;
      INSERT INTO SIZ1_F VALUES
                    ('E3','TTT',1,'SSS',11,'RRR','YYY',93,20);

PROCEDURE SUB37 SQLCODE;
      INSERT INTO SIZ1_F VALUES
                    ('E4','TTT',2,'SSS',10,'RRR','YYY',94,20);

PROCEDURE SUB38 SQLCODE;
      INSERT INTO SIZ1_F VALUES
                    ('E1','TTS',3,'SSS',10,'RRR','YYY',95,20);

PROCEDURE SUB39 SQLCODE;
      INSERT INTO SIZ1_F VALUES
                    ('E2','TTT',1,'SSS',10,'TRR','YYY',96,20);

PROCEDURE SUB40 SQLCODE;
      INSERT INTO SIZ1_F VALUES
                    ('E2','TTT',1,'SSS',10,'TRR','YYY',97,20);

PROCEDURE SUB41 SQLCODE;
      INSERT INTO SIZ2_P VALUES
                    (' A',' B',1,' C',2,' D',' E',3,4,5,'TTT');

PROCEDURE SUB42 SQLCODE;
      INSERT INTO SIZ2_P VALUES
                    (' B',' C',2,' D',3,' E',' F',4,5,6,'TTT');

PROCEDURE SUB43 SQLCODE;
      INSERT INTO SIZ2_P VALUES
                    (' C',' D',3,' E',4,' F',' G',5,6,7,'TTT');

PROCEDURE SUB44 SQLCODE;
      INSERT INTO SIZ2_P VALUES
                    (' D',' E',4,' F',5,' G',' H',6,7,8,'TTT');

PROCEDURE SUB45 SQLCODE;
      INSERT INTO SIZ2_F1 VALUES (' A','AAA');

PROCEDURE SUB46 SQLCODE;
      INSERT INTO SIZ2_F1 VALUES (' C','AAB');

PROCEDURE SUB47 SQLCODE;
      INSERT INTO SIZ2_F1 VALUES (' C','AAC');

PROCEDURE SUB48 SQLCODE;
      INSERT INTO SIZ2_F1 VALUES (' D','AAD');

PROCEDURE SUB49 SQLCODE;
      INSERT INTO SIZ2_F2 VALUES (' E','BBA');

PROCEDURE SUB50 SQLCODE;
      INSERT INTO SIZ2_F2 VALUES (' E','BBB');

PROCEDURE SUB51 SQLCODE;
      INSERT INTO SIZ2_F2 VALUES (' C','BBC');

PROCEDURE SUB52 SQLCODE;
      INSERT INTO SIZ2_F2 VALUES (' D','BBD');

PROCEDURE SUB53 SQLCODE;
      INSERT INTO SIZ2_F3 VALUES (1,'CCA');

PROCEDURE SUB54 SQLCODE;
      INSERT INTO SIZ2_F3 VALUES (1,'CCB');

PROCEDURE SUB55 SQLCODE;
      INSERT INTO SIZ2_F3 VALUES (2,'CCC');

PROCEDURE SUB56 SQLCODE;
      INSERT INTO SIZ2_F3 VALUES (3,'CCD');

PROCEDURE SUB57 SQLCODE;
      INSERT INTO SIZ2_F4 VALUES (' E','DDA');

PROCEDURE SUB58 SQLCODE;
      INSERT INTO SIZ2_F4 VALUES (' F','DDB');

PROCEDURE SUB59 SQLCODE;
      INSERT INTO SIZ2_F4 VALUES (' C','DDC');

PROCEDURE SUB60 SQLCODE;
      INSERT INTO SIZ2_F4 VALUES (' D','DDD');

PROCEDURE SUB61 SQLCODE;
      INSERT INTO SIZ2_F5 VALUES (4,'EEA');

PROCEDURE SUB62 SQLCODE;
      INSERT INTO SIZ2_F5 VALUES (4,'EEB');

PROCEDURE SUB63 SQLCODE;
      INSERT INTO SIZ2_F5 VALUES (2,'EEC');

PROCEDURE SUB64 SQLCODE;
      INSERT INTO SIZ2_F5 VALUES (3,'EED');

PROCEDURE SUB65 SQLCODE;
      INSERT INTO SIZ2_F6 VALUES (' E','FFA');

PROCEDURE SUB66 SQLCODE;
      INSERT INTO SIZ2_F6 VALUES (' F','FFB');

PROCEDURE SUB67 SQLCODE;
      INSERT INTO SIZ2_F6 VALUES (' G','FFC');

PROCEDURE SUB68 SQLCODE;
      INSERT INTO SIZ2_F6 VALUES (' D','FFD');

PROCEDURE SUB69 SQLCODE;
      INSERT INTO SIZ2_F7 VALUES (' H','GGA');

PROCEDURE SUB70 SQLCODE;
      INSERT INTO SIZ2_F7 VALUES (' F','GGB');

PROCEDURE SUB71 SQLCODE;
      INSERT INTO SIZ2_F7 VALUES (' G','GGC');

PROCEDURE SUB72 SQLCODE;
      INSERT INTO SIZ2_F7 VALUES (' H','GGD');

PROCEDURE SUB73 SQLCODE;
      INSERT INTO SIZ2_F8 VALUES (4,'HHA');

PROCEDURE SUB74 SQLCODE;
      INSERT INTO SIZ2_F8 VALUES (4,'HHB');

PROCEDURE SUB75 SQLCODE;
      INSERT INTO SIZ2_F8 VALUES (5,'HHC');

PROCEDURE SUB76 SQLCODE;
      INSERT INTO SIZ2_F8 VALUES (3,'HHD');

PROCEDURE SUB77 SQLCODE;
      INSERT INTO SIZ2_F9 VALUES (4,'JJA');

PROCEDURE SUB78 SQLCODE;
      INSERT INTO SIZ2_F9 VALUES (4,'JJB');

PROCEDURE SUB79 SQLCODE;
      INSERT INTO SIZ2_F9 VALUES (6,'JJC');

PROCEDURE SUB80 SQLCODE;
      INSERT INTO SIZ2_F9 VALUES (7,'JJD');

PROCEDURE SUB81 SQLCODE;
      INSERT INTO SIZ2_F10 VALUES (5,'KKA');

PROCEDURE SUB82 SQLCODE;
      INSERT INTO SIZ2_F10 VALUES (5,'KKB');

PROCEDURE SUB83 SQLCODE;
      INSERT INTO SIZ2_F10 VALUES (7,'KKC');

PROCEDURE SUB84 SQLCODE;
      INSERT INTO SIZ2_F10 VALUES (8,'KKD');

PROCEDURE SUB85 SQLCODE;
      INSERT INTO SIZ3_P1 VALUES (' A','AAA');

PROCEDURE SUB86 SQLCODE;
      INSERT INTO SIZ3_P1 VALUES (' B','AAB');

PROCEDURE SUB87 SQLCODE;
      INSERT INTO SIZ3_P1 VALUES (' C','AAC');

PROCEDURE SUB88 SQLCODE;
      INSERT INTO SIZ3_P1 VALUES (' D','AAD');

PROCEDURE SUB89 SQLCODE;
      INSERT INTO SIZ3_P2 VALUES (' B','BBA');

PROCEDURE SUB90 SQLCODE;
      INSERT INTO SIZ3_P2 VALUES (' C','BBB');

PROCEDURE SUB91 SQLCODE;
      INSERT INTO SIZ3_P2 VALUES (' D','BBC');

PROCEDURE SUB92 SQLCODE;
      INSERT INTO SIZ3_P2 VALUES (' E','BBD');

PROCEDURE SUB93 SQLCODE;
      INSERT INTO SIZ3_P3 VALUES (1,'CCA');

PROCEDURE SUB94 SQLCODE;
      INSERT INTO SIZ3_P3 VALUES (2,'CCB');

PROCEDURE SUB95 SQLCODE;
      INSERT INTO SIZ3_P3 VALUES (3,'CCC');

PROCEDURE SUB96 SQLCODE;
      INSERT INTO SIZ3_P3 VALUES (4,'CCD');

PROCEDURE SUB97 SQLCODE;
      INSERT INTO SIZ3_P4 VALUES (' E','DDA');

PROCEDURE SUB98 SQLCODE;
      INSERT INTO SIZ3_P4 VALUES (' F','DDB');

PROCEDURE SUB99 SQLCODE;
      INSERT INTO SIZ3_P4 VALUES (' C','DDC');

PROCEDURE SUB100 SQLCODE;
      INSERT INTO SIZ3_P4 VALUES (' D','DDD');

PROCEDURE SUB101 SQLCODE;
      INSERT INTO SIZ3_P5 VALUES (4,'EEA');

PROCEDURE SUB102 SQLCODE;
      INSERT INTO SIZ3_P5 VALUES (5,'EEB');

PROCEDURE SUB103 SQLCODE;
      INSERT INTO SIZ3_P5 VALUES (2,'EEC');

PROCEDURE SUB104 SQLCODE;
      INSERT INTO SIZ3_P5 VALUES (3,'EED');

PROCEDURE SUB105 SQLCODE;
      INSERT INTO SIZ3_P6 VALUES (' E','FFA');

PROCEDURE SUB106 SQLCODE;
      INSERT INTO SIZ3_P6 VALUES (' F','FFB');

PROCEDURE SUB107 SQLCODE;
      INSERT INTO SIZ3_P6 VALUES (' G','FFC');

PROCEDURE SUB108 SQLCODE;
      INSERT INTO SIZ3_P6 VALUES (' D','FFD');

PROCEDURE SUB109 SQLCODE;
      INSERT INTO SIZ3_P7 VALUES (' H','GGA');

PROCEDURE SUB110 SQLCODE;
      INSERT INTO SIZ3_P7 VALUES (' F','GGB');

PROCEDURE SUB111 SQLCODE;
      INSERT INTO SIZ3_P7 VALUES (' G','GGC');

PROCEDURE SUB112 SQLCODE;
      INSERT INTO SIZ3_P7 VALUES (' E','GGD');

PROCEDURE SUB113 SQLCODE;
      INSERT INTO SIZ3_P8 VALUES (4,'HHA');

PROCEDURE SUB114 SQLCODE;
      INSERT INTO SIZ3_P8 VALUES (6,'HHB');

PROCEDURE SUB115 SQLCODE;
      INSERT INTO SIZ3_P8 VALUES (5,'HHC');

PROCEDURE SUB116 SQLCODE;
      INSERT INTO SIZ3_P8 VALUES (3,'HHD');

PROCEDURE SUB117 SQLCODE;
      INSERT INTO SIZ3_P9 VALUES (4,'JJA');

PROCEDURE SUB118 SQLCODE;
      INSERT INTO SIZ3_P9 VALUES (5,'JJB');

PROCEDURE SUB119 SQLCODE;
      INSERT INTO SIZ3_P9 VALUES (6,'JJC');

PROCEDURE SUB120 SQLCODE;
      INSERT INTO SIZ3_P9 VALUES (7,'JJD');

PROCEDURE SUB121 SQLCODE;
      INSERT INTO SIZ3_P10 VALUES (5,'KKA');

PROCEDURE SUB122 SQLCODE;
      INSERT INTO SIZ3_P10 VALUES (6,'KKB');

PROCEDURE SUB123 SQLCODE;
      INSERT INTO SIZ3_P10 VALUES (7,'KKC');

PROCEDURE SUB124 SQLCODE;
      INSERT INTO SIZ3_P10 VALUES (8,'KKD');

PROCEDURE SUB125 SQLCODE;
      INSERT INTO SIZ3_F VALUES
                    (' A',' B',1,' C',2,' D',' E',3,4,5,'TTT');

PROCEDURE SUB126 SQLCODE;
      INSERT INTO SIZ3_F VALUES
                    (' B',' C',2,' D',3,' E',' F',4,5,6,'TTT');

PROCEDURE SUB127 SQLCODE;
      INSERT INTO SIZ3_F VALUES
                    (' C',' D',3,' E',4,' F',' G',5,6,7,'TTT');

PROCEDURE SUB128 SQLCODE;
      INSERT INTO SIZ3_F VALUES
                    (' D',' E',4,' F',5,' G',' H',6,7,8,'TTT');

PROCEDURE SUB129 SQLCODE;
      INSERT INTO SIZ3_F VALUES
                    (' B',' B',1,' C',2,' D',' E',3,4,5,'TTT');

PROCEDURE SUB130 SQLCODE;
      INSERT INTO SIZ3_F VALUES
                    (' C',' C',2,' D',3,' E',' F',4,5,6,'TTT');

PROCEDURE SUB131 SQLCODE;
      INSERT INTO SIZ3_F VALUES
                    (' C',' D',3,' E',4,' F',' G',5,6,7,'TTT');

PROCEDURE SUB132 SQLCODE;
      INSERT INTO SIZ3_F VALUES
                    (' D',' E',4,' F',5,' G',' H',6,7,8,'TTT');

PROCEDURE SUB133 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ1_P;

PROCEDURE SUB134 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ1_F;

PROCEDURE SUB135 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_P;

PROCEDURE SUB136 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_F1;

PROCEDURE SUB137 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_F2;

PROCEDURE SUB138 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_F3;

PROCEDURE SUB139 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_F4;

PROCEDURE SUB140 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_F5;

PROCEDURE SUB141 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_F6;

PROCEDURE SUB142 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_F7;

PROCEDURE SUB143 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_F8;

PROCEDURE SUB144 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_F9;

PROCEDURE SUB145 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ2_F10
                 ;

PROCEDURE SUB146 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_P1;

PROCEDURE SUB147 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_P2;

PROCEDURE SUB148 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_P3;

PROCEDURE SUB149 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_P4;

PROCEDURE SUB150 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_P5;

PROCEDURE SUB151 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_P6;

PROCEDURE SUB152 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_P7;

PROCEDURE SUB153 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_P8;

PROCEDURE SUB154 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_P9;

PROCEDURE SUB155 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_P10
                 ;

PROCEDURE SUB156 SQLCODE
    :COUNT1 NUMERIC (9);
      SELECT COUNT(*) INTO  :COUNT1 FROM SIZ3_F;

PROCEDURE SUB157 SQLCODE;
      COMMIT WORK;