Problem Note 40991: The SAS® System stops responding if you specify BULKLOAD=YES in PROC APPEND and you use SAS/ACCESS® Interface to Sybase IQ with Sybase IQ 15
 |  |  |  |  |
When you use SAS/ACCESS Interface to Sybase IQ with Sybase IQ 15, the SAS System stops responding if you use the APPEND procedure with the BULKDLOAD=YES option. To exit SAS, you must open a UNIX shell and submit the following kill command:
prompt > kill -9
This problem is caused by code similar to the following example:
libname x sybaseiq host=host-name server=server-name
database=database-name port=5000
user=user-id pass=password;
proc append base=x.class_one(bulkload=yes bl_use_pipe=yes dbcommit=10)
data=sashelp.class;
run;
This problem does not happen if you use the BL_USE_PIPE=NO option.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Note: This note does not apply to HP-UX or AIX operating environments. Currently, the BL_USE_PIPE=YES option is not available with SAS/ACCESS Interface to SYBASE IQ for these operating systems.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Microsoft SQL Server | 64-bit Enabled Solaris | 9.21_M2 | 9.2 TS2M3 | ||
| HP-UX IPF | 9.21_M2 | 9.2 TS2M3 | ||||
| Linux for x64 | 9.21_M2 | 9.2 TS2M3 | ||||
| Solaris for x64 | 9.21_M2 | 9.2 TS2M3 | ||||
A fix for this issue for SAS/ACCESS Interface to Sybase IQ 9.21_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B59.html#40991| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS SQL Server |
| Date Modified: | 2010-09-28 10:48:12 |
| Date Created: | 2010-09-22 11:25:24 |