DSXchange

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

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

thanks

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.