Data Set Options for Relational Databases |
Specifies the client view of the data file
that contains DBMS
data for bulk load.
Default value: |
the current directory
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Sybase IQ
|
BL_CLIENT_DATAFILE=path-and-data-filename
|
- path-and-data-filename
-
specifies the file that contains the rows of data to load
or append into a DBMS table during bulk load. On most platforms, the default
filename takes the form BL_<table>_<unique-ID>.dat:
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. |
dat |
specifies the .DAT file extension for the data file. |
To specify this option, you must first set
BULKLOAD=YES.
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.