17.00 - -304 Output host variable is too small to hold returned data - Teradata Tools and Utilities

Teradata Preprocessor2 (SPP Prefix) Messages

prodname
Preprocessor2 for Embedded SQL
Teradata Tools and Utilities
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-1096-PP2

-304 Output host variable is too small to hold returned data

Possible Cause

The size of the output host variable is insufficient to contain the returned data. Conversion of a numeric field to a smaller numeric host variable (such as an integer value that is beyond the limits of a small integer variable) produces this problem. This error occurs for numeric fields only.

Possible Solution

Increase the size of the output host variable to allow the returned value to fit.