'isql does not exit on errors

We are using an old version of isql to connect to Informix DB from Linux (RHEL 6.10) The format we are using to run a select SQL is:

 isql -v -k $INX_DRIVER -x0xEC -b < ${sql_file} > ${out_file}

When there are errors while running the SQL, the above call does not end and infinitely keeps adding error message in the log file.

How can I specify during isql call to exit on error/exception?

The man page has this option which sound like should do the trick but the description is not clear enough for me to be sure.

-3     Use the ODBC 3 calls.

I think this option would end isql call if there are 3 errors/exceptions. Is my understanding correct?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source