Advanced Topics |
Default value: | 0 |
Syntax | |
Details |
Syntax |
DDBLOCK= 0|1 |
causes the interface view engine to create an intermediate file (spool file), which holds the data to be processed by the SAS program.
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.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.