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?