DSXchange

The loading is like "insert without clearing the table" and in other job its like"clear the table then insert ". What "other job"? An "OCI to OCI" design is the slowest way you could solve this particular problem, especially if all you have is a "simple one to one mapping". For pure inserts conside...

Besides the fact that this topic is 'Resolved' did you miss the requirement where the sequence's value needs to go to two targets?

cosec wrote:and all my target tables are sorted except for one.

What is that supposed to mean? Is it a 'DB2 thing' where tables can be... 'sorted'?

Or are we just talking about doing an initial load sorted in a fashion that matches the PK of the target table?

No, another place. That's not an Administrator command, but an operating system command.

That's not alot to go on. Only advice at this stage - set them back to their original values. Way too many variables involved. We don't know anything about your network, job design, source, target or the nature of the transformations being done. We don't know what kind of indexes or constraints are...

I posted some thoughts to your other post on this subject. No need to post the same thing twice. If you don't like how the first one came out - please edit it, don't create another.

Short answers:

1) There's no tool for that that I've ever heard of.
2) No.

Post your code wrapped in [code] tags. Explain what you built. Can't help otherwise.

The only 'tool' I've heard of is the property of IBM and is only for use by their consultants during a migration. Actually, I'm thinking of a Server to PX conversion tool. No clue if they've also got one for INFA. In either case, there won't be anywhere near a 100% conversion, except for the simples...

Send the Detailed problem you are having converting Source Date format "MMDDYY" to "YYMMDD". What have you tried?

Search the forum for examples of the StringToDate function.

ps. Your additional info line and post body don't match as to what you are trying to do.

As noted, preferred for what?

So... it now stops at 99% without any obvious error? That typically means some kind of issue with a 'post install' script or process. Unfortunately, I'm not sure anyone other than the vendor could help with that. Which would mean a call to your Support Provider. You've checked all the 'normal' stuff...

We try.

Welcome Aboard. :D Anything 'different' about your version of Windows? How old was your previous version of DataStage? Older versions used to work on Windows XP Home but now it requires XP Pro - however, don't think that's the problem as it shouldn't even have let you start the install. This seems t...

Of course, you'd need to give it an explicit value in the Administrator then as there would be nothing for the $ENV to pickup at runtime. Interesting thing to note re: the official documentation on this matter. The online help refers one to the Administrators Guide. In there, this process is discuss...

Thanks. As I noted, I have plenty of other solutions, was curious about MERGE specifically in this context. And even though I don't think I specifically said so, 'this context' was high-speed deletes, alternatives to 'normal' DML that would take ages to delete the million plus records (from multiple...