DSXchange

No need, continue to use the 9i client for both 9i and 10g database access. It will work fine.

No. Take the .dsx and import it into your project. Then either run the job or dissect the imported code.

First get it working from the command line, then automate it. And it would have helped to post the actual expanded command line you are executing so we don't go through the issues one by one... by one. Parameters need to be passed in as 'value pairs'. So, the parameter name, an equal sign and lastl...

Can't really help other than to suggest you dump the cursor if all you need to know is if it ran OK or not. For that, simply raise an error when there is a problem, DataStage will notice.

That converts it to an internal date in DataStage. You'd then need the reverse using DateToString with '/' if you really needed that external format.

Your mask needs to match your data to work correctly, including the delimiters. Try: "Stringtodate(datecolun,"%yyyy-%mm-%dd)".

If anyone did, they would have posted. Have you checked the docs - the stpstage.pdf document, specifically?

An Invocation ID needs to be appened to the Job Name with a dot, not a pipe.

Why the heck not just simply use the Notification Activity stage? The 'Tester' routine is just that - for testing.

Has this ever worked? What is "id"? You just need the Project and the Job Name as the last two parameters to dsjob.

From DataStage, the answer is the 'Usage Analysis' tool from the Manager. That assumes you've been using generated table metadata and haven't done anything bad that broke that linkage. Or you can use one of Chuck's tools from www.anotheritco.com to parse through the dsx and build you a list of all o...

Did you try searching? Doing an Exact Match search on "Import consumed only" should turn up the bajillion times this has been discussed.

It's never been available on the palette by default, you have to specifically customize the pallet to add it.

No, you just need to ensure that PrjName is set appropriately for this job.

The 'dsjob' command should also include the Project of the job being run.