Focal Point
[CLOSED] SQL Passthru left outer join

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/791106735

September 30, 2010, 11:30 AM
DLR
[CLOSED] SQL Passthru left outer join
I am trying to do a SQL passthru with a left outer join. Webfocus does not seem to like the (+) after the option file in the where statement. Can anyone help me with the correct syntax.

Thanks!!

Diane

This message has been edited. Last edited by: Kerry,


WF 8.1.04
September 30, 2010, 02:52 PM
BlueZone
Diane - We have done plenty of OJs on our end in DB2 without issues. It would be more helpful if you can post your SQL and the error notes.

While at it, please also update your profile to identify your platform, db etc. The error/fix may be specific to your particular setup.


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music