BL_DELETE_DATAFILE= Data Set Option

Specifies whether to delete only the data file or all files 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)
Alias:	BL_DELETE_FILES= [Oracle]
Default:	YES
Requirement:	To specify this option, you must first set BULKEXTRACT= YES or BULKLOAD=YES.
Data source:	Aster nCluster, DB2 under UNIX and PC Hosts, Greenplum, HP Neoview, Netezza, Oracle, Sybase IQ
See:	BULKEXTRACT= data set option, BL_CONTROL= data set option, BL_DATAFILE= data set option, BL_DELETE_ONLY_DATAFILE= data set option, BL_USE_PIPE= data set option, BULKLOAD= data set option

Syntax

Details

Examples

Example 1: Delete All Files

Example 2: Retain All Files

Syntax

BL_DELETE_DATAFILE=YES | NO

Syntax Description

YES: deletes all (data, control, and log) files that the SAS/ACCESS engine creates for the DBMS bulk-load facility.

NO: does not delete these files.

Details

DB2 under UNIX and PC Hosts: Setting BL_DELETE_DATAFILE=YES deletes only the temporary data file that SAS/ACCESS creates after the load completes.

Greenplum: When BL_DELETE_DATAFILE=YES, the external data file is deleted after the load completes.

HP Neoview, Netezza: You can use this option only when BL_USE_PIPE=NO.

Oracle: When BL_DELETE_DATAFILE=YES, all files (DAT, CTL, and LOG) are deleted.

Examples

Example 1: Delete All Files

In this example the default is YES, so all files are deleted.

libname x oracle &connopts
proc datasets library=x;
  delete test1;run;
data x.test1 ( bulkload=yes );
c1=1;
run;
x dir BL_TEST1*.*;

Example 2: Retain All Files

No files are deleted in this example.

libname x oracle &connopts
proc datasets library=x;
  delete test2;run;
data x.test2 ( bulkload=yes bl_delete_files=no );
c1=1;
run;
x dir BL_TEST2*.*;