Data Set Options for Relational Databases

BL_TRUNCATE= Data Set Option

Specifies whether the HP Neoview Transporter truncates target tables (when loading) or target data files (when extracting) before job processing begins.

Default value:	NO
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	HP Neoview

Syntax
Syntax Description
Details
See Also

Syntax

BL_TRUNCATE=YES | NO

Syntax Description

YES: specifies that the HP Neoview Transporter deletes data from the target before job processing begins.
NO: specifies that the HP Neoview Transporter does not delete data from the target before job processing begins.

Details

To specify this option, you must first set BULKEXTRACT=YES.