The output is not "83" but
"1
-------------
83
1 record(s) selected."
It appears you'll have to parse the output and pick out the third line.
Bob
Hello, I am having problems seeing what I am doing wrong here. This is a ksh file..it contains a DB2 database command but I will display the output. The problem I have is when I try to use the local_value variable..it doesnt show up:
db_cmd="select count(*) from table1"
db2 -x "${db_cmd}" 1>${local_value}
print "value = ${local_value}"
The result of running db_cmd without the output to local_value is:
1
-------------
83
1 record(s) selected.
The local_value is to capture the "83", which is what outputs to my screen at this point. So..the output looks like:
83
But when it prints the value it looks like:
value =
I have also added an " | awk '{print $1}' " to the command line it removes all the spaces from the beginning of 83 but that doesnt seem to help the print.
Any ideas?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic