Regarding shell script

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ragunathan13
Participant
Posts: 50
Joined: Mon Sep 25, 2006 11:18 pm
Location: Chennai
Contact:

Regarding shell script

Post by ragunathan13 »

Hi,

How to access DB2 cmd editor from shell script.

Thanks in advance.....
Regards,
Ragunathan J
sanjumsm
Premium Member
Premium Member
Posts: 64
Joined: Tue Oct 17, 2006 11:29 pm
Location: Toronto

Re: Regarding shell script

Post by sanjumsm »

First of all why do u need this??? But still if you want to connect to DB2 through shell script then in scrript try out this...

#!/bin/sh
runwin32 cmd
connect to db2 databasename username identified by password...

Now run the script. You will get connected to db2 database.
sanjeev kumar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

... and then what? If the script is invoked from DataStage it must provide ALL responses to the shell script, including the command to end the session. I assume, because the question is posted in a DataStage forum, that such is the intention.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

I have a question, why do you think you need to run a shell script especially from a Windows server? What is the purpose of this script?
Mamu Kim
Post Reply