question on Informix query execution...

Posted in 2007

Kern Doe — Mon, 13 Aug 2007 14:27:19 — source: IIUG Forums & Mailing Lists

Hi gurus, Do you know a way to have the query "stop-on-error" instead of indicating error but continuing on to the next line, for example: cat test.sql rename table abc to xyz; -- if fails, don't continue drop synonym blahblah; -- if fails, don't continuecreate synonym ...; Thanks in advance. ________________________________________________________________________________ ____ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webhosting

↪ replying to Kern Doe

kernoal.stephens@autozone.com — Mon, 13 Aug 2007 14:34:05 — source: IIUG Forums & Mailing Lists

If you are using dbaccess you can set: export DBACCNOIGN=1 # To stop after an error FYI "Kern Doe" <kern_doe@yahoo.c om> To Sent by: ids@iiug.org ids-bounces@iiug. cc org Subject question on Informix query 08/13/2007 09:27 execution... [9762] AM Please respond to ids@iiug.org Hi gurus, Do you know a way to have the query "stop-on-error" instead of indicating error but continuing on to the next line, for example: cat test.sql rename table abc to xyz; -- if fails, don't continue drop synonym blahblah; -- if fails, don't continuecreate synonym ...; Thanks in advance. ________________________________________________________________________________ ____ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webhosting ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Kern Doe

Walter Milan — Mon, 13 Aug 2007 16:31:43 — source: IIUG Forums & Mailing Lists

dbaccess -a gives you that behavior Hospitably yours, Walter Milan DBA -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Kern Doe Sent: Monday, August 13, 2007 9:27 AM To: ids@iiug.org Subject: question on Informix query execution... [9762] Hi gurus, Do you know a way to have the query "stop-on-error" instead of indicating error but continuing on to the next line, for example: cat test.sql rename table abc to xyz; -- if fails, don't continue drop synonym blahblah; -- if fails, don't continuecreate synonym ...; Thanks in advance. ________________________________________________________________________ ____________ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webhosting ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.