dbsql user session variables

In the dbsql interface, you can display the current user-defined session variables by using the \set command with no arguments.

An example of the command with sample session variables follows.

BLUDB.MLEE(MLEE)=> \set 
VERSION = 'IBM Netezza SQL Version 1.1'
DBNAME = 'BLUDB'
USER = 'MLEE'
HOST = '127.0.0.1'
PORT = '5480'
ENCODING = 'LATIN9'
NZ_ENCODING = 'LATIN9'
PROMPT1 = '%/%.%s%(%n%)1# '
PROMPT2 = '%/%.%s%(%n%)1# '
PROMPT3 = '>> '
HISTSIZE = '500'