DSNU283I csect-name error-type SQLCODE = sqlcode, SQLERRM = sqlerrm, SQLSTATE = sqlstate, SQLERRP = sqlerrp, SQLERRD = sqlerrd1 sqlerrd2 sqlerrd3 sqlerrd4 sqlerrd5 sqlerrd6
Explanation
An error occurred that returned SQLCA error information to the utility. This message contains multiple components.
- csect-name
- The name of the control section that issued the message.
- error-type
- Indicates the type of error:
- Trigger error
- LOB error
- XML error
- Key evaluation error
- Application of pending definition change
- sqlcode
- The SQL return code. A negative number indicates that an error has occurred.
- sqlerrm
- A length indicator and one or more tokens, separated by X'FF', that are substituted for variables in the descriptions of error conditions. It may contain truncated tokens. A length of 70 bytes might indicate a possible truncation.
- sqlstate
- A return code for the outcome of the most recent execution of an SQL statement
- sqlerrp
- The name of the procedure that detected the error.
- sqlerrd1 through sqlerrd6
- SQL diagnostic information. Each field contains a value that indicates the number of rows that qualified for the SQL statement, the number of rows in the result table, a rough estimate of required resources, or an internal error code.
System action
Processing terminates.
For the LOAD utility with a DISCARD data set, the rows that encounter the error are placed in the discard file. Otherwise the utility abends.
User response
Determine the cause for the SQL error by using information about the specific SQLCODE. Correct the error and run the utility again.
Severity
8 (error)