RE: Unix command within a DBACCESS Query

You can if you call the script from the command line, but the same syntax will error in interactive mode. Try the following Dbaccess database << EOF select * from table1;!echo test select * from table1; EOF (the '!' is the key) This basically tells dbaccess to shell out as if you had pressed '!' within interactive mode. HTH -----Original Message----- From: Viegas, John [SMTP:ViegasJP@panasonic.com] Posted At: Friday, October 30, 1998 10:38 AM Posted To: Informix Conversation: Unix command within a DBACCESS Query Subject: Unix command within a DBACCESS Query Is is possible to execute a unix command within a dbaccess query? I know it works fine with stored procedures..... Any ideas would be greatly appreciated.