Previous Page | Next Page

Data Set Options for Relational Databases

BL_DB2CURSOR= Data Set Option



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

Syntax
Details
See Also

Syntax

BL_DB2CURSOR='SELECT * from filename'


Details

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.


See Also

BULKLOAD= Data Set Option

Previous Page | Next Page | Top of Page