Usage Note 8268: Setting the value for Teradata response buffer length outside of SAS
By default, the SAS/Access Teradata engine sets the value of
resp_buf_len in the DBCAREA to either 32K or 64k.
If this value needs to be changed to something other than 32K or 64K,
the UNIX environment variable TR_RESP_BUF_SET should be set to TRUE, and
the value should be defined in the Teradata clispb.dat file. Setting the
environment variable will signal the Teradata CLI to query the value for
the resp_buf_len from the clispb.dat file bypassing the hardcoded
values.
The environment variable should be set as follows:
Bourne or Korn shell:
export TR_RESP_BUF_SET=1
C Shell:
setenv TR_RESP_BUF_SET 1
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#008268
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Teradata | Microsoft Windows NT Workstation | 8.2 TS2M0 | |
| Microsoft Windows 95/98 | 8.2 TS2M0 | |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | |
| Microsoft Windows 2000 Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | |
| z/OS | 8.2 TS2M0 | |
| Solaris | 8.2 TS2M0 | |
| 64-bit Enabled Solaris | 8.2 TS2M0 | |
| 64-bit Enabled AIX | 8.2 TS2M0 | |
| AIX | 8.2 TS2M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Usage Note |
| Priority: | low |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Teradata
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2003-01-15 11:20:44 |
| Date Created: | 2002-08-14 13:50:59 |
