DSXchange

Pick based on what criteria? Looks like a sequence would be the way to go, then a Routine activity invoking a custom SendMail routine. A Notification activity is contraindicated because of the stated need to have a variable body.

Is it possible to capture the actual SOAP envelopes (header and body at least) used by the Web Services Transformer stage using only DataStage facilities (perhaps a property in the stage itself)?

Commands are case sensitive in UNIX systems. The orchadmin command must be specified in lower case. Its parent directory must be in your command search list (that is, in the PATH environment variable) or the command must be specified using a fully qualified pathname.

I think so. I'm on a non-IA 8.5 site at the moment.

The URL or pathname that you're providing the importer can not be found (or maybe you also need to specify a port number as well). Can you get a copy of the XML and import from a local file?

Seems a reasonable guess, but probably worth checking with IBM anyway.

A mystery. I presume this is version 8.7. If you create user-defined data classes do they show up?

decimal[10,0] is not big enough to handle all possible values of uint64, the largest possible value of which is 2**64-1, or 18,446,744,073,709,551,615 (rather more than 10 digits, which is what your decimal[10,0] data type implies). DataStage is warning you that not all possible uint64 values will f...

This is not a question from U, it is a question from kollurianu.

The second person personal pronoun in English is spelled "you". We strive for a professional standard of written English on DSXchange.

I don't have DataStage available at the moment so can't readily answer the question you asked in your subject. But may I ask whether RCP was enabled for those two jobs and not for the others? And, if not, were only these two jobs dealing with tables that have additional columns?

The second person personal pronoun in English is spelled "you". The present tense plural of the verb "to be" is spelled "are". We strive for a professional standard of written English on DSXchange, not least to make life a little easier for those whose first language i...

Karthik.M wrote:Version Control is possible in Datastage using "CVS - Concurrent Versions System" and "Clearcase" only.

That is totally incorrect.

As narsingrp noted, it is possible to integrate with other source code control systems using the Eclipse plug-in provided for that very purpose.

That would be a much more useful reply had you elaborated on how to achieve the "with the loop variable" part. It seems to me that a straightforward approach would be to use stage variables to "remember" the value from the previous record, perhaps using the DCount() function to e...

Karthik.M wrote:When RCP is enabled the processing is done sequentially and all partitions are nullified.

This is totally incorrect.

If there are no large objects (BLOB or CLOB), and provided that you are using DB2 Timestamp data type where Oracle has TIME, you will be able to do this with one or two jobs quite easily using Runtime Column Propagation. Even if there are large objects it can be achieved with few jobs, but you have ...