DSXchange

Two jobs with a Data Set (rather than a sequential file) will be even better in a parallel job.

Also that's BASIC code, not C++.

Where are you using this routine?

I can only suggest, frivolously, that it's a devious IBM marketing ploy to get you to buy DB2.

Nice one. Please ignore my earlier absolute "no".

You need to retrieve the value in one job called from a job sequence. The value can be stored in that job's user status area, or written to a file or to a hashed file. The job sequence can then obtain the value and supply it to the other job as a parameter value.

Welcome aboard. Do you have the DataStage xpsp2 patch installed?

We don't do "urgent" here. If you need urgent assistance sign up with your support provider for premium service, and learn the true cost of urgent. This is an all-volunteer site, on which people post as and when they can. I think you will need to create a routine to effect this validation; validati...

You can have more than one version of the client installed (make sure they are installed in different locations), and switch between them using the Multi Client Manager. You would also need to install Multi Client Manager from your DataStage CD.

NEVER enable 64BIT_FILES !!!!

This means that every hashed file you create will have (wasteful) 64-bit internal pointers, unless you specify the 32BIT option when creating them.

... permissions on your client machine, specifically.

Open Administrator client on Schedule tab. There you can set up (and test) the user ID that will be used for scheduling jobs.

There might be something in the Information Server reporting console, other than that there's nothing I can bring to mind. You could, of course, grab a screen shot of the progress summary page.

No, short of using an External Filter stage (which will run sequentially and slowly).

Does the later job use the same configuration file as that which was in use when the Data Set was created? Did you import the table definition from the Data Set and use that in the second job?