RE: using the output of a sql statement in a shell script
Joseph,
No there isn't. Just use something like "tail +3 file | sed '/row(s)
retrieved/d' to eliminate the rows.
Regards
David Ashby
-----Original Message-----
From: joseph.luczynski@mindspring.com
[mailto:joseph.luczynski@mindspring.com]
Sent: Friday, 14 August 1998 3:45
To: informix-list@iiug.org
Subject: using the output of a sql statement in a
shell script
Is there a SQL statement that can give me the output of
the switches without
the "switch_id" and/or the "14 row(s) retreived." text?
There may be any amount of switches, and I either need
to write the shell
script to parse the extra text out, or get the SQL
statement to omit it.
Thanks for your help!
================================================
response=`
{
dbaccess ${dbname} - <<EOF
select switch_id from switches where switch_id4 = "M1"
EOF
} 2>&1 `
echo $response
#switch_id RIM 2JY 2JV CLX 2OR ASC AU1 AUP BCS AUA AUO
BOY BHW 2M8 14 row(s)
retrieved.
-----== Posted via Deja News, The Leader in Internet
Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own
Free Member Forum