Hi all,

I would like to know how to break my ingres script in case of error.

For more informations:
I wrote scripts that :
Create DB
Copy data
Duplicate Tables
Modify somes
Drop modified tables
Put on index

But I got trouble.

How do to break on error ?

Thanks in advance

.\vb6dv/.

In SQL putting \nocontinue at the beginning of the script will stop the script at the first SQL error.

thanks a lot !

Hi,

What version of Ingres are you running?

There was a change in how \nocontinue works, it used to go to the next \g in the file, now it exits the script (and maybe commits on the way out).

Regards,

I'm in a Ingres 2.1 version.
And on my version \nocontinue break up thread.