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.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	none
Requirement:	To specify this option, you must first set BULKLOAD=YES.
Data source:	Oracle
See:	BL_CONTROL= data set option, BL_DATAFILE= data set option, option, BULKLOAD= data set option

Syntax

Details

Examples

Example 1: Delete Only the Control and Log Files

Example 2: Retain All Files

Example 3: Delete Only the Data File

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

Setting this option overrides the BL_DELETE_DATAFILE= option.

Examples

Example 1: Delete Only the Control and Log Files

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

Example 2: Retain All Files

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

Example 3: Delete Only the Data File

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