Usage Note 40422: Functionality is added to SAS/ACCESS® Interface to Aster nCluster to use control characters for delimiter and quote characters when bulk loading
 |  |  |  |  |
Functionaly is added to SAS/ACCESS Interface to Aster nCluster to use control characters for the delimiter and quote characters when bulk loading.
New data set options
BL_ESCAPE=
This option sets the escape character that is used by nCluster_loader.
BL_QUOTE=
This option sets the quote character that is used by nCluster_loader.
BL_USE_NULL= YES/NO
Special CONTROL entries for BL_ESCAPE, BL_QUOTE, and BL_DELIMITER
You can use the following CONTROL entries for nCluster_loader escape, quote, and delimiter characters to load data that would otherwise fail to load because it contains standard characters:
CONTROL = Crtl-K
CONTROL1 = Crtl-L
CONTROL2 = Crtl-G
Click the Hot Fix tab in this note to access the hot fix for this issue. Applying the hot fix enables you to use the new functionality.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Aster nCluster | 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 | |||
| Linux | 9.2 TS2M3 | |||
| Linux for x64 | 9.2 TS2M3 | |||
A fix for this issue for SAS/ACCESS Interface to Aster nCluster 9.21_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B93.html#40422| Type: | Usage Note |
| Priority: | high |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> AsterData |
| Date Modified: | 2010-07-27 15:16:31 |
| Date Created: | 2010-07-22 09:22:30 |