assign a value to variable

markjason · #1 (**permalink**) 10-10-2006

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.

Corona688 · #2 (**permalink**) 10-10-2006

What shell are you using?

markjason · #3 (**permalink**) 10-10-2006

i am using ksh

vgersh99 · #4 (**permalink**) 10-10-2006

I'm no db2 expert, but try this:

Code:

#!/bin/ksh

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Assign o/p of awk to a variable	c2b2	Shell Programming and Scripting	8	04-01-2009 07:50 AM
assign a value to a variable	Shivdatta	Shell Programming and Scripting	10	01-17-2007 07:40 AM
assign value to variable using AWK	HAA	Shell Programming and Scripting	4	12-06-2006 11:43 AM
hot to assign output to a variable	walnut	Shell Programming and Scripting	1	02-22-2006 09:19 PM
assign to variable	AkumaTay	UNIX for Dummies Questions & Answers	1	05-18-2002 02:11 PM

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


	Powered by