APPL_DDF_DETAIL INPUT FIELD 'PREPARES_SENT' INVALID

Document ID : KB000092769
Last Modified Date : 11/05/2018
Show Technical Document Details
Issue:
Loading the APPL_DDF_DETAIL table the job failed with the following message:
DSNU334I ?DSNS 089 10:19:14.11 DSNURCON - INPUT FIELD 'PREPARES_SENT', INVALID FOR 'INSIGHT.APPL_DDF_DETAIL', ERROR CODE '04 - INPUT PACKED DECIMAL IS IN ERROR' DB2 V11 NFM
Resolution:
Modifying  the following field definition
From REQ_PRDID CHAR(8) NULLIF(NULLS_61_FIELDS='Y'),
to      REQ_PRDID POSITION(1015) CHAR(8) NULLIF(NULLS_61_FIELDS='Y'),
in the ARCLACDD file resolve the problem.