connect

Description

Creates a connection to Adaptive Server.

Syntax

exec sql connect user_name
[identified by password] [at connection_name]
 [using server_name] [labelname label_name labelvalue label_value …] end-exec

Parameters

user_name: The user name to be used when logging into Adaptive Server.

password: The password to use to log in to Adaptive Server.

connection_name: A name that you choose to uniquely identify the Adaptive Server connection.

server_name: The server name of the Adaptive Server to which you are connecting.

Examples

Example 1

     EXEC SQL BEGIN DECLARE SECTION END-EXEC.

           01         UID             PIC X(32).

           01         PASS            PIC X(32).

           01         SERVER          PIC X(100).

      EXEC SQL END DECLARE SECTION END-EXEC.

      DISPLAY "UID NAME?".

      ACCEPT UID.

      DISPLAY "PASSWORD ?".

      ACCEPT PASS.

      DISPLAY "SERVER TO CONNECT TO ?".

      ACCEPT SERVER.

      EXEC SQL CONNECT :UID IDENTIFIED BY :PASS

                USING :SERVER END-EXEC.

Usage

In every Embedded SQL program, the connect statement must be executed before any other executable SQL statement except allocate descriptor.

The label_name and label_value clauses, if used, must be the last clauses of the connect statement.

If a program uses both C and COBOL languages, the first connect statement must be issued from a COBOL program.

If a program has multiple connections, only one can be unnamed.

If an Embedded SQL statement does not have an at connection_name clause to direct it to a specific named connection, the statement is executed on the current connection.

To specify a null password, omit the identified by clause or use an empty string.

If the connect statement does not specify an Adaptive Server, the server named by the DSQUERY environment variable or logical name is used. If DSQUERY is not defined, the default server is SYBASE.

Client-Library looks up the server name in the interfaces file located in the directory specified by the SYBASE environment variable or logical name.

The Adaptive Server connection ends when the Embedded SQL program exits or issues a disconnect statement.

Opening a new connection, named or unnamed, results in the new connection becoming the current connection.

A program that requires multiple Adaptive Server login names can have a connection for each login account.

By connecting to more than one server, a program can simultaneously access data stored on different servers.

A single program can have multiple connections to a single server or multiple connections to different servers.

Table 9-1 shows how a connection is named:

**Table 9-1: How a connection is named**
If this clause is used	But without	Then, the ConnectionName is
at connection_name		connection_name
using server_name	at	server_name
None		DEFAULT