DSNU1231I csect-name - LENGTH OF OUTPUT RECORD IS TOO LONG FOR TABLE table-name

Explanation

An output record for the indicated table exceeded the physical limit.

System action

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

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

User response

Consider the following options to reduce the size of the output records:
  • Unload only the necessary fields using the field specification options.
  • Specify the LENGTH option with TRUNCATE and/or STRIP options for the applicable fields.
If the above options can not be applied, you will have to use an application to unload the data from the table.

Problem determination

This message is issued only when the NOPAD option is specified in the UNLOAD statement and most likely when BLOB, CLOB, or DBCLOB columns are selected for unload from the table. It is also possible that, if the expansion of output strings occurs due to the encoding scheme specified for the output, the total length of some output records becomes longer than expected.

Severity

4 (warning)