Previous Page | Next Page

Data Set Options for Relational Databases

BL_DELETE_ONLY_DATAFILE= Data Set Option



Specifies whether to delete the data file that the SAS/ACCESS engine creates for the DBMS bulk-load facility.
Default value: none
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Oracle

Syntax
Syntax Description
Details
Examples
See Also

Syntax

BL_DELETE_ONLY_DATAFILE=YES | NO

Syntax Description

YES

deletes only the data file that the SAS/ACCESS engine creates for the DBMS bulk-load facility.

NO

does not delete the data file.


Details

To specify this option, you must first set BULKLOAD=YES or BULKEXTRACT=YES. Setting this option overrides the BL_DELETE_DATAFILE= option.


Examples

BL_DELETE_DATAFILE=YES is the default in this example, so only the control and log files are deleted:

proc delete data=x.test3;
run;

data x.test3 ( bulkload=yes bl_delete_only_datafile=no );
c1=1;
run;

x dir BL_TEST3*.*;

Both options are set to NO in this example, so no files are deleted:

proc delete data=x.test4;
run;

data x.test4 ( bulkload=yes bl_delete_only_datafile=no bl_delete_files=NO );
c1=1;
run;

x dir BL_TEST4*.*;

Only the data file is deleted in this example:

proc delete data=x.test5;
run;
data x.test5 ( bulkload=yes bl_delete_only_datafile=YES );
c1=1;
run;

x dir BL_TEST5*.*;

The same is true in this example:

proc delete data=x.test6;
run;

data x.test6 ( bulkload=yes bl_delete_only_datafile=YES  bl_delete_files=NO );
c1=1;
run;

x dir BL_TEST6*.*;


See Also

BL_CONTROL= Data Set Option

BL_DATAFILE= Data Set Option

BL_DELETE_DATAFILE= Data Set Option

BULKLOAD= Data Set Option

Previous Page | Next Page | Top of Page