DSXchange

That suggests that the username/password in the command is incorrect, or that the login/security service (in the services tier - the machine where WAS is installed) is not running/inaccessible.

Tip: avoid naming your routines with names beginning with "DS".

Let this prefix be used only for out-of-the-box routines.

DataStage has within itself Resource Estimator and Performance Analysis tools. Performance Analysis does, if I recall correctly, show PIDs.

synsog wrote:We need to do this via unix only.

Why?

Why did you bother buying the DataStage tool?

Assuming you have version 8, you can use the Resource Estimation tool (on the toolbar of Designer client).

Is the DATE column nullable in the target?

Looks like there was a problem installing MKS Toolkit while you were installing DataStage (as part of Information Server install). Go back to your install logs to determine what went wrong and where.

Quite easy. There's an option called Identify Flat File in the Tasks menu when you're in the Import Metadata workspace (from the Home pillar menu). This builds metadata information into a file called QETXT.INI. Apart from that, just identify the parent directory as a data source, and use the Identif...

The structure of XMETA is not documented in the public domain.

Welcome aboard.

Research the Slowly Changing Dimension stage.

India2000 wrote:I have a routine call DSuserstatus( Arg1)

I doubt it. There's no such routine.

Import the table definition. Specify fixed width. Specify column widths of 5,1,6 (or whatever is correct). Define "proper" column names. Use that table definition for the Format as well as the Columns tab. All will be well.

Does the box just ask for a default (e.g. OK) response? If so you can try the old trick of redirecting stdin from /dev/null (or .\NUL).

Use the Monitor in Director.
Double click on any component - its PID should be displayed amongst the other information.

You're more likely to find anything that exists at Fix Central.