When you run code that accesses a Teradata database version 16.00 or later, and results generate a row size that exceeds 64,000 bytes, the following error occurs:

Prior to Teradata Tools and Utilities (TTU) 16.0 and Teradata Server 16.00, 64K was the hard limit of the response parcel.

Teradata 16.00 and later releases support response row sizes up to 1 MB.

The only workaround is to restrict the number of columns to avoid exceeding the 64K row size.

Beginning with SAS^® 9.4M7 (TS1M7) and SAS^® Viya^®, the DS2, FEDSQL, and CAS procedures support this new Teradata feature. See SAS Note 63395, "Accessing Teradata version 16.00 or later might result in 'General error Response Row size exceeds 64K bytes...incompatible with the Client software.'"  

However, the DATA step, and other procedures, like the SQL procedure, including Explicit SQL, can still receive the error for wide-row tables.

Click the Hot Fix tab in this note to access the hot fix for this issue.

After the hot fix is installed, support is automatically enabled: 

• SAS/ACCESS^® Interface to Teradata queries the Teradata server and the TTU client to determine whether the 1-MB row size is configured.
• If the 1-MB row size is configured, SAS/ACCESS Interface to Teradata automatically uses it, except when using any of the Teradata legacy utility stand-alone features, such as FastLoad, MultiLoad, Multistatement, and FastExport.   
• However, since TPT=YES is enabled by default, SAS/ACCESS Interface to Teradata can take advantage of the 1-MB row size automatically as well, because FastLoad, MultiLoad, Multistatement, and FastExport actions with TPT take full advantage of 1-MB support.

To disable support for 1-MB response row sizes, you can take the following actions:

• Set an environment variable:
  
     export TD_1MB_ROW=OFF
   
• Start SAS^® with the SET option:
  
     sas -set TD_1MB_ROW OFF -otherOptions
   
• Use a SAS OPTIONS statement:
  
     options set = TD_1MB_ROW OFF;

To determine whether support is enabled or not, run the following OPTIONS statement with a valid Teradata library name:

If support is enabled, the SASTRACE output includes the following:

If support is disabled, and you attempt to access a wide-row Teradata table, the SASTRACE output includes the following:

SAS/ACCESS Interface to Teradata on z/OS (mainframe) does not support a 1-MB row size.

Operating System and Release Information

A fix for this issue for SAS/ACCESS Interface to Teradata 9.47 is available at: