The nzsql session history
On UNIX clients, the Netezza Performance Server system stores the history of your nzsql session in the file $HOME/.nzsql_history. In interactive sessions, you can also use the up-arrow key to display the commands that you ran.
On Windows clients, you can use the up-arrow key to display the commands that ran previously.
By default, an nzsql batch session continues
even if the system encounters errors. You can control this behavior
with the ON_ERROR_STOP variable, for example:
nzsql -v ON_ERROR_STOP=You do not have to supply a value; defining it is sufficient.
You can also toggle batch processing with a SQL script. For example:
\set ON_ERROR_STOP
\unset ON_ERROR_STOPYou can use the $HOME/.nzsqlrc file to store values, such as the ON_ERROR_STOP, and have it apply to all future nzsql sessions and all scripts.