CONNX Data Integration Suite 14.8.0 | CONNX Embedded SQL for Adabas | Standard SQL Statements | CONNECT
 
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
The syntax of the statement is CONNECT, then either host_or_string or TO followed by CONNECT parameters. Connect parameters can input host_or_string AS user_name, or USER user_name with PASSWORD password. You can also optionally set a CHARACTER SET as character_set.
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