SUPPORT / SAMPLES & SAS NOTES
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 | ||||