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).
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: none
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: DB2 under z/OS
See: BULKLOAD= data set option
Syntax
Details

Syntax

BL_DB2CURSOR='SELECT * from filename'

Details

You can use it to load DB2 tables directly from other DB2 and objects that are not DB2. However, before you can select data from a remote location, your database administrator must first populate the communication database with the appropriate entries.
Copyright © SAS Institute Inc. All rights reserved.