batch SQL command processor for NT

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 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

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 <snip> Best thing I've found for NT is the MKS (Mortice Kern Systems) Toolkit. It includes almost all UNIX commands, as well as an honest-to-god Korn shell for NT. It's now a requirement for all NT boxes I work on. Can't live without it. Joe Lumbley -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide" The DBA Survival Guide, Second Edition will cover NT, 7.X through 7.3, graphical utilities, more survival hints. Publish date: 12/16/98 FINALLY! ---------------------------------------------------------------------------