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, normally truncates the data to fit the host variable and puts the actual length in an indicator variable.
- 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 handles truncation of opaque-type data that is larger than 32 KB. When receives opaque-type data that is larger than 32 KB and the host variable is not large enough to hold the opaque-type data, truncates the data to 32 KB. 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).