SUPPORT / SAMPLES & SAS NOTES
Problem Note 59879: The second data file is not opened when you use the DATA step and specify two BULKUNLOAD= data set options to read Netezza tables
 |  |  |  |  |
You might encounter the following error when using a DATA step to read Netezza tables into SAS® software:
ERROR: Failed to open specified BL_DATAFILE.
This error occurs under the following conditions:
- You assign a Netezza library.
- All the steps in the DATA step specify the BULKUNLOAD= data set option.
This problem occurs because SAS opens only the first BULKUNLOAD data file specified.
Here is example code that illustrates the issue:
libname nzlib netezza server=nz-server user=user-ID pwd=password database=nz-db schema=nz-schema;
data work.sm_test;
set nzlib.pm_1(bulkunload = yes
bl_datafile = '/tmp/PM_1_DATA.dat'
bl_use_pipe = no
bl_delete_datafile = no)
nzlib.PM_2(bulkunload = yes
bl_datafile = '/tmp/PM_2_DATA.dat'
bl_use_pipe = NO
bl_delete_datafile = NO );
run ;
set nzlib.pm_1(bulkunload = yes
bl_datafile = '/tmp/PM_1_DATA.dat'
bl_use_pipe = no
bl_delete_datafile = no)
nzlib.PM_2(bulkunload = yes
bl_datafile = '/tmp/PM_2_DATA.dat'
bl_use_pipe = NO
bl_delete_datafile = NO );
run ;
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Netezza | 64-bit Enabled AIX | 9.4_M3 | 9.42 | 9.4 TS1M3 | 9.4 TS1M5 |
| HP-UX IPF | 9.4_M3 | 9.42 | 9.4 TS1M3 | 9.4 TS1M5 | ||