SQLCONNECT = parameter#value ; ...
Optional.
The SQLCONNECT environment variable is optional, and is not set by the installation program.
SQLCONNECT specifies connection parameters that are used by several of the database administration utilities, such as dbisql, dbinfo, and dbstop, when connecting to a database server. This string is a list of parameter settings, of the form parameter=value, delimited by semicolons.
The number sign “#” is an alternative to the equals sign; use it if you are setting the connection parameters string in the SQLCONNECT environment variable. Using “=” inside an environment variable setting is a syntax error. The = sign is allowed only in Windows.
Specifying connection parameters in SQLCONNECT rather
than on the command line offers greater security on UNIX systems.
It prevents users from being able to display your password with ps -ef. This
is especially useful if you run dbisql or other
utilities in quiet mode. Note that specifying connection parameters
in SQLCONNECT rather than on the command line is more secure, but
is not entirely secure. Because the password is in plain text, it
possible for hostile action to extract it from the environment context.
See “Connection parameters” in Chapter 4, “Connection and Communication Parameters,” in the System Administration Guide: Volume 1.
