Date: Fri, 12 Mar 2010 13:59:00 -0500
Reply-To: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject: Re: SAS SQ pass through to update a table in sybase based on a
Content-Type: text/plain; charset="us-ascii"
Sybase won't understand the "...work.tmp..." path that you are passing thru to the Sybase compiler. Remember that Sybase is executing the query much as if you were submitting it as a shell script in the RDBMS environment.
This disconnect between SAS SQL and an RDBMS doesn't have a general solution as yet, at least one that I've seen work well, but a couple of workarounds might solve the problem. If you have access to the RDBMS server environment, you may be able to create a tmp table. For a relatively small number of values in work.tmp, you may be able to assign them to a macrovariable list.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Frank Albany
Sent: Friday, March 12, 2010 12:12 PM
Subject: SAS SQ pass through to update a table in sybase based on a local table
I am trying to update a table in sybase based on a table in my work
connect to sybase (user= pass=xxxx);
execute (update log_sheet as a
where a.id in (select b.id from work.tmp asb)
) by sybase;
disconnect from sybase;
It does not work. I know you can create a temp table in sybase and access
it. Does anyone have a better solution?
Thanks in advance for your help.