Previous Topic: -159 - HOST VARIABLE INCOMPATIBLE WITH COLUMN AT POSITION aaaaNext Topic: -162 - CANNOT INSERT AND SELECT ON THE SAME TABLE


-161 - colname datatype(prec,scale) INVALID DATA: hh

Reason:

The data does not match the definition of the host variable or column in a row that is defined as NUMERIC (zoned) or DECIMAL (packed) with the identified precision and scale.

In the message text:

colname

Blank if not a column or the column name

datatype

Either DECIMAL or NUMERIC

hh

16 bytes hex dump starting at the value

prec

Precision

scale

Scale

Read the data from left to right. Each grouping of data represents four bytes. Zeros are suppressed. Read only the number of bytes indicated.

The SQLSTATE that equates to this SQL return code is 22S03.

Action:

Obtain partial job output to try to determine which host variable or column is incorrect. Correct or delete the column in error and rerun the job.