166 CAST= Data Set Option Chapter 10
uses the dynamic SAS/ACCESS LIBNAME engine to insert or append data to a
DBMS table.
Details
Using BULKLOAD=YES is the fastest way to insert rows into a DBMS table.
See the SAS/ACCESS documentation for your DBMS interface for details.
DB2 OS/390 Details: BL_DB2LDUTIL is an alias for this option.
SYBASE Details: BULKLOAD=YES causes the data from the input data set to be
bulk copied into the output data set (a SYBASE table). Use of this option when loading
large amounts of data offers superior performance over standard SQL insert
statements. The LIBNAME option ENABLE_BULK= and the data set option
BULK_BUFFER= work in conjunction with this option. BULKCOPY, BULK, and
DBNOLOG are aliases for this option.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “BULKLOAD= LIBNAME Option” on page 73.
CAST= Data Set Option
Specifies whether data conversions should be performed on the Teradata DBMS server or by SAS
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: Teradata
Default value:
none
Syntax
CAST=YES | NO
Syntax Description
YES
forces data conversions (casting) to be done on the Teradata DBMS server and
overrides any data overhead percentage limit.
NO
forces data conversions to be done by SAS and overrides any data overhead
percentage limit.
Details
Internally, SAS numbers and dates are floating point values. Teradata has varying
formats for numbers, including integers, floating point values, and decimal values.
Number conversion must occur when you are reading Teradata numbers that are not
floating point (Teradata FLOAT). SAS/ACCESS can use the Teradata CAST= function to
