DDBLOCK= Data Set Option

Suppresses the creation of an interface spool file.

Default: 0

Syntax

DDBLOCK= 0 | 1

Syntax Description

0
causes the interface view engine to create an intermediate file (spool file), which holds the data to be processed by the SAS program.
1
suppresses creation of the spool file, assuming that only one user is accessing the database table or that the database table is locked by some method separate from SAS.

Details

SAS and CA-Datacom/DB use different locking mechanisms. The interface view engine compensates by creating a spool file of static data, which can adversely affect performance. The DDBLOCK= data set option suppresses creation of the spool file and lets static data be provided another way.