space
Previous Page | Next Page

Advanced Topics

DDBLOCK= Data Set Option



Suppresses the creation of an interface spool file.
Default value: 0

Syntax
Details

Syntax

DDBLOCK= 0|1

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.

space
Previous Page | Next Page | Top of Page