Shell Programming and Scripting

Hi all,
I want to write a script which logs into a database (DB2). To do this i need to have a password. This will be done lots and lots of times, so i need to modify the script to automate the response to the password request.

How do i this, because at present i do the following:
db2 connect to dnb0j2 user liam
it does not return to the script to allow me to respond with the password.

Can someone give me an example ? or point me in the right direction?

Thanks.

You can do it by

db2 connect to dnb0j2 user liam using passwd


Try this.

if fact i was trying this, but our system is not allowing this to work correctly with the authorization credentials.

is there a way to do this in a script??

what do you mean by your system is not working correctly. What is the error it is giving. post it in detail.

I am expecting this has something with the way you are executing your shell. execute the script with in the same shell. That means use either of these commands to execute the script.

source scr_name (or)
. scr_name


write a script like this.

db2 connect to data_base user user_name using password


I think this should work.