Sybase Options and Stored Procedures through SAS

SNLFAM1 — Tue, 04 Mar 2014 17:06:30 GMT

Is there anyway to use Sybase options (Ex. set showplan on) or Sybase Stored Procedures through SAS? Can you do this with a metadata defined libname to the database? Is it possible using the pass-through facility for Sybase? Can I get the results/log back in my SAS log, or in a SAS dataset, or to an external file?

I have looked at the "SASTRACE" option (SAS/ACCESS(R) 9.3 for Relational Databases: Reference, Second Edition) . That gives information about the 'translated' query that gets passed to Sybase and has a lot of good time statistics. I have also looked at the Sybase specific information (SAS/ACCESS Interface to Sybase), but that didn't seem to have anything. I did notice the DBCONINIT libname option which may be part of what I am looking for, but I can not tell from the documentation (DBCONINIT= Libname Option). The SQL Pass-Through EXECUTE statement (EXECUTE Statement) also looks promising, but I have not been able to get it to work the way I would like.

I am performing a lot of testing for our Sybase DBAs to confirm that the SAS interface is working the same as their ISQL sessions and would like to be able to hand them log/results that show items like the Sybase index that was used in the processing. There may be an easier way to do this, but right now, I am having to infringe on the DBAs time for these tests, and they do not have much/any to spare.

Thanks for any help!!

Shaun L.

Re: Sybase Options and Stored Procedures through SAS

jakarman — Tue, 04 Mar 2014 19:32:08 GMT

Hi again, You are doing a good job.

For Sybase you could do a explicit SQL pass through. As that is native Sybase SQL you should be able to do everything.

I think you are searching for "in database" products. SAS(R) 9.4 In-Database Products: User's Guide, Third Edition

But there Sybase is not mentioned.

Re: Sybase Options and Stored Procedures through SAS

Reeza — Tue, 04 Mar 2014 19:49:17 GMT

Not related to sybase at all, but have you tried options msglevel=i to get more information?

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

topic Re: Sybase Options and Stored Procedures through SAS in SAS Programming

Sybase Options and Stored Procedures through SAS

Re: Sybase Options and Stored Procedures through SAS

Re: Sybase Options and Stored Procedures through SAS