DSNH080I E csectname LINE nnnn COL cc usage VARIABLE name IS NOT type TYPE

Explanation

The usage is INDICATOR or STRING. The type is SMALLINT, VARCHAR, or CHARACTER. The data type of the variable name is not acceptable. All indicator variables must be small integers. PREPARE and EXECUTE strings must be variable character strings, except for FORTRAN, which requires character type.

System action

If the containing SQL statement is a declaration, it is discarded. If the containing SQL statement is executable, it is replaced by host language statements that will, if executed, set an error code in the SQLCA.

User response

Specify a host variable of the proper type.

Severity

8 (error)