Usage Note 6327: SQL Pass-Through to Sybase EXECUTE statement allows only one statement
When you use multiple statements within an EXECUTE statement with
SAS/Access Interface to Sybase's SQL Pass-Through facility, they may
be ignored or you may get an error message.
The workaround for this is to put the multiple statements in a stored
procedure and then put the stored procedure name in the EXECUTE
statement.
Multiple statements worked in the EXECUTE statement in SAS 6.12.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#006327
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Sybase | 64-bit Enabled Solaris | 8 TS M0 | |
| 64-bit Enabled HP-UX | 8 TS M0 | |
| HP-UX | 8 TS M0 | |
| Tru64 UNIX | 8 TS M0 | |
| 64-bit Enabled AIX | 8 TS M0 | |
| AIX | 8 TS M0 | |
| Solaris | 8 TS M0 | |
*
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: | Usage Note |
| Priority: | high |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> Sybase
|
| Date Modified: | 2002-04-30 11:57:19 |
| Date Created: | 2001-11-20 08:29:28 |
