CONNECT
Function
The CONNECT statement explicitly establishes an SQL session between a user application and CONNX Embedded SQL.
Invocation
Embedded Mode P Dynamic Mode Interactive Mode P
Syntax
All specifiers can be either character string constants or single host variable identifiers. The host variables must be 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 CONNX Embedded SQL.
The specified user must exist (see CREATE USER statement). If a 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.
Example:
CONNECT TO MYASG user XXX password YYY