Re: SQL from command line capturing screen display.
Posted in 1997
Terron Wright wrote:
>
> How can I capture what is displayed to the screen when doing dbaccess
> script from the command
> line in UNIX. I would like to be able to capture the 100 records
> updated display.
That information is sent to stderr, whereas the results, if any, are
sent to stdout.
So if you just want the number of rows processed then try:
dbaccess database script >/dev/null 2>a_file.out
Hope that helps,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //|
| +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+