dbaccess and SQL command files

n_i · #1 (**permalink**) 02-11-04, 18:06

We run Informix 7.3.1 on Solaris.

I have some SQL command files that I execute using dbaccess. If any of the statements fails (say, has syntax error or attempts to use a non-existent table etc) dbaccess continues executing subsequent statements to the end of file. Is there any way to tell dbaccess that it should stop after the first error, as command processors for DB2 and Oracle do?

gurey · #2 (**permalink**) 02-25-04, 10:26

Quote:

Originally posted by n_i
We run Informix 7.3.1 on Solaris.

I have some SQL command files that I execute using dbaccess. If any of the statements fails (say, has syntax error or attempts to use a non-existent table etc) dbaccess continues executing subsequent statements to the end of file. Is there any way to tell dbaccess that it should stop after the first error, as command processors for DB2 and Oracle do?

Hi,

Please define environment variable DBACCNOIGN=1, then run dbaccess.

Gustavo.

Internet Services

Web Development

Digital Marketing

Consumer Tech