Previous Topic: Description of SQLCA in CA Datacom/DB FormatNext Topic: Warning Arrays - PL/I, Assembler, C


Warning Array - COBOL

Warning Return Code Array—COBOL:

Array Element

Explanation

SQLCA-WARNING(1)

After executing a DBSQLE command this field contains a W if any warning condition has been detected. Check the other warning flags for the specific warning. Otherwise contains spaces, that is, x'40'.

SQLCA-WARNING(2)

Contains W if the value of a string column was truncated when assigned to a host-variable. Otherwise contains spaces, that is, x'40'.

SQLCA-WARNING(3)

Contains W if null values were eliminated from the argument of a column function; not necessarily set to W for the MIN function because its results are not dependent on the elimination of null values. Otherwise contains spaces, that is, x'40'.

SQLCA-WARNING(4)

Contains a W if the number of host-variables in the INTO clause of a FETCH or SELECT INTO statement is not equal to the number of items in the SELECT list. The actual number of columns returned is the smaller of the two numbers. Otherwise contains spaces, that is, x'40'.

SQLCA-WARNING(5)

Contains W if a prepared UPDATE or DELETE statement does not include a WHERE clause. Otherwise contains spaces, that is, x'40'.

SQLCA-WARNING(6)

Reserved for future use.

SQLCA-WARNING(7)

Contains a W if an adjustment was made to a DATE or TIMESTAMP value to correct an invalid date resulting from an arithmetic operation. Otherwise contains spaces, that is, x'40'.

SQLCA-WARNING(8)

Contains a W if it was generated by a procedure.

Note: In CA Datacom/DB Release 8.0, SQLCA-WARNING(6) was the DATE/TIME adjustment warning, but with later versions that warning is in SQLCA-WARNING(7). Application programs written for use with Release 8.0 may therefore have to be adjusted accordingly for use with later versions.