DSXchange

Got nothing to do with the 'sequential' stage and by 'object' the implication is that it is a database component, something you create to dole out sequential typically surrogate key values to (possibly) multiple processes. I don't believe you've ever specifically said what database you're working wi...

Please help us help you by providing enough details so we can. In addition to what Arnd asked, how are you 'running' this job?

That's the impression I got from googling around but I have no hands-on TD experience. Why not run this by your DBA?

Depends on the stage you're referring to.

And while bulk loader performance may be improved, don't forget to factor in the time it will take to rebuild the dropped index.

Simple enough to check if the two values are in sync, source one, look up the other and send the email when they don't match. How you do the final 'sync' is up to you and seems to me it depends on how you handle commits in the target. At every target commit point, you want to update and commit your ...

No worries, just wanted to double-check as the product is very version picky. That compiler, however, is on the "known to actually work with DataStage" list.

I'm sure someone will set you on the right track.

stuartjvnorton wrote:Compiler is Microsoft Visual C++ Express

What version? Meaning 2003, 2005, etc.

Pretty big IF Andy, but I think you are correct that you "should not" need a compiler in production with your IF heavily enforced. Not a Best Practice from what I've read here, but probably true.

An exact search here for DS_AUDIT would be a good place to start.

Somewhat lost regarding what it is you need to do. :? Are you saying that if there are records in the Oracle table, that you need to truncate the DB2 table and then write all of the Oracle records into the DB2 table? But if the source Oracle table is empty, then you need to do nothing on the DB2 sid...

True again! For some reason, had it stuck in my head that it only did one character - literally. Forgot about the whole matching list bit.

True, but assuming not, Convert is a perfectly valid solution.

Check out the Convert() function. Use it twice.