View previous topic :: View next topic
|
Author |
Message |
ywheeler
New User
Joined: 10 Nov 2006 Posts: 19 Location: New York
|
|
|
|
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?
Thanks. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 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. |
|
Back to top |
|
|
ywheeler
New User
Joined: 10 Nov 2006 Posts: 19 Location: New York
|
|
|
|
Thank you. |
|
Back to top |
|
|
|