When you access a
data source by using the FEDSVR engine, you can specify
SAS data set options in a DATA step or SAS procedure. SAS
data set options apply only to the table on which they are specified. The SAS data set options
that you can use depend on the data
source. Only a subset of the data set options that are provided by SAS are supported for
the FEDSVR engine.
This example shows how to apply the DBCOMMIT= data set option. The DBCOMMIT= data
set option causes an automatic commit (a permanent writing
of data to the
DBMS) after a specified number of rows have been processed.