Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    38

    Unanswered: Suppressing query result text

    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.

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    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

  3. #3
    Join Date
    Jan 2006
    Posts
    38
    Quote Originally Posted by nitin_math
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •