Specifies whether to delete the data file that the SAS/ACCESS engine creates for the DBMS bulk-load facility.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | none |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | Oracle |
| See: | BL_CONTROL= data set option, BL_DATAFILE= data set option, BL_DELETE_DATAFILE= data set option, BULKLOAD= data set option |
Table of Contents
deletes only the data file that the SAS/ACCESS engine creates for the DBMS bulk-load facility.
does not delete the data file.
Specifying 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 datasets library=x;
delete 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 datasets library=x;
delete 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 datasets library=x;
delete 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 datasets library=x;
delete test6;run;
run;
data x.test6 ( bulkload=yes bl_delete_only_datafile=YES bl_delete_files=NO );
c1=1;
run;
x dir BL_TEST6*.*;