Vertica Tip: Exiting a vsql Script Following an Error

Moderator: NorbertKrupa

Post Reply
User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Vertica Tip: Exiting a vsql Script Following an Error

Post by JimKnicely » Thu Sep 20, 2018 2:26 pm

By default, if a vsql script command results in an error, for example, because of a malformed command or invalid data format, processing continues. If you set ON_ERROR_STOP to “on” in a vsql script and an error occurs during processing, the script terminates immediately.

Find out more here:
https://forum.vertica.com/discussion/23 ... g-an-error
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica Links”