SQLCONNECT environment variable

Settings

SQLCONNECT = parameter#value ; ...

Operating System

Optional.

Description

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, DBCOLLAT, 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, and should be used 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.

NoteSpecifying 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 the ps -ef command. This is especially useful if you run DBISQL or other utilities in quiet mode.

See also

For a description of the connection parameters, see the section “Connection parameters” in Chapter 4, “Connection and Communication Parameters” in the Sybase IQ System Administration Guide.