Siebel Pack 3.0 direct access component gen incorect SQL

[hkotze]

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.

[denzilsyb]

strange syntax.
while waiting for support, can you write your own SQL - user defined?

could it be a right outer join that is somehow specified in the plugin? Without the plugin, i cant offer much help.

[ray.wurlod]

It does look like Oracle syntax. Check with the vendor. It may have only been tested against Oracle, and only with five rows!