Problem Note 40820: Errors occur when you use the BULKUNLOAD= option with the default Netezza delimiter or you use the BL_DELIMITER= option to customize the delimiter
The following error message might be issued when you attempt to use the BULKUNLOAD= data set option or the BULKUNLOAD= LIBNAME option with the default character delimiter (|) in SAS/ACCESS® Interface to Netezza:
ERROR: Invalid data format in BULKUNLOAD stream. Verify that the data
does not contain the delimiter
In addition, the following error occurs when you use the BL_DELIMITER= data set option to customize the delimiter:
ERROR: Invalid option name \.
The issue occurs because SAS/ACCESS Interface to Netezza only allows single- character delimiters. Therefore, you cannot use ASCII delimiters greater than 127.
Click the Hot Fix tab in this note to access the hot fix for this issue.
This hot fix enables you to use ASCII delimiters greater than 127. After you apply the hot fix, if you use a 7-bit ASCII character (a character less than 127) as a delimiter, you should use the actual character as the value for the option #40;for example, BL_DELIMITER="|") However, if you want to use an extended character as a delimiter, you must use the decimal number for that character in the option. For instance, if you use ASCII character 202 as a delimiter, the option will be BL_DELIMITER=202.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Netezza | Microsoft® Windows® for x64 | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 for x64 | 9.2 TS2M3 | |
Microsoft Windows Server 2008 | 9.2 TS2M3 | |
Microsoft Windows Server 2008 for x64 | 9.2 TS2M3 | |
Microsoft Windows XP Professional | 9.2 TS2M3 | |
Windows 7 Enterprise 32 bit | 9.2 TS2M3 | |
Windows 7 Enterprise x64 | 9.2 TS2M3 | |
Windows 7 Home Premium 32 bit | 9.2 TS2M3 | |
Windows 7 Home Premium x64 | 9.2 TS2M3 | |
Windows 7 Professional 32 bit | 9.2 TS2M3 | |
Windows 7 Professional x64 | 9.2 TS2M3 | |
Windows 7 Ultimate 32 bit | 9.2 TS2M3 | |
Windows 7 Ultimate x64 | 9.2 TS2M3 | |
Windows Vista | 9.2 TS2M3 | |
Windows Vista for x64 | 9.2 TS2M3 | |
64-bit Enabled AIX | 9.2 TS2M3 | |
64-bit Enabled HP-UX | 9.2 TS2M3 | |
64-bit Enabled Solaris | 9.2 TS2M3 | |
HP-UX IPF | 9.2 TS2M3 | |
Linux | 9.2 TS2M3 | |
Linux for x64 | 9.2 TS2M3 | |
*
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2010-09-10 10:47:28 |
Date Created: | 2010-09-08 12:42:21 |