I am trying to optimize an sql and my dba suggested
SET CURRENT DEGREE = any; but couldn't tell me where to code the line. Also, the sql is embedded in SAS.
Proc SQL NOPRINT STIMER;
Connect TO DB2(SSID=zt01)
SET CURRENT DEGREE = 'ANY';
CREATE Table MTD_Flows as
SELECT * FROM CONNECTION TO DB2 (
s.cola as x
,s.colb as y
,s.colc as z
Doesn't work. I've tried before the select and after the full select. Doe anyone know where it would be syntactically correct?