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.
I've tried:
Proc SQL NOPRINT STIMER;
Connect TO DB2(SSID=zt01)
SET CURRENT DEGREE = 'ANY';
CREATE Table MTD_Flows as
SELECT * FROM CONNECTION TO DB2 (
Select
s.cola as x
,s.colb as y
,s.colc as z
.
continue....
Doesn't work. I've tried before the select and after the full select. Doe anyone know where it would be syntactically correct?
Joined: 06 Jun 2008 Posts: 8280 Location: Dubuque, Iowa, USA
Try it this way:
Code:
OPTIONS SET="CURRENT DEGREE = 'ANY'";
Proc SQL NOPRINT STIMER;
Connect TO DB2(SSID=zt01)
CREATE Table MTD_Flows as
SELECT * FROM CONNECTION TO DB2 (
Select
s.cola as x
,s.colb as y
,s.colc as z
This is not tested since I don't have DB2 on site but from my reading of the SAS manual SET is an options statement, not part of PROC SQL.