168 COMMAND_TIMEOUT= Data Set Option Chapter 10
Syntax Description
<n>
Any positive numeric value. The engine default is 20.
Details
Teradata INTEGER, BYTEINT, SMALLINT, and DATE columns require conversion
when read in to SAS. Conversions can be performed either by Teradata or by SAS.
When performed in Teradata, using Teradata’s CAST operator, the row size transmitted
to SAS can increase. CAST_OVERHEAD_MAXPERCENT= limits the allowable
increase, also called conversion overhead.
Examples
The following example demonstrates the use of CAST_OVERHEAD_MAXPERCENT=
to increase the allowable overhead to 40 percent:
proc print data=mydblib.emp (CAST_OVERHEAD_MAXPERCENT=40);
where empno<1000;
run;
See Also
“CAST= LIBNAME Option” on page 74 for more information about conversions,
conversion overhead, and casting.
COMMAND_TIMEOUT= Data Set Option
Specifies the number of seconds to wait before a command times out
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: OLE DB
Default value:
LIBNAME setting
Syntax
COMMAND_TIMEOUT=number-of-seconds
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “COMMAND_TIMEOUT= LIBNAME Option” on page 77.
