SUPPORT / SAMPLES & SAS NOTES
Problem Note 43970: Errors occur when you use input() or put() in a JOIN operation with a database table in a remote library
 |  |  |  |  |
A Read Access Violation or Segmentation Violation error might occur when you use input() or put() in a JOIN operation with a database management system (DBMS) table in a remote library services (RLS) library using the SQL procedure. The error does not occur when you use the native database engine.
Here is an example of a Read Access Violation:
ERROR: Read Access Violation In Task [ SQL ]
Exception occurred at (0AFC6FEF)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)The following is an example of a Segmentation Violation:
Segmentation Violation In Task [ SQL ]
sqlcarg+0x07af0 -
/nas/dept/usm/S64/sasgen/dev/mva-v920m3f/sql/com/s64nd/sassqlp
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M3 | |||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M3 | |||
| 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 | |||
| OpenVMS on HP Integrity | 9.2 TS2M3 | |||
| Solaris for x64 | 9.2 TS2M3 | |||