SET BUFFERSIZE | Teradata Vantage - SET BUFFERSIZE - Advanced SQL Engine - Teradata Database

Specifies the response buffer length to be used when processing an SQL request.

ANSI Compliance

SET BUFFERSIZE is a Teradata extension to the ANSI/ISO SQL:2011 standard.

Required Privileges

None.

Invocation

Nonexecutable.

Preprocessor declarative.

Embedded SQL only.

Syntax

SET BUFFERSIZE size

Syntax Elements

size

An integer numeric literal that defines the response buffer length to be used when processing subsequent SQL requests.

The value for size must be 0 or an integer of 256 to 1MB.

Usage Notes

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

• 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 database displays preprocessor warning message SPP1500.