15399 - BL_SUPPRESS_NULLIF option added to suppress NULLIF for Oracle's bulkloader

Usage Note 15399: BL_SUPPRESS_NULLIF option added to suppress NULLIF for Oracle's bulkloader

A new option, BL_SUPPRESS_NULLIF, was added to suppress NULLIFs for bulkloading data into Oracle. The syntax is as follows:

BL_SUPPRESS_NULLIF = <_ALL_=YES | NO > | (<column-name-1=YES | NO > _ALL_ specifies that YES or NO applies to all columns in the table column=YES/NO specifies that the YES/NO applies to only the specific column. When NULLIF is suppressed, SAS numeric null is entered as 0.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Product Family	Product	System	SAS Release
Product Family	Product	System	Reported	Fixed*
SAS System	SAS/ACCESS Interface to Oracle	64-bit Enabled HP-UX	9.1 TS1M3
		Linux	9.1 TS1M3
		64-bit Enabled Solaris	9.1 TS1M3
		Microsoft® Windows® for 64-Bit Itanium-based Systems	9.1 TS1M3
		64-bit Enabled AIX	9.1 TS1M3
		Tru64 UNIX	9.1 TS1M3

* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#015399

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#015399

Type:	Usage Note
Priority:
Topic:	Data Management ==> Data Sources ==> External Databases ==> Oracle SAS Reference ==> LIBNAME Engines

Date Modified:	2005-10-10 08:53:25
Date Created:	2005-05-27 15:31:26