SUPPORT / SAMPLES & SAS NOTES
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 | |
| 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 | |||