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 | ||
A fix for this issue for SAS/ACCESS Interface to Netezza 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A7C.html#59879A fix for this issue for SAS/ACCESS Interface to Netezza 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Z29.html#59879
"ERROR: Failed to open specified BL_DATAFILE" occurs when you use the DATA step to read Netezza tables into SAS®, and the second data file is not opened.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-02-16 13:45:36 |
| Date Created: | 2017-02-02 14:13:23 |