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

BL_DELETE_ONLY_DATAFILE=YES | NO

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.

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

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*.*;