Shell Programming and Scripting

Then there's either something really wrong with the output from isql, or you mistyped:

Code:

$ DATABASE='acc_fund2 KLU_LP
> acc_fund3 KLU_LTD'
$ echo $DATABASE
acc_fund2 KLU_LP acc_fund3 KLU_LTD
$ echo "$DATABASE"
acc_fund2 KLU_LP
acc_fund3 KLU_LTD
$ echo "$DATABASE" | tr '\n' ' '
acc_fund2 KLU_LP acc_fund3 KLU_LTD

I'm not sure what you want to accomplish. If you want DATABASES to be acc_fund2 KLU_LP acc_fund3 KLU_LTD regardless of echoing it with/without quotes, just add -n to this line: DATABASES=`echo -n "select agroup,tgroup from acc_gen..agroups where tgroup in ( $values ).

If you want the double quotes to be part of DATABASES' value, then something like this should do the trick:

DATABASES="\"`echo -n "select agroup,tgroup from acc_gen..agroups where tgroup in ( $values )\""

pludi/tetreb,

Below is my file contents:

#!/bin/ksh
values=`cat testvalue`
DATABASES=`echo -n "select agroup,tgroup from acc_gen..agroups where tgroup in ( $values ) go " | isql -Uro -Pcup0fj0e -Sdev1client420 | grep acc_`
echo "$DATABASE"

point me where I am wrong? Below is the out put I am getting:

jrc1sudev06:/export/home/client420 $ ./test.sh

jrc1sudev06:/export/home/client420 $

Thanks.
Zulfiqar

How about:

#!/bin/ksh

values=`cat testvalue`
DATABASES=`echo "select agroup,tgroup from acc_gen..agroups where tgroup in ( $values )
go
" | isql -Uro -Pcup0fj0e -Sdev1client420 | grep acc_`

echo "$DATABASES" > dbs

cat dbs | while read output_line
do
echo $output_line | awk '{print $1}' | read a
echo $output_line | awk '{print $2}' | read b
echo "$a"
echo "$b"
done

Brrr.... way too many UUOC-like pipes and alike for my taste.

Not tested, but you get the idea.....

Code:

#!/bin/ksh

read values < testvalue
printf "select agroup,tgroup from acc_gen..agroups where tgroup in ( %s )\ngo\n" "${value}" | isql -Uro -Pcup0fj0e -Sdev1client420 | grep 'acc_' | while read a b junk
do
    echo "$a"
    echo "$b"
done