DSNU1233I csect-name - DATA IS TOO LONG FOR FIELD field-name, TABLE table-name

Explanation

The space for the field in an output record is not large enough to unload the data from the corresponding column of a row in the indicated table.

If you are trying to unload tables in spanned record format, one or more of the source tables might not have LOB or XML columns.

csect-name
The name of the control section that issued the message.
field-name
The name of the field.
table-name
The name of the table.

System action

The record in error is not unloaded to the output data set. The UNLOAD utility continues until the total number of records in error reaches the value that is specified by the MAXERR option. The default MAXERR value is 1.

If the total number of records in error reaches the MAXERR value, UNLOAD issues message DSNU1219I and terminates with the return code 8.

User response

Take one of the following actions:

  • If you received this message when trying to unload tables in spanned record format, ensure that all of the tables in the FROM TABLE clauses have at least one LOB or XML column. Use a separate UNLOAD statement for those tables that do not have LOB or XML columns.
  • Apply appropriate values to the LENGTH or POSITION parameters in the field specification list to accommodate the data in the output records.
  • Specify the TRUNCATE option for the field, if applicable.
  • If the data contains leading or trailing blanks, specify the STRIP option to reduce the length of the data.

Severity

4 (warning)