I am back again with yet another Informix issue, though a minor one. I use the tool isql that comes with informix dynamic server 9.3.

I am making DML queries using this tool via a korn shell script. When I create any query and execute it against the db via isql from the script - I get messages like:

15 row(s) deleted.
1 row(s) inserted.
1 row(s) updated.
Table created.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.
1 row(s) inserted.

etc. I am looking for a way to supress these messages or if possible redirect it to a log file or something. When I use the stream redirection operator '>' - it does not work and does something funny that I find hard to explain. No files are created.

The command format that I use looks like :

isql dbname <<.
> query1;
> query2;
>.

Can anyone suggest about how to achieve this. This is not really necessary to do in my work product but I felt it would cleaner if I were able to do so. Let me know if I need to provide any more details and oh! by the way, I am on Solaris 8.

Hi,

I normally do this by dbaccess tool which similar to isql.

dbaccess db_name sql_file .sql 1>procs1.log 2>procs2.log

I suppose you can replace dbaccess by isql

Hope it helps.

Nitin

Thanks Nitin. But for me this would be a lot of change that I cannot risk at this point of time. Any trickery that I can apply with the current thing that I have?