DSXchange

Hi,

I was trying to work with SCD stage and configured it for type 1 functionality.
I created a database sequence which starts with 1 and increments by 1. In the surrogate key tab in the SCD stage, I set

Source Name = <DB sequence Name>
Database Type = Oracle
I keyed in the user name, password and the the server name as well.

Now, after I compile the job and try opening up the SCD stage-> surrogate key tab, I find the Database Type pointing to DB2 and not Oracle!!!

If I try to run the job then it gives me an error
"Library orchdb2op could not be loaded; Could not load "orchdb2op": The specified module could not be found."

And I think the orchdb2op is some library related to DB2 database. I don't know what to do. Could you please help me out with this?

Thanks

It's a cunning plan to force you to buy DB2.


Or it's a bug. Involve your official support provider.

Did you try to figure this out, I am having the same issues, it reverts to DB2, even after using ORACLE.
Is it a bug?

Did you try to figure this out, I am having the same issues, it reverts to DB2, even after using ORACLE.
Is it a bug?

Yes, its a bug in SCD stage. We faced the same issue in our project and support confirmed that its a bug.

FYI, the 2 duplicate post are not intentional, not sure how it happened.

Can admin clean it up?

vdr123 wrote:FYI, the 2 duplicate post are not intentional, not sure how it happened. Can admin clean it up?

Probably... unfortunately, it can be a common problem here.

I always check after I post if there's any "delay" in the submit process just in case. I double-check because you can delete your own posts as long as they haven't been replied to so right after it happens is the best time to nuke any extra post(s). Just so you know. For next time.

We are now using DataStage 8.1 and this problem seems to be addressed. But, now we are facing other issues while trying to implement SCD.

For details see:
viewtopic.php?t=132598&highlight=