How to redirect Informix utilities progress statements to a file?
Posted in 2000
Topics: Stored Procedures & SPL
A table load script uses the following command:
dbload -d $SXXIBASEVAR -c $tabla.dbl -n 300 -l $tabla.errThe results are as follows:
Database selected.
Table dropped.
Database closed.
Database selected.
Table created.
Index created.
Index created.
Index created.
Index created.
Index created.
Index created.
Index created.
Index created.
Index created.
Index created.
Index created.
Index created.
Index created.
Database closed.
DBLOAD Load Utility INFORMIX-SQL Version 7.30.UC3
Copyright (C) Informix Software, Inc., 1984-1998
Software Serial Number AAC#A447827
300 Row(s) loaded so far to table mch.
600 Row(s) loaded so far to table mch.
900 Row(s) loaded so far to table mch.
========================================
My question:
How can I redirect all the informix progress statements to a logfile instead
of having them go to the display?
Thanks,
Denmark W.
dbload ... 1>dbload.out 2>dbload.err
In article <90ra7i$qnb$1@news.xmission.com>,
"Denmark B. Weatherburn" <dweatherb@btl.net> wrote:
>
> A table load script uses the following command:
> dbload -d $SXXIBASEVAR -c $tabla.dbl -n 300 -l $tabla.err> The results are as follows:
> Database selected.
>
> Table dropped.
>
> Database closed.
>
> Database selected.
>
> Table created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Index created.
>
> Database closed.
>
> DBLOAD Load Utility INFORMIX-SQL Version 7.30.UC3
> Copyright (C) Informix Software, Inc., 1984-1998
> Software Serial Number AAC#A447827
>
> 300 Row(s) loaded so far to table mch.
>
> 600 Row(s) loaded so far to table mch.
>
> 900 Row(s) loaded so far to table mch.
>
> ========================================
>
> My question:
>
> How can I redirect all the informix progress statements to a logfile
instead
> of having them go to the display?
>
> Thanks,
>
> Denmark W.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Or they can all goto one single file with:
dbload ... 2>dbload.out 1>&2
Allen
ktknauss@my-deja.com wrote:
>
> dbload ... 1>dbload.out 2>dbload.err
>
> In article <90ra7i$qnb$1@news.xmission.com>,
> "Denmark B. Weatherburn" <dweatherb@btl.net> wrote:
> >
> > A table load script uses the following command:
> > dbload -d $SXXIBASEVAR -c $tabla.dbl -n 300 -l $tabla.err> > The results are as follows:
> > Database selected.
> >
> > Table dropped.
> >
> > Database closed.
> >
> > Database selected.
> >
> > Table created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Index created.
> >
> > Database closed.
> >
> > DBLOAD Load Utility INFORMIX-SQL Version 7.30.UC3
> > Copyright (C) Informix Software, Inc., 1984-1998
> > Software Serial Number AAC#A447827
> >
> > 300 Row(s) loaded so far to table mch.
> >
> > 600 Row(s) loaded so far to table mch.
> >
> > 900 Row(s) loaded so far to table mch.
> >
> > ========================================
> >
> > My question:
> >
> > How can I redirect all the informix progress statements to a logfile
> instead
> > of having them go to the display?
> >
> > Thanks,
> >
> > Denmark W.
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.