CONNECT

Function

The CONNECT statement explicitly establishes an SQL session between a user application and Adabas SQL Gateway Embedded SQL.

Invocation 

Embedded Mode P

Dynamic Mode  

Interactive Mode P
 

Syntax

 

Connect.bmp

 

 

All specifiers can either be character string constants or single host variable identifiers. The host variables must have been defined in the application program according to the host language rules and their values must be character strings.

The maximum lengths of these specifiers are as follows:

  • Server (255 characters)
  • Connection (32 characters)
  • User (32 characters)
  • Password (32 characters)

 

Description

The CONNECT statement explicitly establishes an SQL session between the user application and Adabas SQL Gateway Embedded SQL.

The user specified must exist (see CREATE USER statement). If user is not specified, the connection will be refused. If a password is not specified, blanks will be generated as default password.

If a server is not specified, the default server is used.

Limitations

None.

ANSI Specifics

None

Adabas SQL Gateway Embedded SQL Specifics

none

 

Examples:

CONNECT TO MYASG user XXX password YYY