Teradata Database Message 9600 - 17.10 - 9600 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Response buffer size is insufficient to hold records 32KB.
Explanation
This error occurs if FetchRowCount value is greater than number of rows that can be returned in a single response buffer to the host. This occurs when the below conditions are true. 1) fetchrowcount value is greater than number of rows that would fit in 32K and 2) user specifies a response buffer <= 32K but the actual data is > 32K.
Generated By
Dispatcher.
For Whom
End User.
Notes
None
Remedy
Client application can reduce the fetchrowcount value and submit a CONTINUE request. (OR) For Host utilities that cannot handle 64KB Row Size, they should not resend the request. (OR) For Host utilities that can handle 64KB Row Size, enlarge the application's response buffer size to at least the size (but no more than 64,256) returned in the Info field of the ERROR parcel and submit a CONTINUE request containing a single RESP or KEEPRESP parcel that specifies the new response buffer size.