Re: using the output of a sql statement in a shell script
In article <6qv8n3$dj3$1@nnrp1.dejanews.com>,
joseph.luczynski@mindspring.com () wrote:
>
>
> ================================================
> response=`
> {
> dbaccess ${dbname} - <<EOF
> select switch_id from switches where switch_id4 = "M1"> EOF
> } 2>&1 `
>
> echo $response
>
Add 2>/dev/null after the EOF
Paul Watson # I don't suffer from
WF Software Ltd. # stress, I'm just
Tel. (+44) 1436 674729 # a carrier
Fax. (+44) 1436 678693 #