Purpose
This control enables users to specify whether CLI double-buffering is active or inactive. It overrides CLI’s System Parameter Block (SPB) two_resp_bufs entry for client response buffering.
Syntax
| Command | Shorthand | Command | Shorthand |
|---|---|---|---|
| SESSION | S | TWORESPBUFS | TRB |
where the following is true:
- ON
- CLI’s double-buffering function is active.
If neither ON or OFF is specified in the command, BTEQ sets SESSION TWORESPBUFS to ON.
- OFF
- CLI’s double-buffering function is not active.
Usage Notes
The specifications for the SESSION TWORESPBUFS command always override the two_resp_bufs entries for double-buffering in CLI’s System Parameter Block (SPB). In general, use of double-buffering enables performance benefits that cannot be realized when using single-buffering. Therefore, BTEQ specifies a default of ON for this setting. For more information about CLI buffering methods, see Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems, B035-2418.
The DEFAULTS command does not affect SESSION TWORESPBUFS setting.
The SESSION TWORESPBUFS command is valid in an SQL macro.