RE: dbaccess to stop script upon error

Try the DBACCNOIGN environment variable... HTH, Paul Mosser -----Original Message----- From: Jacob Salomon [mailto:JSalomon@bn.com] Sent: Friday, September 08, 2000 1:16 PM To: informix-list@iiug.org Subject: dbaccess to stop script upon error Hi, Family. If I run dbaccess interactively - with the menus - I can choose a script file to run. If it encounters an error, the statement gets rolled back and the script stops executing right there. So if I have a 10-statement script and it barfs on the 4th statement, only the first three will have been executed. By contrast, if I run dbaccess non-interactively: $ dbaccess yutz yada.sqland it encounters an error, the process continues to execute the remaining SQL statements in the script. So in the above example, it will have executed statements 1-3, then 5-10, effectively skipping statement 4. I have a situation in which this is not acceptible. I recall (from this newsgroup) that there was an option - perhaps undocumented - to dbaccess to tell it to stop upon receiving an error. I can't find it in the Dbaccess User Manual but that don't mean it ain't there. Anyone familiar with this? Thanks. -- +----- Jacob Salomon - DBA JSalomon@bn.com - --------------------------+ |------------------- Bulletin Board Announcement ----------------------| | Congregants will please note that the bowl at the back of the church | | bearing the sign "For the Sick" is for monetary contributions only. | +----------------------------------------------------------------------+ Sent via Deja.com http://www.deja.com/ Before you buy.