java class into DataStage

mfanas · Post by **mfanas** » Thu Jan 11, 2007 6:35 am

Hello DS Gurus, I need to design something on DataStage that can enable me to check some business rules by calling a Java class before it is written to a Dataset (table). I had a check on some previous postings and JavaPack was mentioned. I would to find out is there anyone who has done something like this before, how was it implemented or how can it be implemented. Any ideas my gurus will be appreciated.

chulett · Post by **chulett** » Thu Jan 11, 2007 8:34 am

You mean other than buying the Java PACK?

We've used shell scripts to invoke Java processes. Land the data, invoke, pick up the results. To do it directly in a job (as in row by row, in a derivation) requires the pack, as far as I know.

eostic · Post by **eostic** » Thu Jan 11, 2007 11:37 am

Absolutely. As Craig suggests, JavaPack is the most elegant and direct way to invoke one of your classes. With JavaPack your class can interact with the DS engine on a row by row basis, reading from and writing to various links, and inspect meta data that exists within the job design to make decisions......

lstsaur · Post by **lstsaur** » Thu Jan 11, 2007 12:21 pm

Is Java PACK available and working with Hawk GA?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 11, 2007 2:14 pm

Are the business rules already written in Java? If not, why is "using a Java class" part of your specification? It's probably more efficient if the business rules are checked "in line" in the DataStage job.

mfanas · Post by **mfanas** » Mon Jan 22, 2007 2:45 am

Thank you all for your responses, I will use the JavaPack as the business rules are already built in Java (for reusability). Your help is always appreciated my gurus.