RE: COUNT (*)
Edward Bidinotto wrote:
} To all"
}
}When you do
}
}isql dbname <<!
}
}select count(*) from table
}!
}
}
}1 row(s) retrieved.
}
}Is there any way to eliminate the 1 row retrieved within a script?
}
}Tks
}Ed
}
}edbid @ cobe.com
The "1 row(s) retrieved" message actually goes to the standard error, so =
you only have to redirect that to /dev/null to achieve your aim.
isql dbname <<! 2>/dev/null
select count(*) from table!
cheers
RET
+------------------------------------------+
| Richard Thomas |
| DBA - Marketing Information Systems |
| Optus Communications |
| email: richard_thomas@yes.optus.com.au |
| Ph: +61 2 9342 7188 |
| "My opinions are my opinions" |
+------------------------------------------+