SESSION RESPBUFLEN - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose  

Overrides the buffer length specified in the resp_buf_len entry in CLI’s System Parameter Block (SPB).

Syntax  

where:

 

Syntax Element

Buffer Length

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 MAX 1MB results in the following values:

Workstation

1048418 bytes

Mainframe

1048418 bytes

256...n

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