DSXchange

DOS /C "dsjob -ljobs projectname" The DOS command causes an operating system shell to be opened, the /C switch specifies to return when the command is done. If your PATH environment variable does not include the DataStage bin folder then you will need to specify the full pathname of dsjob...

Show us what you did (the actual expression, and the source and target data types) when you were handling null.

That's odd, because there's a "started" message in the sequence log and there are more than three minutes between that and the warning event. Could anyone perhaps have tried to recompile the job in this time? Can you please post detail of the "job run requested" event for this in...

I like to use sequence and job parameters (or Parameter Sets in version 8 are even better). The sequence can pick up parameter values from pretty much anywhere, with a variety of techniques. One I like a lot is when the values are in a database table to run a server job to retrieve them and place th...

I don't see any error (event starting with ##E).

Forward slashes? I don't think so.

If you are using version 8.1, you can use the new DB2Z stage.

What does the job log of job J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.AAA reveal?

Does this bug still exist in version 8.1?

The DataStage API functions remain viable in version 8.1; you can download ETLstats and adapt its techniques. If you have it and you are generating operational metadata, then you can use Metadata Workbench to perform these analyses. HOWEVER, to have this work generically, you need a consistent namin...

sasidhar_kari wrote:Hi
I had reframed my statement. Can any one clarify the issue

Regards
Sasi

Clarification: it's a stupid requirement.

... including "resist stupid requirements".

The BASIC Transformer stage in a parallel job is not the same stage type as the Transformer stage in a server job. Your main problem is that you assumed that it is. In parallel jobs the database stages themselves support reject links, and it is there that sqlcode (only, as far as I am aware) is capt...

Use stage tracing (from the Tracing tab of the Job Run Options dialog) to capture statistics about the Transformer stage(s). Since you have provided no information about the job design there's not really much advice we can sensibly give. One solution that may be suggested by the collected statistics...

Use stage tracing (from the Tracing tab of the Job Run Options dialog) to capture statistics about the Transformer stage(s). Since you have provided no information about the job design there's not really much advice we can sensibly give. One solution that may be suggested by the collected statistics...