Data Set Options for Relational Databases |
Specifies a string that contains a valid DB2 SELECT statement
that points to either local or remote objects (tables or views).
Default value: |
none
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS Support: |
DB2 under z/OS
|
BL_DB2CURSOR='SELECT * from filename'
|
To use this option, you must specify BULKLOAD=YES and
then specify this option.
You can use it to load DB2 tables directly from other DB2 and non-DB2
objects. However, before you can select data from a remote location, your
database administrator must first populate the communication database with
the appropriate
entries.
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.