DSXchange

Use the IsValid() function.

You are using ARG1 in your routine called NB. But, when invoking that routine, you are not passing any actual value to it.

DataStage is also on a server. How do you plan to read the file, given that you have its name?

will put the most recently modified CSV file name in the first line of the output - you can easily parse it from there.

Yes, but the Lookup stage will need four reference inputs.

2377 is not a pid, it is a job number.

This lock is usually taken if the job is open in Director log view (or has been opened by a now-defunct process).

It is locks that you need to address, not indexes or processes.

A simple DIR command will get the file name for you, but which file name?

Hi Taufik, You could write a BASIC routine to get the file name and populate the column for Server jobs. Else you could design a job to get the file name by using the "Stage uses Filter Command" and then pass that on. Hope this helps. M Would you like to elaborate on both of those, but particularly...

Not in server jobs.

Send wads of money to IBM and they'll do it for you.

We're just using DataStage (Not Information Services Director etc). Yes you are. I'm presuming we need "dsrpcd" to be in the process list This is the listener for DataStage client connections. Its presence is sufficient to indicate that the DataStage server is "up". There are no other mandatory pro...

On the Outputs tab of the Match stage, drop down the list of link names, select your reference residuals link, and verify that the Mapping tab contains a complete set of column mappings.

Quotes handling in parallel jobs. Search the forum for more information.

What particular information? The fact that the reject link was used is a warning entry in the job log. The row count on any link is stored in one of the records in the status table for the job. Both items of information are retrievable using the DataStage API, so there is no need to know precisely w...

Welcome aboard. In a Transformer stage keep track of the most recently encountered section (use a stage variable) and direct any non-section line to the appropriate column of the output. Use an output constraint to avoid processing empty and comment lines. Use the File Name property (which the Seque...

You should be able to select them from Quick Find (or maybe Advanced Search), in which you should be able to select all the executables you need.

This feature is a little publicized yet long-awaited one. Prior to version 8 you had to work the way Craig indicated.