Quelle xts729.cob Sprache: Cobol

       IDENTIFICATION DIVISION.
       PROGRAM-ID.  XTS729.
       ENVIRONMENT DIVISION.
       CONFIGURATION SECTION.
       SOURCE-COMPUTER.  xyz.
       OBJECT-COMPUTER.  xyz.
       DATA DIVISION.
       WORKING-STORAGE SECTION.

      * EMBEDDED COBOL (file "XTS729.PCO")

      *Copyright 1995 National Computing Centre Limited
      *and Computer Logic R&D S.A
      *on behalf of the CTS5 SQL2 Project.
      *All rights reserved.
      *The CTS5 SQL2 Project is sponsored by the European Community.
      *
      *The National Computing Centre Limited and Computer Logic R&D
      *have given permission to NIST to distribute this program
      *over the World Wide Web in order to promote SQL standards.
      *DISCLAIMER:
      *This program was reviewed by employees of NIST for
      *conformance to the SQL standards.
      *NIST assumes no responsibility for any party's use of
      *this program.

      ****************************************************************
      *
      *                 COMMENT SECTION
      *
      * SQL VALIDATION TEST SUITE V6.0
      *
      * XTS729.PCO
      * WRITTEN BY: Manolis Megaloikonomou
      * TRANSLATED AUTOMATICALLY FROM EMBEDDED C BY CHRIS SCHANZLE
      *
      * Column name with 19 and 128 characters - regular.
      *
      * REFERENCES
      *   11.4 -- <column definition>
      *    5.4 -- <Names and identifiers>
      *    5.4 GR.4
      *    5.4 SR.3
      *    5.2 -- <token> and <separator>
      *    5.2 SR.8
      *    5.2 SR.10
      *    5.2 SR.11
      *    5.2 LR.2a -- Raised. Entry SQL restriction which
      *              restricted the length of a <regular identifier>
      *              up to 18 <character representation>s.
      *   21.2.9 -- COLUMNS view.
      *   F#1    -- Dynamic SQL.
      *   F#2    -- Basic information schema.
      *   F#3    -- Basic schema manipulation.
      *   F#39   -- Long identifiers.
      *
      * DATE LAST ALTERED  14/12/95 CTS5 Hand-over Test
      *
      * Cleanups and fixes by V. Kogakis 05/12/95:
      *        Include Files
      *        Define NOSUBCLASS/CHCKOK at test beginning
      *        Define cal variable
      *        Fix Syntax errors
      *        Add ROLLBACK after AUTHID
      *        print timestamp
      *        delete multiple SQLCODE and SQLSTATE initialisation
      *        change string initialisation
      *        Clean-up database at the end of the test
      *
      * QA Status: Full FC
      *
      * Revised by DWF 1996-02-01
      *   Fixed SDL transactions
      *   Removed untranslatable field widths in printfs
      *   Fixed char string lengths
      *   Fixed opening & closing of wrong cursor
      *   Added whitespace where required in table definition
      *   Make variable names 6 chars
      ****************************************************************

           EXEC SQL BEGIN DECLARE SECTION END-EXEC
       01  SQLCODE PIC S9(9) COMP.
       01  SQLSTATE PIC  X(5).
       01  uid PIC  X(18).
       01  uidx PIC  X(18).
       01  aa PIC  X(149).
       01  bb PIC  X(10).
       01  cc PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  dd PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  ee PIC  X(9).
       01  sqlstm PIC  X(190).
             EXEC SQL END DECLARE SECTION END-EXEC
       01  norm1 PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  norm2 PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  ALPNUM-TABLE VALUE IS
               "01234ABCDEFGH56789IJKLMNOPQRSTUVWXYZ".
           05  ALPNUM PIC X OCCURS 36 TIMES.
       01  NORMSQ.
           05  NORMSQX PIC X OCCURS 5 TIMES.
       01  errcnt PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
      *date_time declaration
       01  TO-DAY PIC 9(6).
       01  THE-TIME PIC 9(8).
       01  flag PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
       01  int3 PIC S9(4) DISPLAY SIGN LEADING SEPARATE.
       01  str1 PIC  X(128).
       01  str2 PIC  X(128).
       01  str3 PIC  X(128).
       01  str4 PIC  X(128).

       01  SQL-COD PIC S9(9) DISPLAY SIGN LEADING SEPARATE.

       PROCEDURE DIVISION.
       P0.

             MOVE "CTS1 " TO uid
             CALL "AUTHID" USING uid
             MOVE "not logged in, not" TO uidx
             EXEC SQL SELECT USER INTO :uidx FROM CTS1.ECCO END-EXEC
             MOVE SQLCODE TO SQL-COD
             EXEC SQL ROLLBACK WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
             if (uid  NOT  =   uidx) then
               DISPLAY "ERROR: User ", uid, " expected. User ", uidx, "
      -    " connected"
            STOP RUN
             END-IF
             MOVE 0 TO errcnt

             DISPLAY
           "SQL Test Suite, V6.0, Embedded COBOL, xts729.pco"
             DISPLAY
           "59-byte ID"
             DISPLAY "TEd Version #"
      *date_time print
           ACCEPT TO-DAY FROM DATE
           ACCEPT THE-TIME FROM TIME
           DISPLAY "Date run YYMMDD: " TO-DAY " at hhmmssff: " THE-TIME

      ******************** BEGIN TEST7029 *******************
             MOVE 1 TO flag
             DISPLAY " TEST7029 "
             DISPLAY " Column name with 19 and 128 characters -
      -    " regular."
             DISPLAY "References:"
             DISPLAY " 11.4 -- "
             DISPLAY " 5.4 -- "
             DISPLAY " 5.4 GR.4"
             DISPLAY " 5.4 SR.3"
             DISPLAY " 5.2 -- and "
             DISPLAY " 5.2 SR.8"
             DISPLAY " 5.2 SR.10"
             DISPLAY " 5.2 SR.11"
             DISPLAY " 5.2 LR.2a -- Raised. Entry SQL restriction
      -    " which"
             DISPLAY " restricted the length of a
      -    " identifier>"
             DISPLAY " up to 18
      -    " representation>s."
             DISPLAY " 21.2.9 -- COLUMNS view."
             DISPLAY " F#1 -- Dynamic SQL."
             DISPLAY " F#2 -- Basic information schema."
             DISPLAY " F#3 -- Basic schema manipulation."
             DISPLAY " F#39 -- Long identifiers."
             DISPLAY " - - - - - - - - - - - - - - - - - - -"

      *Initialise error reporting variables
             COMPUTE SQLCODE = -1
             MOVE "xxxxx" TO SQLSTATE

      *Set up long strings for comparison statements
             MOVE "COLUMNOFCHARACTERDATATYPE123456789012345
      -      "6789012345678901234567890123456789012345
      -      "678901234567890123456789012345678901234567890123" TO
             str1

             MOVE "columnofcharacterdatatype123456789012345
      -       "6789012345678901234567890123456789012345
      -       "67890123456789012345678901234567890123456789012b" TO
             str2

             MOVE "cOlUmNoFNUMERIC1234567890123456789012345
      -      "6789012345678901234567890123456789012345
      -      "6789012345678901234567890123456789012345678901_0" TO
             str3

             MOVE "CoLuMnOfNUMERIC1234567890123456789012345
      -      "6789012345678901234567890123456789012345
      -      "6789012345678901234567890123456789012345678901_1" TO
             str4

      *Create table
      *ensure all columns names are of length 19
      *the first column is to upper case
      *the second column is to be lower case
      *the third and fourth cols are to combine upper & lower cases &
             DISPLAY "CREATE TABLE TESTA6439"
             DISPLAY "(COLUMNOFCHARACTERSA CHARACTER(10),"
             DISPLAY " columnofcharactersb CHARACTER(10),"
             DISPLAY " cOlUmNoFNUMERICss_0 NUMERIC(5),"
             DISPLAY " cOlUmNoFNUMERICss_1 NUMERIC(5));"
             EXEC SQL CREATE TABLE TESTA6439
               (COLUMNOFCHARACTERSA CHARACTER(10),
               columnofcharactersb CHARACTER(10),
               cOlUmNoFNUMERICss_0 NUMERIC(5),
               cOlUmNoFNUMERICss_1 NUMERIC(5)) END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "COMMIT WORK;"
             EXEC SQL COMMIT WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *The NIST programming requirement for a maximum line length can
      *be met in this test which checks for a column identifier of 128

      *Create second table
      *Ensure col names are a maximum width of 128 characters
             DISPLAY "CREATE TABLE TESTB6439"
             DISPLAY
              "(COLUMNOFCHARACTERDATATYPE12345678901234567890
      -       "123456789012"
             DISPLAY
              "3456789012345678901234567890123456789012345678
      -       "901234567890"
             DISPLAY "1234567890123 CHARACTER(3),"
             DISPLAY
              "columnofcharacterdatatype12345678901234567890
      -      "1234567890123"
             DISPLAY
              "456789012345678901234567890123456789012345678
      -      "9012345678901"
             DISPLAY "23456789012b CHARACTER(3),"
             DISPLAY
              "cOlUmNoFNUMERIC123456789012345678901234567890
      -      "1234567890123"
             DISPLAY
              "4567890123456789012345678901234567890
      -      "123456789012345678901"
             DISPLAY "2345678901_0 NUMERIC(5),"
             DISPLAY
              "CoLuMnOfNUMERIC12345678901234567890
      -      "12345678901234567890123"
             DISPLAY
              "4567890123456789012345678901234567890
      -      "123456789012345678901"
             DISPLAY "2345678901_1 NUMERIC(5));"
             EXEC SQL CREATE TABLE TESTB6439
              (COLUMNOFCHARACTERDATATYPE12345678901234567890
              123456789012345678901234567890123456789012345678
              90123456789012345678901234567890123 CHARACTER(3),
              columnofcharacterdatatype12345678901234567890123
              456789012345678901234567890123456789012345678901
              2345678901234567890123456789012b CHARACTER(3),
              cOlUmNoFNUMERIC12345678901234567890123456789012345
              67890123456789012345678901234567890123456789012345
              67890123456789012345678901_0 NUMERIC(5),
              CoLuMnOfNUMERIC123456789012345678901234567890123456
              789012345678901234567890123456789012345678901234567
              890123456789012345678901_1 NUMERIC(5)) END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "COMMIT WORK;"
             EXEC SQL COMMIT WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "INSERT INTO CTS1.TESTA6439"
             DISPLAY "VALUES('ABCD','DCBA',1,9999);"
             EXEC SQL INSERT INTO CTS1.TESTA6439
               VALUES('ABCD','DCBA',1,9999) END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *Initialise host variables
             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE "xxxxxxxxxx" TO bb
             MOVE 99 TO cc
             MOVE 99 TO dd

             DISPLAY "SELECT COLUMNOFCHARACTERSA, columnofcharactersb, "
             DISPLAY "cOlUmNoFNUMERICss_0,"
             DISPLAY "cOlUmNoFNUMERICss_1 INTO :aa, :bb, :cc, :dd FROM
      -    " CTS1.TESTA6439;"
             EXEC SQL SELECT COLUMNOFCHARACTERSA, columnofcharactersb,
               cOlUmNoFNUMERICss_0, cOlUmNoFNUMERICss_1
               INTO :aa, :bb, :cc, :dd FROM CTS1.TESTA6439 END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "COLUMNOFCHARACTERSA should be ABCD; its value is
      -    " ", aa
             DISPLAY "columnofcharactersb should be DCBA; its value is
      -    " ", bb
             DISPLAY "cOlUmNoFNUMERICss_0 should be 1; its value is
      -    " ", cc
             DISPLAY "cOlUmNoFNUMERICss_1 should be 9999; its value is
      -    " ", dd
             if (aa  NOT  =   "ABCD"  OR  bb  NOT  =   "DCBA" ) then
               MOVE 0 TO flag
             END-IF
             if (cc  NOT =  1  OR  dd  NOT =  9999) then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

      *Ensure columns in the second table can be referenced correctly
             DISPLAY "INSERT INTO CTS1.TESTB6439"
             DISPLAY "VALUES('AA','BB',1,2);"
             EXEC SQL INSERT INTO CTS1.TESTB6439
               VALUES('AA','BB',1,2) END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "INSERT INTO CTS1.TESTB6439"
             DISPLAY "VALUES('CC','DD',3,4);"
             EXEC SQL INSERT INTO CTS1.TESTB6439
               VALUES('CC','DD',3,4) END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "INSERT INTO CTS1.TESTB6439"
             DISPLAY "VALUES('EE','FF',5,6);"
             EXEC SQL INSERT INTO CTS1.TESTB6439
               VALUES('EE','FF',5,6) END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "INSERT INTO CTS1.TESTB6439"
             DISPLAY "VALUES('GG','HH',7,8);"
             EXEC SQL INSERT INTO CTS1.TESTB6439
               VALUES('GG','HH',7,8) END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "INSERT INTO CTS1.TESTB6439"
             DISPLAY "VALUES('II','KK',9,0);"
             EXEC SQL INSERT INTO CTS1.TESTB6439
               VALUES('II','KK',9,0) END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *Ensure the values stored in the second table can be retrieved c

             DISPLAY "DECLARE a CURSOR"
             DISPLAY "FOR SELECT * FROM CTS1.TESTB6439 ORDER BY
      -    " cOlUmNoFNUMERIC12345"
             DISPLAY
              "678901234567890123456789012345678901234567890
      -       "1234567890123"
             DISPLAY
             "456789012345678901234567890123456789012345678901_0;"
             EXEC SQL DECLARE a CURSOR
               FOR SELECT * FROM CTS1.TESTB6439
               ORDER BY
                cOlUmNoFNUMERIC123456789012345678901234567890
                123456789012345678901234567890123456789012345
                678901234567890123456789012345678901_0 END-EXEC

             DISPLAY "OPEN a;"
             EXEC SQL OPEN a END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *Re-initialise host variables
             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE "xxxxxxxxxx" TO bb
             MOVE 99 TO cc
             MOVE 99 TO dd

      *Check first value fetched
             DISPLAY "FETCH a INTO :aa, :bb, :cc, :dd;"
             EXEC SQL FETCH a INTO :aa, :bb, :cc, :dd END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "COLUMNOFCHARACTERSA should be AA; its value is ",
             aa
             DISPLAY "columnofcharactersb should be BB; its value is ",
             bb
             DISPLAY "cOlUmNoFNUMERICss_0 should be 1; its value is ",
             cc
             DISPLAY "cOlUmNoFNUMERICss_1 should be 2; its value is ",
             dd
             if (aa  NOT  =   "AA"  OR  bb  NOT  =   "BB" ) then
               MOVE 0 TO flag
             END-IF
             if (cc  NOT =  1  OR  dd  NOT =  2) then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

      *Re-initialise host variables
             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE "xxxxxxxxxx" TO bb
             MOVE 99 TO cc
             MOVE 99 TO dd

      *Check second value fetched
             DISPLAY "FETCH a INTO :aa, :bb, :cc, :dd;"
             EXEC SQL FETCH a INTO :aa, :bb, :cc, :dd END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "COLUMNOFCHARACTERSA should be CC; its value is ",
             aa
             DISPLAY "columnofcharactersb should be DD; its value is ",
             bb
             DISPLAY "cOlUmNoFNUMERICss_0 should be 3; its value is ",
             cc
             DISPLAY "cOlUmNoFNUMERICss_1 should be 4; its value is ",
             dd
             if (aa  NOT  =   "CC"  OR  bb  NOT  =   "DD" ) then
               MOVE 0 TO flag
             END-IF
             if (cc  NOT =  3  OR  dd  NOT =  4) then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

      *Re-initialise host variables
             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE "xxxxxxxxxx" TO bb
             MOVE 99 TO cc
             MOVE 99 TO dd

      *Check third value fetched
             DISPLAY "FETCH a INTO :aa, :bb, :cc, :dd;"
             EXEC SQL FETCH a INTO :aa, :bb, :cc, :dd END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "COLUMNOFCHARACTERSA should be EE; its value is ",
             aa
             DISPLAY "columnofcharactersb should be FF; its value is ",
             bb
             DISPLAY "cOlUmNoFNUMERICss_0 should be 5; its value is ",
             cc
             DISPLAY "cOlUmNoFNUMERICss_1 should be 6; its value is ",
             dd
             if (aa  NOT  =   "EE"  OR  bb  NOT  =   "FF" ) then
               MOVE 0 TO flag
             END-IF
             if (cc  NOT =  5  OR  dd  NOT =  6) then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

      *Re-initialise host variables
             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE "xxxxxxxxxx" TO bb
             MOVE 99 TO cc
             MOVE 99 TO dd

      *Check fourth value fetched
             DISPLAY "FETCH a INTO :aa, :bb, :cc, :dd;"
             EXEC SQL FETCH a INTO :aa, :bb, :cc, :dd END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "COLUMNOFCHARACTERSA should be GG; its value is ",
             aa
             DISPLAY "columnofcharactersb should be HH; its value is ",
             bb
             DISPLAY "cOlUmNoFNUMERICss_0 should be 7; its value is ",
             cc
             DISPLAY "cOlUmNoFNUMERICss_1 should be 8; its value is ",
             dd
             if (aa  NOT  =   "GG"  OR  bb  NOT  =   "HH" ) then
               MOVE 0 TO flag
             END-IF
             if (cc  NOT =  7  OR  dd  NOT =  8) then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

      *Re-initialise host variables
             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE "xxxxxxxxxx" TO bb
             MOVE 99 TO cc
             MOVE 99 TO dd

      *Check fifth value fetched
             DISPLAY "FETCH a INTO :aa, :bb, :cc, :dd;"
             EXEC SQL FETCH a INTO :aa, :bb, :cc, :dd END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "COLUMNOFCHARACTERSA should be II; its value is ",
             aa
             DISPLAY "columnofcharactersb should be KK; its value is ",
             bb
             DISPLAY "cOlUmNoFNUMERICss_0 should be 9; its value is ",
             cc
             DISPLAY "cOlUmNoFNUMERICss_1 should be 0; its value is ",
             dd
             if (aa  NOT  =   "II"  OR  bb  NOT  =   "KK" ) then
               MOVE 0 TO flag
             END-IF
             if (cc  NOT =  9  OR  dd  NOT =  0) then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

             DISPLAY "CLOSE a;"
             EXEC SQL CLOSE a END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *check columns are referenced correctly in the information schem
             DISPLAY "DECLARE b CURSOR"
             DISPLAY "FOR SELECT COLUMN_NAME, ORDINAL_POSITION FROM "
             DISPLAY "INFORMATION_SCHEMA.COLUMNS"
             DISPLAY "WHERE TABLE_SCHEMA = 'CTS1' AND TABLE_NAME =
      -    " 'TESTB6439';"
             EXEC SQL DECLARE b CURSOR
               FOR SELECT  COLUMN_NAME, ORDINAL_POSITION
               FROM INFORMATION_SCHEMA.COLUMNS
               WHERE TABLE_SCHEMA = 'CTS1' AND TABLE_NAME = 'TESTB6439'
               ORDER BY ORDINAL_POSITION END-EXEC

             DISPLAY "OPEN b;"
             EXEC SQL OPEN b END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *Re-initialise host variables
             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE 99 TO cc

             DISPLAY "FETCH b INTO :aa, :cc;"
             EXEC SQL FETCH b INTO :aa, :cc END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "aa should be:"
             DISPLAY
              "COLUMNOFCHARACTERDATATYPE12345678901234567890
      -       "1234567890123456789"
             DISPLAY
              "012345678901234567890123456789012345678901234
      -       "5678901234567890123"
             DISPLAY "its value is:"
             PERFORM P50
             DISPLAY  " "
             PERFORM P49
             DISPLAY  " "
             DISPLAY "cc should be 1; its value is ", cc
             if (aa  NOT  =   str1  OR  cc  NOT =  1) then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE 99 TO cc

             DISPLAY "FETCH b INTO :aa, :cc;"
             EXEC SQL FETCH b INTO :aa, :cc END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "aa should be:"
             DISPLAY
              "COLUMNOFCHARACTERDATATYPE12345678901234567890
      -       "1234567890123456789"
             DISPLAY
              "0123456789012345678901234567890123456789012345
      -       "67890123456789012B"
             DISPLAY "its value is:"
             PERFORM P48
             DISPLAY  " "
             PERFORM P47
             DISPLAY  " "
             DISPLAY "cc should be 2; its value is ", cc
             if (aa  NOT  =   str2  OR  cc  NOT =  2) then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE 99 TO cc

             DISPLAY "FETCH b INTO :aa, :cc;"
             EXEC SQL FETCH b INTO :aa, :cc END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "aa should be:"
             DISPLAY
              "COLUMNOFNUMERIC123456789012345678901234567890
      -       "1234567890123456789"
             DISPLAY
              "0123456789012345678901234567890123456789012345
      -       "6789012345678901_0"
             DISPLAY "its value is:"
             PERFORM P46
             DISPLAY  " "
             PERFORM P45
             DISPLAY  " "
             DISPLAY "cc should be 3; its value is ", cc
             if (aa  NOT  =   str3  OR  cc  NOT =  3) then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE 99 TO cc

             DISPLAY "FETCH b INTO :aa, :cc;"
             EXEC SQL FETCH b INTO :aa, :cc END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "aa should be:"
             DISPLAY
              "COLUMNOFNUMERIC123456789012345678901234567890
      -       "1234567890123456789"
             DISPLAY
              "01234567890123456789012345678901234567890123456
      -       "789012345678901_1"
             DISPLAY "its value is:"
             PERFORM P44
             DISPLAY  " "
             PERFORM P43
             DISPLAY  " "
             DISPLAY "cc should be 4; its value is ", cc
             if (aa  NOT  =   str4  OR  cc  NOT =  4) then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

             DISPLAY "CLOSE b;"
             EXEC SQL CLOSE b END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "COMMIT WORK;"
             EXEC SQL COMMIT WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *Create third table
      *dynamically create a table containing columns of length 19 and

      *set up the long string for the host variable :sqlstm
             MOVE "CREATE TABLE TESTC6439 (COLUMNOFCHARACTE
      -       "RSA CHAR(3), COLUMNOFCHARACTERDATATYPE12
      -       "345678901234567890123456789012345678901234567890
      -       "1234567890123456789012345678901234567890
      -       "1234567890123 CHAR(3))" TO sqlstm

             DISPLAY "sqlstm = CREATE TABLE TESTC6439
      -    " (COLUMNOFCHARACTERSA CHAR(3),"
             DISPLAY
              "COLUMNOFCHARACTERDATATYPE12345678901234567890
      -       "1234567890123456789"
             DISPLAY
              "0123456789012345678901234567890123456789012345
      -       "678901234567890123"
             DISPLAY " CHAR(3))"
             DISPLAY "EXECUTE IMMEDIATE :sqlstm;"
             EXEC SQL EXECUTE IMMEDIATE :sqlstm END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "COMMIT WORK;"
             EXEC SQL COMMIT WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "INSERT INTO CTS1.TESTC6439"
             DISPLAY "VALUES('aaa','bbb');"
             EXEC SQL INSERT INTO CTS1.TESTC6439
               VALUES('aaa','bbb') END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "INSERT INTO CTS1.TESTC6439"
             DISPLAY "VALUES('ccc','ddd);"
             EXEC SQL INSERT INTO CTS1.TESTC6439
               VALUES  ('ccc','ddd') END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "INSERT INTO CTS1.TESTC6439"
             DISPLAY "VALUES('eee','fff');"
             EXEC SQL INSERT INTO CTS1.TESTC6439
               VALUES('eee','fff') END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *select values from dynamically created table

             DISPLAY "DECLARE c CURSOR"
             DISPLAY "FOR SELECT * FROM CTS1.TESTC6439 ORDER BY
      -    " COLUMNOFCHARACTERSA;"
             EXEC SQL DECLARE c CURSOR
               FOR SELECT * FROM CTS1.TESTC6439
               ORDER BY COLUMNOFCHARACTERSA END-EXEC

             DISPLAY "OPEN c;"
             EXEC SQL OPEN c END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE "xxxxxxxxxx" TO bb

             DISPLAY "FETCH c INTO :aa, :bb;"
             EXEC SQL FETCH c INTO :aa, :bb END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "aa should be aaa; its value is ", aa
             DISPLAY "bb should be bbb; its value is ", bb
             if (aa  NOT  =   "aaa"  OR  bb  NOT  =   "bbb") then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE "xxxxxxxxxx" TO bb

             DISPLAY "FETCH c INTO :aa, :bb;"
             EXEC SQL FETCH c INTO :aa, :bb END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "aa should be ccc; its value is ", aa
             DISPLAY "bb should be ddd; its value is ", bb
             if (aa  NOT  =   "ccc"  OR  bb  NOT  =   "ddd") then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE "xxxxxxxxxx" TO bb

             DISPLAY "FETCH c INTO :aa, :bb;"
             EXEC SQL FETCH c INTO :aa, :bb END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "aa should be eee; its value is ", aa
             DISPLAY "bb should be fff; its value is ", bb
             if (aa  NOT  =   "eee"  OR  bb  NOT  =   "fff") then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

             DISPLAY "CLOSE c;"
             EXEC SQL CLOSE c END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "COMMIT WORK;"
             EXEC SQL COMMIT WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *ADD column to table TESTB6439
             DISPLAY "ALTER TABLE CTS1.TESTB6439 ADD COLUMN
      -    " COLUMNOFCHARACTERDATATYPE"
             DISPLAY
              "1234567890123456789012345678901234567890
      -       "123456789012345678"
             DISPLAY "90123456789012345678901234567890123456789012C
      -    " CHAR(3);"
             EXEC SQL ALTER TABLE CTS1.TESTB6439
               ADD COLUMN
                COLUMNOFCHARACTERDATATYPE12345678901234567890
                123456789012345678901234567890123456789012345
                6789012345678901234567890123456789012C CHAR(3)
                END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "COMMIT WORK;"
             EXEC SQL COMMIT WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *check values can be inserted into new column

             DISPLAY "INSERT INTO CTS1.TESTB6439"
             DISPLAY "VALUES('TTT','TTT',100,100,'ADD');"
             EXEC SQL INSERT INTO CTS1.TESTB6439
               VALUES('TTT','TTT',100,100,'ADD') END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             MOVE "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
      -      "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
             TO aa
             MOVE "xxxxxxxxxx" TO bb
             MOVE 99 TO cc
             MOVE 99 TO dd
             MOVE "xxxxxxxxx" TO ee

      *check values inserted correctly
             DISPLAY "SELECT * INTO :aa, :bb, :cc, :dd, :ee FROM
      -    " CTS1.TESTB6439"
             DISPLAY "WHERE
      -    " COLUMNOFCHARACTERDATATYPE123456789012345678901234567"
             DISPLAY
              "89012345678901234567890123456789012345678901234567
      -       "89012345"
             DISPLAY "67890123456789012C = 'ADD';"
             EXEC SQL SELECT * INTO :aa, :bb, :cc, :dd, :ee FROM
             CTS1.TESTB6439
               WHERE
                COLUMNOFCHARACTERDATATYPE1234567890123456789012345
                67890123456789012345678901234567890123456789012345
                678901234567890123456789012C = 'ADD' END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY "aa should be TTT; its value is ", aa
             DISPLAY "bb should be TTT; its value is ", bb
             DISPLAY "cc should be 100; its value is ", cc
             DISPLAY "dd should be 100; its value is ", dd
             DISPLAY "ee should be ADD; its value is ", ee
             if (aa  NOT  =   "TTT"  OR  bb  NOT  =   "TTT" ) then
               MOVE 0 TO flag
             END-IF
             if (cc  NOT =  100  OR  dd  NOT =  100  OR  ee  NOT  =
             "ADD") then
               MOVE 0 TO flag
             END-IF
             DISPLAY  " "

             DISPLAY "ROLLBACK WORK;"
             EXEC SQL ROLLBACK WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *Now clean-up database

             DISPLAY "DROP TABLE TESTA6439 CASCADE;"
             EXEC SQL DROP TABLE TESTA6439 CASCADE END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "COMMIT WORK;"
             EXEC SQL COMMIT WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "DROP TABLE TESTB6439 CASCADE;"
             EXEC SQL DROP TABLE TESTB6439 CASCADE END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "COMMIT WORK;"
             EXEC SQL COMMIT WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "DROP TABLE TESTC6439 CASCADE;"
             EXEC SQL DROP TABLE TESTC6439 CASCADE END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

             DISPLAY "COMMIT WORK;"
             EXEC SQL COMMIT WORK END-EXEC
             MOVE SQLCODE TO SQL-COD
           PERFORM CHCKOK
             DISPLAY  " "

      *now record results

             if ( flag  =  1 ) then
               DISPLAY " xts729.pco *** pass *** "
               EXEC SQL INSERT INTO CTS1.TESTREPORT
                 VALUES('7029','pass','PCO') END-EXEC
               MOVE SQLCODE TO SQL-COD
             else
               DISPLAY " xts729.pco *** fail *** "
               EXEC SQL INSERT INTO CTS1.TESTREPORT
                 VALUES('7029','fail','PCO') END-EXEC
               MOVE SQLCODE TO SQL-COD
               COMPUTE errcnt = errcnt + 1
             END-IF

             DISPLAY "========================================"

             EXEC SQL COMMIT WORK END-EXEC
             MOVE SQLCODE TO SQL-COD

      ******************** END TEST7029 ********************

      **** TESTER MAY CHOOSE TO INSERT CODE FOR errcnt > 0
           STOP RUN.

      *    ****  Procedures for PERFORM statements

      *Test SQLCODE and SQLSTATE for normal completion.
       CHCKOK.
             DISPLAY "SQLCODE should be 0; its value is ", SQL-COD
             DISPLAY "SQLSTATE should be 00000; its value is ", SQLSTATE
             PERFORM NOSUBCLASS THRU EXIT-NOSUBCLASS
             if (SQLCODE NOT =  0  OR   NORMSQ NOT = "00000") then
               MOVE 0 TO flag
             END-IF
             if (NORMSQ = "00000"  AND  NORMSQ NOT = SQLSTATE)
             then
               DISPLAY "Valid implementation-defined SQLSTATE accepted."
             END-IF
             .

       NOSUBCLASS.

      *This routine replaces valid implementation-defined
      *subclasses with 000.  This replacement equates valid
      *implementation-defined subclasses with the 000 value
      *expected by the test case; otherwise the test will fail.
      *After calling NOSUBCLASS, NORMSQ will be tested
      *                          SQLSTATE will be printed.

           MOVE SQLSTATE TO NORMSQ

           MOVE 3 TO norm1
      *subclass begins in position 3 of char array NORMSQ
      *valid subclass begins with 5-9, I-Z, end of ALPNUM table
           PERFORM VARYING norm2 FROM 14 BY 1 UNTIL norm2 > 36
           if (NORMSQX(norm1)  =  ALPNUM(norm2)) then
             MOVE "0" TO NORMSQX(norm1)
           END-IF
           END-PERFORM

      *Quit if NORMSQ is unchanged.  Subclass is not impl.-def.
      *Changed NORMSQ means implementation-defined subclass,
      *so proceed to zero it out, if valid (0-9,A-Z)
           if (NORMSQ   =   SQLSTATE) then
             GO TO EXIT-NOSUBCLASS
           END-IF

           MOVE 4 TO norm1
      *examining position 4 of char array NORMSQ
      *valid characters are 0-9, A-Z
           PERFORM VARYING norm2 FROM 1 BY 1 UNTIL norm2 > 36
           if (NORMSQX(norm1)  =  ALPNUM(norm2)) then
             MOVE "0" TO NORMSQX(norm1)
           END-IF
           END-PERFORM

           MOVE 5 TO norm1
      *valid characters are 0-9, A-Z
      *examining position 5 of char array NORMSQ
           PERFORM VARYING norm2 FROM 1 BY 1 UNTIL norm2 > 36
           if (NORMSQX(norm1)  =  ALPNUM(norm2)) then
             MOVE "0" TO NORMSQX(norm1)
           END-IF
           END-PERFORM

      *implementation-defined subclasses are allowed for warnings
      *(class = 01).  These equate to successful completion
      *SQLSTATE values of 00000.
      *Reference SQL-92 4.28 SQL-transactions, paragraph 2

           if (NORMSQX(1)  =  "0"  AND  NORMSQX(2)  =  "1") then
             MOVE "0" TO NORMSQX(2)
           END-IF
           .

       EXIT-NOSUBCLASS.
           EXIT.

        P50.
               DISPLAY aa
           .

        P49.
               DISPLAY aa
           .

        P48.
               DISPLAY aa
           .

        P47.
               DISPLAY aa
           .

        P46.
               DISPLAY aa
           .

        P45.
               DISPLAY aa
           .

        P44.
               DISPLAY aa
           .

        P43.
               DISPLAY aa
           .

quality99%

¤ Dauer der Verarbeitung: 0.24 Sekunden (vorverarbeitet) ¤

Wurzel

Suchen

Beweissystem der NASA

Beweissystem Isabelle

NIST Cobol Testsuite

Cephes Mathematical Library

Wiener Entwicklungsmethode

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.

Bemerkung:

Die farbliche Syntaxdarstellung ist noch experimentell.