Shell Script

sri27 · Post by **sri27** » Fri Apr 08, 2005 10:31 am

Hi,
Iam new to DS.I need help on writing a shell script to connect to db2 and perform sql operations on it.I want to include this shell script under ExecSH.I know this is not unix forum but please help me if anyone has done this before.
Thanks,
Sri

ranga1970 · Post by **ranga1970** » Fri Apr 08, 2005 10:43 am

write proceadure or function; call this proceadure or function in shell scripts and call the shell script in before job execution

thanks

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Apr 08, 2005 3:01 pm

Can you be more specific on what you need. There are several ways to access and obtain results from db2.

You may accomplish SQL tasks directly by DataStage db2 plugin.