Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Unanswered: dbaccess and SQL command files

    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?

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: dbaccess and SQL command files

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •