Re: batch SQL command processor for NT
Posted in 1999
Mike & Lynda Dunham-Wilkie <lynmik@bc.sympatico.ca> wrote:
>
> I'm using IDS with UDO 9.14 under NT and am frustrated at the lack of a
> way to run SQL command files in batch mode. In Unix I run
>
> dbaccess db cmd.sql >& cmd.out
At least I can say that the following is working:
dbaccess db - < cmd.sql > cmd.out 2>&1
>
> and get both standard output and any error messages spooled to a single
> output/error file cmd.out
>
> Is there a way to do something similar in the DOS shell under NT? (I can
> redirect output but not error messages)
>
> Or better still, is there a command interpreter in NT that can run in
> batch mode? As far as I can tell the SQL Editor client that comes with
> the development kit can't run in batch mode and the also the run option
> in it stops after the first error (unlike dbaccess).
>
> Help!
>
> Thanks in advance,
>
> Mike
>
Vardan
--
vaar@geocities.com