SybaseIQ and SAS Enterprise Guide

[ksamm]

I have a number of large SybaseIQ SQL scripts (5000+ lines each). The READ statement for each contains a number of parameters. Is there a way to execute the READ through the Proc SQL procedure using the SAS/ACCESS for SybaseIQ interface?

many thanks in advance

K

[SASKiwi]

Can you post an example of a SybaseIQ READ statement? Normally non-standard SQL can be executed via SAS's PASSTHRU EXECUTE statement.

[ksamm]

Thanks for looking at this !!!

parameters parm1 parm2
read ‘’ {source}
[parm1]
[parm2]
{output}

[SASKiwi]

Here is how you do an EXECUTE statement. All you need to do is put your Sybase code inside the brackets. Does this produce a result set by the way? If so then you may need to take a different approach.

documentation.sas.com/?docsetId=acreldb&docsetTarget=n0pj5uu3i328pmn1fackclh2xnd9.htm&docsetVersion=...

[ksamm]

Thanks SAS Kiwi,

Yes it produces a very large result set. Also, inserting the code between braces is not practical because as I mentioned, some of these queries are 5000+ lines long.

regards

K

[SASKiwi]

You could wrap the SQL code into an SQL stored procedure, then call that. You will also need to create a temporary table or view instead of producing a result set and then query the table / view in a following "normal" SQL passthru query.

[ksamm]

Good idea !!  This sounds feasible, I'll give it a go on Monday and let you know how it goes.  However I think there is still one potential issue which I forgot to mention earlier.  Some of the parameters to the SQL script need to bee macro variables.  

[SASKiwi]

Shouldn't be a problem. The usual hassle is most databases require parameters to be wrapped in single quotes but this technique gets around that problem:

%str(%')&MyMacroVar%str(%')