Unable to get the db2 command prompt in unix

ragavhere · #1 (**permalink**) 11-19-2008

Hi,

When i try to connect to the db2 database from unix solaris 5.8 version by typing "db2" from the .../sqllib/bin/ folder, i am not getting the db2 command prompt. Could anyone help me resolve this? Here the db2 is executable only. But still iam not getting the db2 prompt.
The error i get is
$ db2
ksh: db2: not found

csorhand · #2 (**permalink**) 11-19-2008

ragavhere,

did you set your DB2 instance to that user?It should be in the users PATH so that you can execute the db2 command.

ragavhere · #3 (**permalink**) 11-19-2008

Hi csorhand,

I think DB2 instance is not set.

ragavhere · #4 (**permalink**) 11-26-2008

Hi,

Is the way i am connecting to DB2 right?

if [ $ERROR_CD = 01 ]; then
db2output=`DB2 <<EOD
connect to <DB name> user <username> using <password>
insert into <schema.tablename> (Col1,Col2,Col3,Col4,Col5,Col6) values('Val1','Val2','Val3','Val4','Val5','Val6');
terminate
EOD`
else
exit
fi

ragavhere · #5 (**permalink**) 11-26-2008

Hi,

Is the way i am connecting to DB2 right?

Quote:

Originally Posted by ragavhere

if [ $ERROR_CD = 01 ]; then
db2output=`DB2 <<EOD
connect to <DB name> user <username> using <password>
insert into <schema.tablename> (Col1,Col2,Col3,Col4,Col5,Col6) values('Val1','Val2','Val3','Val4','Val5','Val6');
terminate
EOD`
else
exit
fi

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Command Prompt	popo123456789	Windows & DOS: Issues & Discussions	1	08-07-2008 06:29 AM
inconsistent ls command display at the command prompt & running as a cron job	rajranibl	SuSE	5	07-30-2007 08:26 AM
Command prompt argument	giridher2000	Shell Programming and Scripting	2	10-27-2005 01:36 AM
Unable to get password prompt	owls	IP Networking	2	11-12-2003 02:17 AM
Changing the UNIX command prompt	WERUreo	UNIX for Dummies Questions & Answers	2	04-22-2002 11:45 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by