A Rexx interface to SQL databases

Version 2.5

10 October 2006

4. Errors

All functions return a negative number if an error occurred. Zero or positive return values indicate success.

When an error occurs in the Rexx/SQL interface, the function returns a negative number corresponding to one of the numbers below and the variable SQLCA.INTCODE is set to that number. The variable SQLCA.INTERRM is also set to the corresponding message. If a database error occurs, SQLCA.SQLCODE and SQLCA.SQLERRM are set to the appropriate values.

Internal Errors:

    -1  - Database Error
    -6  - identifier is too long; max length is n
    -7  - value is not a valid integer.
    -8  - internal error
    -9  - no message available for SQLCODE n
    -10 - out of memory
    -11 - unknown variable variable.
    -12 - variable variable is not settable.
    -13 - statement statement is not a query.
    -14 - <parameter> is not a valid integer.
    -15 - Conversion/truncation occurred on column column: Expecting n, got m
    -16 - unable to set Rexx variable
    -18 - extraneous argument - argument
    -19 - null ("") variable name.
    -20 - connection already open with name connection.
    -21 - connection connection is not open.
    -22 - no connections open.
    -23 - statement name omitted or null
    -24 - statement statement does not exist
    -25 - no connection is current
    -26 - statement has not been opened or executed
    -27 - reached maximum number of connections: n
    -28 - not connected with sufficient privileges
    -51 - zero length identifier
    -52 - garbage in identifier name
    -61 - n bind variables passed. m expected
    -62 - bind values must be paired
    -63 - invalid substitution variable name at bind pair n.
    -64 - invalid datatype datatype specified
    -71 - Too many columns specified in SELECT
    -75 - no database name supplied
    -76 - <connect string> must be only argument
    -83 - Column column-name not present in statement
    -84 - parameter parameter MUST be supplied
    -85 - Column <column> does not have a 'LONG' datatype
    -86 - action on file file-name failed: <reason>
    -87 - parameter parameter must be <= size
    -88 - Column <%s> not present in statement.
    -89 - Column <%s> has NULL value; cannot call this function.
    -91 - stem name MUST have trailing '.'
    -97 - value is not a valid boolean.
    -98 - invalid value of "value" for parameter n; value should be one of "value"

Return to Table of Contents
Last updated 10 October 2006