DSNU053I csect-name FIELD cccccccc NOT FOUND

Explanation

This error is caused by one of the following situations:
  • Column name cccccccc is not a column name in the target table.
  • A field name in a WHEN clause does not match a column name in the target table.
  • The INCURSOR option was used to specify a cursor for the LOAD utility input data set. Db2 replaced expressions in the SELECT list of the cursor with new column names, such as DSN_SELECT_CLAUSE_EXPRESSION, which did not match column names in the target table.

System action

Utility processing is not initiated.

User response

Correct the LOAD utility statement, and resubmit the job.

If the error is caused by the existence of an INCURSOR option with expressions in the SELECT list of the cursor, rename expressions in the SELECT list by using the AS keyword.

Problem determination

Valid column names can be found in the SYSIBM.SYSCOLUMNS table.

Severity

8 (error)