BULKLOAD= Data Set Option

Loads rows of data as one unit.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Alias: BL_DB2LDUTIL= [DB2 under z/OS], FASTLOAD= [Teradata]
Default: NO
Data source: Aster nCluster, DB2 under UNIX and PC Hosts, DB2 under z/OS, Greenplum, HP Neoview, Netezza, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata
Tip: Using BULKLOAD=YES is the fastest way to insert rows into a DBMS table.
See: BULKEXTRACT= LIBNAME option, BULKEXTRACT= data set option, BULKUNLOAD= LIBNAME option, BULKUNLOAD= data set option, DBCOMMIT= data set option, ENABLE_BULK= LIBNAME option [Sybase], ERRLIMIT= data set option

[DBMS-specific details] Aster nCluster, DB2 under UNIX and PC Hosts, DB2 under z/OS, Greenplum, HP Neoview, Netezza, ODBC, OLE DB , Oracle, Sybase, Sybase IQ, Teradata
Syntax

Syntax

BULKLOAD=YES | NO

Syntax Description

YES
calls a DBMS-specific bulk-load facility to insert or append rows to a DBMS table.
NO
uses the dynamic SAS/ACCESS engine to insert or append data to a DBMS table.
Copyright © SAS Institute Inc. All rights reserved.