Data Set Options for Relational Databases |
Alias: | BL_DATAFILE |
Default value: | creates a data file in the current directory or with the default file specifications (same as for BL_DATAFILE=) |
Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
DBMS support: | DB2 under UNIX and PC Hosts, Sybase IQ |
Syntax | |
Syntax Description | |
Details | |
See Also |
Syntax |
BL_SERVER_DATAFILE=path-and-data-filename |
fully qualified pathname and filename of the data file to load, as seen by the DBMS server instance. By default, the base filename takes the form BL_<table>_<unique-ID>:
table |
specifies the table name. |
unique-ID |
specifies a number that is used to prevent collisions in the event of two or more simultaneous bulk loads of a particular table. The SAS/ACCESS engine generates the number. |
Details |
To specify this option, you must first set BULKLOAD=YES.
DB2 under UNIX and PC Hosts: You must also specify a value for BL_REMOTE_FILE=. If the path to the data file from the DB2 server instance is different from the path to the data file from the client, you must use BL_SERVER_DATAFILE= to specify the path from the DB2 server. By enabling the DB2 server instance to directly access the data file that BL_DATAFILE= specifies, this option facilitates use of the DB2 LOAD command. For more information about the LOAD command, see the bulk-load topic in the DB2 under z/OS section.
Sybase IQ: BL_CLIENT_DATAFILE= is the client view of the data file.
See Also |
To specify the path from the client, see the BL_DATAFILE= Data Set Option [DB2 for UNIX and PC] or the BL_CLIENT_DATAFILE= Data Set Option.
BL_REMOTE_FILE= Data Set Option
Bulk Loading for DB2 Under UNIX and PC Hosts
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.