I have to assign a result of a query to a vairable like this

how can i do this

Query = select count(*) from table
x=`db2 ${Query}| sed -n '4p'`

but this doesn't work, is there any other way to assign the result without redirecting the result to temp file. .

Thanks
Mark.

Maybe you need to use "quotes":

Code:

$ cat q0
#!/bin/ksh
. /db2/bin/db2_env.ksh
Query='select count(*) from db2_tablespaces'
x=`db2 "${Query}"|sed -n '4p'`
echo "Result is: $x"
exit
$ q0
Result is:       7
$

Thanks, But still i am not getting value to x.

if direct the result to a file and then print the result it is working otherwise
i am getting following error.

result is : SQL30082N Attempt to establish connection failed with security reason "3"

Security reason 3 is: PASSWORD MISSING (The request did not include a password)