topic Return plan file from a DB via a passthrough query. in SAS Programming

Return plan file from a DB via a passthrough query.

kruzewski — Thu, 21 Jun 2012 19:16:01 GMT

I am trying to return a plan file for a query in SAS...How do I take the results and through it into some type of sas object or txt file????

Re: Return plan file from a DB via a passthrough query.

shivas — Fri, 22 Jun 2012 03:51:29 GMT

Hi,

Try this...Hope it helps..

proc printto log='output-file.txt' ;

run;

options fullstimer;

/*SAS Code or Passthrough code*/

proc printto;

run;

Thanks,

Shiva

Re: Return plan file from a DB via a passthrough query.

kruzewski — Fri, 22 Jun 2012 13:39:25 GMT

This will only print the log with SAS's execution times, etc... I am trying to get the plan from the DB by using something similar to the below

proc sql;

connect to netezza as dbcon

(server=netezzaServer database=myDB authdomain=netezzaAuth);

execute(

EXPLAIN SELECT

);

quit;

Re: Return plan file from a DB via a passthrough query.

Tom — Sat, 23 Jun 2012 19:40:42 GMT

Does NETEZZA have syntax for outputting the result of EXPLAIN into a dataset? For example with Oracle you can somethings format things as queries from the special null dataset called DUAL.