IDENTIFICATION DIVISION.
PROGRAM-ID. DML120.
ENVIRONMENT DIVISION.
CONFIGURATION SECTION.
SOURCE-COMPUTER. xyz.
OBJECT-COMPUTER. xyz.
DATA DIVISION.
WORKING-STORAGE SECTION.
* Standard COBOL (file "DML120.SCO") calling SQL
* procedures in file "DML120.MCO".
****************************************************************
*
* COMMENT SECTION
*
* DATE 1994/6/7 STANDARD COBOL LANGUAGE
* NIST SQL VALIDATION TEST SUITE V6.0
* DISCLAIMER:
* This program was written by employees of NIST to test SQL
* implementations for conformance to the SQL standards.
* NIST assumes no responsibility for any party's use of
* this program.
*
* DML120.SCO
* WRITTEN BY: David W. Flater
* TRANSLATED AUTOMATICALLY FROM EMBEDDED COBOL BY CHRIS SCHANZLE
*
* This routine tests FIPS feature 20.
* This is the dynamic version of DML119.PC.
*
* REFERENCES
* FIPS PUB 127-2 14.1 Transitional SQL
* ANSI SQL-1992
*
****************************************************************
* 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 int1 PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
01 flt1 PIC S9(4)V9(4) DISPLAY SIGN LEADING SEPARATE.
01 dbl1 PIC S9(4)V9(4) DISPLAY SIGN LEADING SEPARATE.
01 ch1 PIC X(10).
01 dstmt PIC X(50).
01 longst PIC X(240).
* EXEC SQL END DECLARE SECTION END-EXEC
01 FLT-1 PIC -(5).9(4).
01 DBL-1 PIC -(5).9(4).
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 SQL-COD PIC S9(9) DISPLAY SIGN LEADING SEPARATE.
PROCEDURE DIVISION.
P0.
MOVE "FLATER " TO uid
CALL "AUTHID" USING uid
MOVE "not logged in, not" TO uidx
* EXEC SQL SELECT USER INTO :uidx FROM HU.ECCO;
CALL "SUB1" USING SQLCODE SQLSTATE uidx
MOVE SQLCODE TO SQL-COD
* EXEC SQL ROLLBACK WORK;
CALL "SUB2" USING SQLCODE SQLSTATE
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, Module COBOL, dml120.sco"
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 TEST0648 *******************
MOVE 1 TO flag
DISPLAY " TEST0648 "
DISPLAY " Feature 20, CAST functions (dynamic)"
DISPLAY "References:"
DISPLAY " FIPS PUB 127-2 14.1 Transitional SQL feature
- " 20"
DISPLAY " 6.10 -- "
DISPLAY " 6.11 LR.2.d -- in a
- " primary>"
DISPLAY " - - - - - - - - - - - - - - - - - - -"
COMPUTE SQLCODE = -1
MOVE "xxxxx" TO SQLSTATE
*Datetime casting has been beaten to death by now.
*Here we have your average legacy system table in which numeric
*data (USER_TYPED) are stored as character strings. It seemed
*like a good idea at the time they created the table.
* EXEC SQL DELETE FROM CONCATBUF;
CALL "SUB3" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL INSERT INTO CONCATBUF VALUES (
* 'CREATE TABLE USER_INPUT (' ||
* ' USER_ID INT, USER_TYPED CHAR (10),' ||
* ' CASH_BALANCE NUMERIC (5, 2))'
* );
CALL "SUB4" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL SELECT ZZ INTO :longst FROM CONCATBUF;
CALL "SUB5" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
DISPLAY "longst=""", longst """"
DISPLAY "COMMIT WORK;"
* EXEC SQL COMMIT WORK;
CALL "SUB6" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "EXECUTE IMMEDIATE :longst;"
* EXEC SQL EXECUTE IMMEDIATE :longst;
CALL "SUB7" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "COMMIT WORK;"
* EXEC SQL COMMIT WORK;
CALL "SUB8" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
*And here we have the band-aid that is applied years later in an
*attempt to conform to a standardized interface.
* EXEC SQL DELETE FROM CONCATBUF;
CALL "SUB9" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL INSERT INTO CONCATBUF VALUES (
* 'CREATE VIEW STANDARD_INPUT AS' ||
* ' SELECT CAST (USER_ID AS CHAR (10)) AS USER_NAME,' ||
* ' CAST (USER_TYPED AS NUMERIC (5, 2)) AS USER_INPUT,' ||
* ' CAST (CASH_BALANCE AS REAL) AS RECEIVABLE' ||
* ' FROM USER_INPUT'
* );
CALL "SUB10" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL SELECT ZZ INTO :longst FROM CONCATBUF;
CALL "SUB11" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
DISPLAY "longst=""", longst """"
DISPLAY "COMMIT WORK;"
* EXEC SQL COMMIT WORK;
CALL "SUB12" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "EXECUTE IMMEDIATE :longst;"
* EXEC SQL EXECUTE IMMEDIATE :longst;
CALL "SUB13" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "COMMIT WORK;"
* EXEC SQL COMMIT WORK;
CALL "SUB14" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "dstmt=""INSERT INTO USER_INPUT VALUES (?, ?, ?)"""
MOVE "INSERT INTO USER_INPUT VALUES (?, ?, ?) "
TO dstmt
DISPLAY "PREPARE S12011 FROM :dstmt;"
* EXEC SQL PREPARE S12011 FROM :dstmt;
CALL "SUB15" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
MOVE 0 TO int1
MOVE "999.99 " TO ch1
MOVE 999.99 TO dbl1 DBL-1
DISPLAY "int1=", int1 " ch1='", ch1 "'" " dbl1=", DBL-1
DISPLAY "EXECUTE S12011 USING :int1, :ch1, :dbl1;"
* EXEC SQL EXECUTE S12011 USING :int1, :ch1, :dbl1;
CALL "SUB16" USING SQLCODE SQLSTATE int1 ch1 dbl1
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
MOVE 1 TO int1
MOVE "-999.99 " TO ch1
MOVE -999.99 to dbl1 DBL-1
DISPLAY "int1=", int1 " ch1='", ch1 "'" " dbl1=", DBL-1
DISPLAY "EXECUTE S12011 USING :int1, :ch1, :dbl1;"
* EXEC SQL EXECUTE S12011 USING :int1, :ch1, :dbl1;
CALL "SUB17" USING SQLCODE SQLSTATE int1 ch1 dbl1
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
MOVE 2 TO int1
MOVE " 54. " TO ch1
MOVE 54.0 TO dbl1 DBL-1
DISPLAY "int1=", int1 " ch1='", ch1 "'" " dbl1=", DBL-1
DISPLAY "EXECUTE S12011 USING :int1, :ch1, :dbl1;"
* EXEC SQL EXECUTE S12011 USING :int1, :ch1, :dbl1;
CALL "SUB18" USING SQLCODE SQLSTATE int1 ch1 dbl1
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
*<cast specification> in a <row value constructor>
* EXEC SQL DELETE FROM CONCATBUF;
CALL "SUB19" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL INSERT INTO CONCATBUF VALUES (
* 'INSERT INTO USER_INPUT VALUES' ||
* ' (CAST (''3'' AS INT), CAST (-7.02 AS CHAR (10)),' ||
* ' CAST ('' -.702E+1'' AS NUMERIC (5, 2)))'
* );
CALL "SUB20" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL SELECT ZZ INTO :longst FROM CONCATBUF;
CALL "SUB21" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
DISPLAY "longst=""", longst """"
DISPLAY "EXECUTE IMMEDIATE :longst;"
* EXEC SQL EXECUTE IMMEDIATE :longst;
CALL "SUB22" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
*<cast specification> in a <general set function>. Note that we
*cannot specify DISTINCT due to 6.5 LR.1.a
*(999 - 999 + 54 - 7) / 4 = 47 / 4 = 11 or 12
*It works out the same with rounding.
* EXEC SQL DELETE FROM CONCATBUF;
CALL "SUB23" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL INSERT INTO CONCATBUF VALUES (
* 'SELECT AVG (CAST (USER_TYPED AS INT))' ||
* ' FROM USER_INPUT'
* );
CALL "SUB24" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL SELECT ZZ INTO :longst FROM CONCATBUF;
CALL "SUB25" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
DISPLAY "longst=""", longst """"
DISPLAY "PREPARE S12012 FROM :longst;"
* EXEC SQL PREPARE S12012 FROM :longst;
CALL "SUB26" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "DECLARE C12012 CURSOR FOR S12012;"
* EXEC SQL DECLARE C12012 CURSOR FOR S12012 END-EXEC
DISPLAY " "
DISPLAY "OPEN C12012;"
* EXEC SQL OPEN C12012;
CALL "SUB27" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
COMPUTE int1 = -1
DISPLAY "FETCH C12012 INTO :int1;"
* EXEC SQL FETCH C12012 INTO :int1;
CALL "SUB28" USING SQLCODE SQLSTATE int1
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "int1 should be 11 or 12; its value is ", int1
if (int1 < 11 OR int1 > 12) then
MOVE 0 TO flag
END-IF
DISPLAY "CLOSE C12012;"
* EXEC SQL CLOSE C12012;
CALL "SUB29" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
*(999.99 - 999.99 + 54 - 7.02) /4 = 46.98 / 4 = 11.745
*Allow +- 0.01 for inaccuracy
DISPLAY "dstmt=""SELECT AVG (USER_INPUT) FROM
- " STANDARD_INPUT"""
MOVE "SELECT AVG (USER_INPUT) FROM STANDARD_INPUT "
TO dstmt
DISPLAY "PREPARE S12013 FROM :dstmt;"
* EXEC SQL PREPARE S12013 FROM :dstmt;
CALL "SUB30" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "DECLARE C12013 CURSOR FOR S12013;"
* EXEC SQL DECLARE C12013 CURSOR FOR S12013 END-EXEC
DISPLAY " "
DISPLAY "OPEN C12013;"
* EXEC SQL OPEN C12013;
CALL "SUB31" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
MOVE 0.0 TO flt1
DISPLAY "FETCH C12013 INTO :flt1;"
* EXEC SQL FETCH C12013 INTO :flt1;
CALL "SUB32" USING SQLCODE SQLSTATE flt1
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
MOVE flt1 TO FLT-1
DISPLAY "flt1 should be 11.745 +- 0.01; its value is ",
FLT-1
if (flt1 < 11.735 OR flt1 > 11.755) then
MOVE 0 TO flag
END-IF
DISPLAY "CLOSE C12013;"
* EXEC SQL CLOSE C12013;
CALL "SUB33" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
*<cast specification> in an update statement
* EXEC SQL DELETE FROM CONCATBUF;
CALL "SUB34" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL INSERT INTO CONCATBUF VALUES (
* ' SELECT CASH_BALANCE FROM USER_INPUT' ||
* ' WHERE USER_ID = CAST (''-0'' AS INT)'
* );
CALL "SUB35" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL SELECT ZZ INTO :longst FROM CONCATBUF;
CALL "SUB36" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
DISPLAY "longst=""", longst """"
DISPLAY "PREPARE S12014 FROM :longst;"
* EXEC SQL PREPARE S12014 FROM :longst;
CALL "SUB37" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "DECLARE C12014 CURSOR FOR S12014;"
* EXEC SQL DECLARE C12014 CURSOR FOR S12014 END-EXEC
DISPLAY " "
DISPLAY "OPEN C12014;"
* EXEC SQL OPEN C12014;
CALL "SUB38" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
COMPUTE int1 = -1
DISPLAY "FETCH C12014 INTO :int1;"
* EXEC SQL FETCH C12014 INTO :int1;
CALL "SUB39" USING SQLCODE SQLSTATE int1
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "int1 should be 999 or 1000; its value is ", int1
if (int1 < 999 OR int1 > 1000) then
MOVE 0 TO flag
END-IF
DISPLAY "UPDATE USER_INPUT"
DISPLAY " SET USER_TYPED = CAST (0 AS CHAR (10)),"
DISPLAY " CASH_BALANCE = CASH_BALANCE - CAST ('500' AS
- " NUMERIC (5, 2))"
DISPLAY " WHERE CURRENT OF C12014;"
* EXEC SQL UPDATE USER_INPUT
* SET USER_TYPED = CAST (0 AS CHAR (10)),
* CASH_BALANCE = CASH_BALANCE - CAST ('500' AS NUMERIC (5,
* 2))
* WHERE CURRENT OF C12014;
CALL "SUB40" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
*Check table contents
* EXEC SQL DELETE FROM CONCATBUF;
CALL "SUB41" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL INSERT INTO CONCATBUF VALUES (
* 'SELECT SUM (USER_INPUT) * 100 ' ||
* ' FROM STANDARD_INPUT' ||
* ' HAVING SUM (RECEIVABLE)' ||
* ' BETWEEN -4.5306E2 AND -4.5298E2'
* );
CALL "SUB42" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
* EXEC SQL SELECT ZZ INTO :longst FROM CONCATBUF;
CALL "SUB43" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
DISPLAY "longst=""", longst """"
DISPLAY "PREPARE S12015 FROM :longst;"
* EXEC SQL PREPARE S12015 FROM :longst;
CALL "SUB44" USING SQLCODE SQLSTATE longst
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "DECLARE C12015 CURSOR FOR S12015;"
* EXEC SQL DECLARE C12015 CURSOR FOR S12015 END-EXEC
DISPLAY " "
DISPLAY "OPEN C12015;"
* EXEC SQL OPEN C12015;
CALL "SUB45" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
MOVE 0.0 TO flt1
COMPUTE int1 = -1
DISPLAY "FETCH C12015 INTO :int1;"
* EXEC SQL FETCH C12015 INTO :int1;
CALL "SUB46" USING SQLCODE SQLSTATE int1
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY "int1 should be -95301 +- 4; its value is ", int1
if (int1 < -95305 OR int1 > -95297) then
MOVE 0 TO flag
END-IF
DISPLAY "CLOSE C12014;"
* EXEC SQL CLOSE C12014;
CALL "SUB47" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "CLOSE C12015;"
* EXEC SQL CLOSE C12015;
CALL "SUB48" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "COMMIT WORK;"
* EXEC SQL COMMIT WORK;
CALL "SUB49" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "dstmt=""DROP TABLE USER_INPUT CASCADE"""
MOVE "DROP TABLE USER_INPUT CASCADE "
TO dstmt
DISPLAY "EXECUTE IMMEDIATE :dstmt;"
* EXEC SQL EXECUTE IMMEDIATE :dstmt;
CALL "SUB50" USING SQLCODE SQLSTATE dstmt
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
DISPLAY "COMMIT WORK;"
* EXEC SQL COMMIT WORK;
CALL "SUB51" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
PERFORM CHCKOK
DISPLAY " "
if ( flag = 1 ) then
DISPLAY " *** pass *** "
* EXEC SQL INSERT INTO HU.TESTREPORT
* VALUES('0648','pass','MCO');
CALL "SUB52" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
else
DISPLAY " dml120.sco *** fail *** "
* EXEC SQL INSERT INTO HU.TESTREPORT
* VALUES('0648','fail','MCO');
CALL "SUB53" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
COMPUTE errcnt = errcnt + 1
END-IF
DISPLAY "==============================================="
* EXEC SQL COMMIT WORK;
CALL "SUB54" USING SQLCODE SQLSTATE
MOVE SQLCODE TO SQL-COD
******************** END TEST0648 ********************
**** 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.
¤ Dauer der Verarbeitung: 0.42 Sekunden
(vorverarbeitet)
¤
|
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.
|