Hi All
We are trying to extract data from Siebel 7.x using the Siebel PACK 3.0 with DataStage version 7.0
When the plugin generates the SQL for the join we get the following:
Select t1.row_id, t2.row_id, t2.par_oud_id from s_org_int t1, s_org_int t2 where t1.row_id = t2.par_oud_id (+)
When we run the sql in DB2 we get an errorat the ")" of the '(+)'
The sql look like oracle sql.
Has someone came across this?
How did you resolve it?
I logged it with support, I'm just trying all options to find a work around in the interim.
Siebel Pack 3.0 direct access component gen incorect SQL
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: