DSXchange

Ah. Then let me repeat this last little bit as I doubt this is anything DataStage and will fall squarely on Oracle's shoulders:

Would be worth running the whole situation by your DBA if you haven't already, see what they think might be going on.

It does, actually, with a Timestamp you have to include the time portion even if it is all zeroes. I always treat Oracle DATE fields as Timestamps in job and ensure a proper time portion.

Something I asked / noted in my reply.

Convert(CHAR(13),"",YourField)

So, same issue as noted in this thread? Which is fine, new problem = new post but usually not new poster.

Have you looked into using the 'SQL File' capability that the stage supports?

#2 would be fine if your source column is a string in the format noted - YYYY-MM-DD.

PhilHibbs wrote:How do I navigate this maze of twisty little passages, all alike?

Plugh!

Or that.

Picky, picky... spoil the whole thing, why don'tca?

Yes. You enable the Trigger Column option and whenever the value in that column changes, it spawns a new file. You just need to ensure it changes every X records. And the column does not have to be part of your output XML.

Exactly and not really sure why this seems to surprise people. It's pretty common for older releases of any software to let you 'get away' with something that they 'fix' or tighten up in the later releases, including more stringent testing of conditions like this. It's not so much something that doe...

First thing that jumps to mind is a stats / histogram issue. The day of the load the statistics may be out of whack and it isn't until later (in the night?) when the tables/indexes get analyzed that things get straightened back out. However, if your other loads don't specifically join to or otherwis...

Load = sqlldr and Replace = delete all rows from the target table before starting the bulk load, so you should be good there. If that's not happening, open a case with your official support provider. Perhaps there's a patch.

OK, I'll ask... did you try searching the forums? There were a number of hits when I did an exact search for your subject, did none of them help?