OVERRIDE_RESP_LEN= LIBNAME Statement Option

Specifies whether to override the default response buffer length.

Valid in: SAS/ACCESS LIBNAME statement
Category: Data Set Control
Default: NO
Interaction: When you set this option to YES, specify a response buffer length larger than the default value (1,048,500 bytes) in the Teradata configuration file (clispb.dat). Also, specify the file name and location of the configuration file in the COPLIB environment variable.
Data source: Teradata
Note: Support for this option was added in SAS 9.4M8.
Tip: Use this option to improve performance when you are not using the Teradata TPT API.
Example: 
options set=COPLIB="/u/user/config/4MBbuff";
libname td teradata server=myserver user=myuser password=mypwd override_resp_len=yes;

data null;
   set td.table-name (tpt=no);
   <other statements>
run;

Table of Contents

Syntax

OVERRIDE_RESP_LEN=YES | NO

Required Argument

YES | NO

specifies whether to override the default response buffer length.

Details

Use this option to enhance performance when you are not using the Teradata TPT API.

The default response buffer length that is used by SAS/ACCESS is 1,048,500 bytes. Specify a different buffer length for the resp_buf_len variable in the Teradata configuration file (clispb.dat). Also, specify that the COPLIB environment variable points to the configuation file with the modified buffer length. The path that you supply for COPLIB should contain the location of the configuration file. The configuration file name is assumed to be clispb.dat.

Your modified configuration file might contain this line to set the response buffer size to 4 MB.

resp_buf_len=4194304

You can specify the OVERRIDE_RESP_LEN= option in the CONNECT statement in a call to PROC SQL. For example, you might specify code similar to this sample. SAS/ACCESS uses the response buffer length from the clispb.dat file in /u/myuser/project/4MBbuff.

options set=COPLIB="/u/myuser/project/4MBbuff";

proc sql;
connect to teradata (database=mydatabase tdpid=value user=myUID password=mypwd1
                     tpt=no override_resp_len=yes);
               create table largerow as select * from connection to teradata
               (select * from myUID.SampleLargeRow);

disconnect from teradata;
quit;
Last updated: February 3, 2026