SESSION RESPBUFLEN Command | Basic Teradata Query - SESSION RESPBUFLEN (S RBL) - Basic Teradata Query

Purpose

This control enables users to specify the initial size of the client response buffer for future database sessions. It overrides the buffer length specified in the resp_buf_len entry in CLI’s System Parameter Block (SPB).

Syntax

where the following is true:

DEFAULT

Using the DEFAULT keyword has the same effect as specifying 0, and results in the following values:

Workstation

CLI SPB default

Mainframe

32767 bytes

0

Using 0 has the same effect as specifying DEFAULT, and results in the following values:

Workstation

CLI SPB default

Mainframe

32767 bytes

MAX32

Specifying MAX32 results in the following values:

Workstation

32731 bytes

Mainframe

32705 bytes

MAX64

Specifying MAX64 results in the following values:

Workstation

65535 bytes

Mainframe

65473 bytes

MAX1MB

Specifying MAX1MB results in the following values:

Workstation

1048418 bytes

Mainframe

1048418 bytes

MAX16MB

Specifying MAX16MB results in the following values:

Workstation

16775168 bytes

Mainframe

16775168 bytes

256..n

A number between 256 and n can be specified for the buffer length, where n is equivalent to the MAX16MB value for BTEQ.

Usage Notes

This command sets the initial size of the client response buffer. However, CLI will automatically increase the buffer if needed to handle larger responses. Use caution when setting the SESSION RESPBUFLEN value prior to MAX1MB, since a large amount of memory will be initially allocated for this purpose. Also note, that memory consumption could be significantly higher, especially if multiple sessions are being used.

When the SESSION RESPBUFLEN command is used without specifying any arguments, BTEQ sets SESSION RESPBUFLEN to its initial default.

The DEFAULTS command does not affect SESSION RESPBUFLEN setting.

The SESSION RESPBUFLEN command is valid in an SQL macro.