Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile
• My SAS

• Print  |
• Feedback  |
• Share

  • E-mail
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

In Version 7 and 8 of the SAS/ACCESS Interface to Sybase, you can
no longer execute multiple SELECT statements within PROC SQL Passthough.
You were able to do this in Version 6.  An example of a statement that
will fail:

  create table work.temp as
    select *
      from connection to sybase

    (    select * into #syso from sysobjects where type='U'
         select * from #syso o, syscolumns c
         where o.id=c.id
     );

You will receive:

    ERROR:  Error in result set.

There is a fix that is available for Solaris running SAS 8.1 which is
available at:

   ftp.sas.com/techsup/download/maint/access/sybase/SOL2/8.10

and a fix that is available for HP running SAS 8.1 which is available
at:

   ftp.sas.com/techsup/download/maint/access/sybase/HPU8/8.10

The instructions for installing the corrections are located in the
readme.into file in the directory referred to above. There is currently
no fix for other Unix platforms.



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#004321

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at: