DSXchange

The account name is checked against the UV.ACCOUNT and UV_SCHEMA tables by the import process. Assuming you got it right in your import command, one of these may lack the required information. Can you import using the Manager client? Can you please post the actual command line that you used?

You seem to be re-inventing the Copy stage. I guess you're working towards something more than that. Is that really all you did? Can you post the code that was used?

What else is happening on the server? I recall one site who ran DS on their Primary Domain Controller (!) - this error occurred many times!

Here's a handy trick (though you need to be on 7.5): you can right mouse click on the warning message itself, and create a message handler from the context menu. Neat!

And you're certain that you're working in a Parallel job? The behaviour you describe would occur if you were working in a Server job.

Check for read and execute permissions to all directories in the path, as well as the library itself.

If you really want to nail it you could modify the scripts that QualityStage runs, to add timing points to them. This would help you to identify the hot spots. How may rows were processed in the development environment? What other activities were occurring at the time on the production machine?

Again I'm with Roy. There's no cost in signing up - you can see the list of forums without signing up. Maybe making just the FAQ available without sign-in would be ok.

I too prefer the testimonials forum as the appropriate place.

Sounds like your workaround needs to be a DSX "cutter". Export the entire project, then keep only the header, the job and the job executable. And, of course, any dependent objects, including routines and routine executables.

Layout of a DSX (or XML) export file is easily understood by inspection.

It was UniVerse up to version 5.2 of DataStage, which was built on version 9.6 of UniVerse. Since version 6.0 it has not been UniVerse. Close, but not exactly the same. Make sure you don't read the most current UniVerse manuals (version 10.1) but, instead, read the version 9.6 manuals. These are clo...

Probably easier to use a shell script involving the sed command.

What is the precise data type of this column in the database table? Date or TimeStamp? Different databases handle this differently - some (such as Oracle) don't differentiate, while others do. What this means mostly is that you can't assume that what works with one database will work with another. D...

Beware, no matter which type of SCD you choose to implement, that you heed the possibility that other applications may also update tables in the target. You need to check, as part of the preliminaries of each (daily?) run, the next available key value.

Many sites develop their own standards. If you work as a consultant, you need to learn and conform to those standards. More senior consultants advise on standards for start-up sites. Each has his or her own preferences. There are no "standard" standards. There is - or, at least was - a "best practic...