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.