Hi, dear all
I have the following problem. Wondering who could tell me why it happens.

$ db2 connect to dbname
$ hoge=`db2 -x values current date | sed 's/\///g'`
$ echo $hoge
SQL1024N A database connection does not exist. SQLSTATE=08003



And it's OK when:

$ db2 connect to dbname
$ db2 -x values current date | sed 's/\///g' > result.log
$ cat result.log
01022012

Thank you.

correct
some commands use sub-shell and loose the connection
this is also different in bash and ksh and even between different versions in ksh
the linux doc recommends NOT using anymore aa=`command....`
we had the same problem while upgrading ksh and had to down-grade ksh again
look at linux doc for this..

The error is due to the pipe to sed. You can avoid error by defering sed until later:

$ db2 connect to dbname
$ h=`db2 -x values current date`
$ hoge=`echo $h | sed -e "s/\///g"`


/Lennart

There is the ugly bypass Ugly bypass, is there a better solution?

Thank you very much.
Not using aa=`command....` is the best choice for me ..