unix script in ds job

san_dwh · Post by **san_dwh** » Thu Dec 30, 2010 5:19 am

how to call unix script in ds job?

Ravi.K · Post by **Ravi.K** » Thu Dec 30, 2010 5:40 am

you can call at before and After Job subroutinue.

Sreenivasulu · Post by **Sreenivasulu** » Thu Dec 30, 2010 7:22 am

Can you pls change the 'subject' apprpriately next time ?

Regards
Sreeni

chulett · Post by **chulett** » Thu Dec 30, 2010 9:42 am

Done. Two times now.

Post by **daignault** » Thu Dec 30, 2010 10:50 am

You can execute a Before/After routine. You may also use the "External" stage on your Datastage desktop to execute a routine.

Finally, you can create a wrapper BuildOP for execution of an external routine.

Cheers,

Ray D

chulett · Post by **chulett** » Thu Dec 30, 2010 11:15 am

The answer really depends on what it does and when you need to call this - once? Several times? Once for each row of data through a job? (yes, people have allegedly 'needed' to do this) Hence the myriad suggestions.

PaulVL · Post by **PaulVL** » Wed Jan 05, 2011 6:04 pm

You can also open a Command Sequencer and that is your command line prompt to execute a script.

If you are a GRID shop, you might not want to do it that way, you could use an external source stage (don't quote me) and make it sequencial. That way the script happens on one of your GRID servers rather than your Conductor / Head Node.