-304 Output host variable is too small to hold returned data - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
ft:locale
en-US
ft:lastEdition
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

-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.