Invoke Java Class from Dstage

[Corvus]

Hi,

Could anyone please let me know on how to invoke a Java class from Datastage.

The requirement is to invoke a java class and use its properties from Datastage and then propagate the records in the form of XML.

Amy help on this will be very helpful

[miwinter]

Could this not be uncomplicated somehow, perhaps by using whatever scheduling you may use to call the Java component first, then trigger the Datastage process after the XML is produced?

Furthermore, what exactly does "use its properties from Datastage" mean?

One option might be to employ a before job sub-routine.

PS. Sorry I'm not Amy

[chulett]

To do this inside a DataStage job, you'd need to purchase the Java PACK as far as I know, which would give you a "Java Transformer".

[Sreenivasulu]

Set the classpath,Set the JVM. Its quiet simple.
If you have worked in java then it would be pretty fast.

Regards
Sreeni

[eostic]

JavaPack makes it a lot more elegant, as you can directly interact on a row by row basis with your class. I have a more detailed entry on the subject in my blog below, but basically, DataStage gives control to your class when it (DataStage) needs a row (if your java stage is a source) or when it (DataStage) is ready to give you a row (if your java stage is a target). Your java class, then, is provided with a set of API calls that it can make "back" to the DataStage engine to inspect things or ultimately just write a row to a link, or receive data from a link. It's easy to do if you are comfortable with java and is by far the easiest way to "extend" DataStage functionality. There is source code at that blog entry.

...and it's "in the box" with DataStage nowadays (no cost).

Ernie

[chulett]

Ah... can't seem to remember what all is "in the box" any more.