Progress
SQL-92
Guide and Reference
CONNECT Statement
Establishes a connection to a database. Optionally, the CONNECT statement can also specify a name for the connection and a username and password for authentication.
SYNTAX
connect_string
NOTE: Arguments to CONNECT must be either string literals enclosed in quotation marks or character-string host variables.connect_string
Specifies to which database to connect. If the
CONNECT
statement specifiesDEFAULT
, SQL tries to connect to the environment-defined database, if any. The value of theDB_NAME
environment variable specifies the default connect string.The connect_string can be a simple database name or a complete connect_string. A complete connect string has the following components:
connection_name
The name of the connection as either a character literal or host variable. If the
CONNECT
statement omits a connection name, the default is the name of the database. Connection names must be unique.username
User name for authentication of the connection. SQL verifies the user name against a corresponding password before it connects to the database. The value of the DH_USER environment variable specifies the default user name. If DH_USER is not set, the value of the USER environment variable specifies the default user name.
password
Password for authentication of the connection. SQL verifies the password against a corresponding user name before it connects to the database.
The value of the DH_PASSWD environment variable determines the default password.
NOTES
EXAMPLES
- Arguments to CONNECT must be either string literals enclosed in quotation marks or character_string host variables.
- An application can connect to more than one database at a time, with a maximum of 10 connections. However, the application can actually gain access to only one database at a time. The database name specified in the CONNECT statement becomes the active one.
- If an application executes a SQL statement before connecting to a database, an attempt is made to connect to the environment-defined database, if any. If the connection is successful, the SQL statement is executed on that database.
The following examples illustrate the CONNECT statement:
See also the last example for the DISCONNECT Statement which illustrates the CONNECT, SET CONNECTION, and DISCONNECT statements in combination.
AUTHORIZATION
None
SQL COMPLIANCE
SQL-92
ENVIRONMENT
Embedded SQL only
RELATED STATEMENTS
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |