Problem Note 11266: SQL join using LIKE syntax on variables fails with Illegal Instruction
error
A join in an SQL statement that uses the like operator may cause an
Illegal Instruction error. This is the result of a memory leak and can
occur with only moderate amounts of data.
On Unix systems, the following message may be displayed:
Segmentation Violation In Task ( DATASTEP ]
Fault Occurred at [0x103ebc34(?)]
Operating System and Release Information
| SAS System | Base SAS | Microsoft Windows NT Workstation | 8.2 TS2M0 | |
| OpenVMS VAX | 8.2 TS2M0 | |
| Solaris | 8.2 TS2M0 | |
| 64-bit Enabled Solaris | 8.2 TS2M0 | |
| z/OS | 8.2 TS2M0 | |
| IRIX | 8.2 TS2M0 | |
| OS/2 | 8.2 TS2M0 | |
| Linux | 8.2 TS2M0 | |
| HP-UX | 8.2 TS2M0 | |
| ABI+ for Intel Architecture | 8.2 TS2M0 | |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | |
| CMS | 8.2 TS2M0 | |
| OpenVMS Alpha | 8.2 TS2M0 | |
| 64-bit Enabled AIX | 8.2 TS2M0 | |
| AIX | 8.2 TS2M0 | |
| Tru64 UNIX | 8.2 TS2M0 | |
*
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: | medium |
| Topic: | SAS Reference ==> Procedures ==> SQL
SAS Reference ==> SQL
|
| Date Modified: | 2003-11-17 15:25:21 |
| Date Created: | 2003-11-12 11:07:01 |
