DSXchange

Use a Sort stage to partition and sort on elmt_i and node_i, and to generate a fourth column called key_changed using the Sort Key Change property. In the Transformer stage construct a stage variable that is derived as If key_changed Then name Else sv : "," : name Derive the output column name as sv...

Attend the Introductory class offered by IBM. Precisely this scenario is one of the lab exercises.

It's an incompleteness in the documentation. Get a copy of the "OEM 75 Manuals" (the Orchestrate manuals) from your support provider - they are more complete.

Probably not. It looks more like version 8 has a problem reading the export file from version 7.5. Get in touch with your support provider.

Probably not. It looks more like version 8 has a problem reading the export file from version 7.5. Get in touch with your support provider.

How are you trying to run the job?

In a fixed-width format file, the representation of NULL must exactly contain the same number of characters as the field. The OP seems to be complaining that the Char() fields are being padded with NUL characters, which is exactly the default behaviour for DataStage. The pad character is set by the ...

The OP has sent both a Private Message and a Private Email asking me to answer this message.
This post should prove instructive.

The highlighted message means that DSWaitForJob() returns immediately under either of the following two conditions: the job on the job handle has finished the job on the job handle has been started again after finishing on the same job handle (that is, without there having been a call to DSDetachJob...

Do you mean create a sequence, or use a sequence to generate values?

I did once publish a routine for doing that. Perhaps you could Search for it.

(It's here at least.)

chulett wrote:Sam Ting.

The man who invented the photocopier before migrating to Russia to invent the technique known as samizdat.

About the only way you can do this is to use the job's user status area. The upstream stage can set a value, a downstream stage can read it. However, ORAOCI9 stages are passive stages and can not do this; you will need to insert Transformer stages. Getting that variable into an OCI stage as you desc...

To clarify, Cleanup Resources logs out processes and/or releases locks. It does not keep any log of its activities.

Everyone knows that a DataStage server can deliver an infinite supply of resources. Otherwise we wouldn't have so many posters trying to demand an infinite supply of resources.