SCD Stage using a DB sequence

deepticr · Post by **deepticr** » Tue May 12, 2009 11:31 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed May 13, 2009 12:29 am

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

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

vdr123 · Post by **vdr123** » Thu Mar 18, 2010 9:02 am

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?

vdr123 · Post by **vdr123** » Thu Mar 18, 2010 9:03 am

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?

shails · Post by **shails** » Thu Mar 18, 2010 3:32 pm

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

vdr123 · Post by **vdr123** » Fri Mar 19, 2010 3:08 pm

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

Can admin clean it up?

chulett · Post by **chulett** » Fri Mar 19, 2010 5:12 pm

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.

deepticr · Post by **deepticr** » Fri Mar 19, 2010 10:03 pm

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=