DSXchange

The "material" in question comes with the product. Are you working somewhere that you have access to DataStage? There isn't much in the way of a facility to learn on your own without any kind of product access, unfortunately. There's no 'student' or 'trial' version. There is, however, a ve...

Just to make sure my concern is clear - there is no 'order' within a database table based on how you loaded the data. This is much the same concern we have when someone says they need the "first" record from the table. So if some report needs each parent record followed by all of the child...

Post the contents of the "control" file, the one with the .ctl extension.

All you've said so far is "it doesn't work" and no-one can help you from that. What doesn't work about it? What is the actual trigger expression? You've mentioned 'script' and 'routine' for the problem, which is it? Does it not get triggered or it runs and doesn't do what you expect or ???...

What the heck does any kind of "report requirement" have to do with how you load records into database tables?

They are completely unrelated.

You'll have to figure that one out. That or post enough information so we can help.

There's no magic. You document what the Server job is doing and rebuild it from scratch as a Parallel job.

If you insist on a single job, try to order the loads so all parents go first then all children - much like two jobs in one. And use a single target stage. Trying to get things to arrive in your original order would be both... cumbersome... and not really worth the effort, IMHO. Is there a particula...

As noted, they are independant, so the fact that one 'fired' doesn't affect any other trigger... unless we're talking about an 'Otherwise' one, of course.

You shouldn't need NLS for this. What you will need, however, are the characterset of both the source and target so that NLS_LANG can be properly set.

Ah, Data Element... thanks for the clarification Ernie.

I guess it depends on your definition of "out of whack". :wink: For actual XML data, that is exactly what those characters should be converted to to make them "safe". Stopping it is simple - there is a column called Data Type (I believe, can no longer check) that is normally blan...

Probably more likely a 0 or 1 but it should be pretty easy to find, regardless.

Of course.

As noted, not really possible. This question has been asked and answered in the past to the same effect. People like Kim Duke have posted their 'workaround', I suppose you could call it, perhaps it would be of interest:

viewtopic.php?t=132959