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 a executable file only. But still iam not able to execute.
The error i get is

$ db2
ksh: db2: not found

something is wrong with the path
are you a client instance ? check that sqllib/db2profile is getting executed from profile

Yes i am using the client instance. But 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

could you try
in command window
db2 connect to xxx user yyy using zzz
db2 select * from sysibm.sysdummy1
and publish the rc
try also db2level

I could try in command window. But this has to be done by a script. That is why i posted that part of the code. Is that code right?

the first thing todo, is to see if all is working as it should
when you have command line working you can continue with scripts, as in that case you are sure, that it should work.