Truncation of opaque-type data

If you specify a host variable that is not large enough to hold the full return value from the server, Informix® ESQL/C normally truncates the data to fit the host variable and puts the actual length in an indicator variable.

This indicator variable can be one that you explicitly provide or, for dynamic SQL, one of the following fields of a dynamic-management structure.

Dynamic-management structure: Indicator field
system-descriptor area: INDICATOR field of an item descriptor
sqlda structure: sqlind field of an sqlvar_struct structure

However, these indicator fields are defined as a short integer and therefore can only store sizes up to 32 kilobytes.

This size limitation of the indicator field affects how Informix ESQL/C handles truncation of opaque-type data that is larger than 32 KB. When Informix ESQL/C receives opaque-type data that is larger than 32 KB and the host variable is not large enough to hold the opaque-type data, Informix ESQL/C truncates the data to 32 KB. Informix ESQL/C performs this truncation at 32 kilobytes even if you program a host variable that is larger than 32 KB (but still not large enough for the data).