06-21-2012 11:51 PM
Try this...Hope it helps..
proc printto log='output-file.txt' ;
/*SAS Code or Passthrough code*/
06-22-2012 09:39 AM
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
connect to netezza as dbcon
(server=netezzaServer database=myDB authdomain=netezzaAuth);
<insert fancy sql code here>
06-23-2012 03:40 PM
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.