Purpose
Specifies the response buffer length to be used when processing an SQL request.
Invocation
Nonexecutable.
Preprocessor declarative.
Embedded SQL only.
Syntax
SET BUFFERSIZE size
- size
- An integer numeric literal that defines the response buffer length to be used when processing subsequent SQL requests.
ANSI Compliance
SET BUFFERSIZE is a Teradata extension to the ANSI/ISO SQL:2011 standard.
Authorization
None.
Explicitly Specified Response Buffer Length
Preprocessor2 requests that follow the SET BUFFERSIZE statement sequentially use the value for buffer size specified by size. The request buffer size is not affected by this statement.
Default Response Buffer Length
If no SET BUFFERSIZE statement is used, the default response buffer length is used for all requests.
Rules
- The value of size must be either zero or a valid number within the range of 256 to 65535. A value of zero specifies the default response buffer length.
On this type of platform … Default buffer size is defined in … IBM mainframe HSHSPB workstation clispb.dat - If the value of size is outside the valid range or is non-numeric, the default response buffer length is used and the Teradata Database displays preprocessor warning message SPP1500.