10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am new to Shell scripting,
I want to connect to DB2 database through URL,username and password
Please help me out.
I read so many posts in that there is no where it is mentioned about how to connect to a remote database.
Thanks in advance :) (0 Replies)
Discussion started by: Rohit G
2. Shell Programming and Scripting
How to connect db2 IBM on AIX using SSH - SecureCRT ?
Please help me. (3 Replies)
Discussion started by: meomeo87
3. UNIX for Dummies Questions & Answers
I am new to Putty, Unix and DB2 and this is what I am working on right now.
I installed Putty
I got access to username / pwd
I got Unix usrname/Pwd.also got the home directory
once I login into putty I get the screen and it shows $ sign
From here how do I connect to DB2 database?
I have... (2 Replies)
Discussion started by: JayDoshi
4. Shell Programming and Scripting
i m trying to connect DB2 via unix. it is successfully connect. but the connect is getting disconnect .
below is the query ,
countvalue=$(db2 "connect to <Database> user <username> using <Password>" | db2 -x 'select count(*) from <tablename>' ); echo $countvalue
while... (2 Replies)
Discussion started by: baskivs
5. Shell Programming and Scripting
I came across the following script for encrypting the password in this forum
typeset backspace=$(echo \\b\\c)
typeset enter=$(echo \\r\\c)
typeset savesetting=$(stty -g)
... (9 Replies)
Discussion started by: dbashyam
6. Shell Programming and Scripting
I am trying to write a shell script that connect to wcsprod database and read the query
sqlplus -s < connect to wcsprod user wcsadm using pwd >
select * from catentry fetch first 1 row only with ur;
thanks (1 Reply)
Discussion started by: skatpally
7. Shell Programming and Scripting
I want to connect to DB2 database which is mainframes using a unix script and run query and get the result set into the unix box.
Is this acheivable using db2 connect? pls help me with a sample script which can perform the same. (1 Reply)
Discussion started by: midhun19
8. Shell Programming and Scripting
Can anyone please help me with an unix shell script to connect a DB2 database. My requirement is just to display the no of records present in a table of a DB2 database through Unix Shell script. Thx - Ram (1 Reply)
Discussion started by: onlyraja
9. Shell Programming and Scripting
I have a paramter file, In which I store all the user-ids and passwords for the project. So if a user just invokes the paramter file he has access to all the variables, which i have exported in the parmatere file.
Now if a user echo's the variable which stores the databse password.... (1 Reply)
Discussion started by: DSDexter
10. Shell Programming and Scripting
I need to connect to DB2 through Unix and check whether the database is up or not. We are planning to use Neon shadow direct to connect to the same. I would like to know how to pass parameters to neon shadow direct. Any guidance/help in this regard would be helpful.
My unix box is AIX 1.
... (3 Replies)
Discussion started by: ranj@tcs