Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

CONNECT

This command connects Text Extender to a database .

Authorization

CONNECT authorization to the database .

Command syntax

>>-CONNECT------------------------------------------------------>
 
>-----+------------------------------------------------------+-><
      '-TO--db-alias--+-----------------------------------+--'
                      '-USER--user-name--USING--password--'
 

Command parameters

TO db-alias
The database to connect to. The name must be a database alias name, not a database name.

USER user-name
If no user name is specified, it is retrieved from the operating system.

USING password
A password is required only if a user name is specified.

CONNECT no operand
If you do not specify an operand and there is no connected database , CONNECT makes an implicit connection to the database specified in the environment variable DB2DBDFT. If you do not specify an operand and there is a connected database , CONNECT displays information about the current database.

Usage notes

When you issue a DB2TX command without already being connected to a database , Text Extender connects to the database specified in the environment variable DB2DBDFT.

To explicitly connect to a particular database , issue the CONNECT TO command.

You can be connected to only one database at a time; this is called the current database . In interactive mode, a connection lasts until another CONNECT TO statement changes the database , or until a QUIT command is issued. In command line mode, a CONNECT command has no effect.

If you are using an OS/2 client, and this is the first time that you are connecting to a database after you have started the system, you are prompted for a user ID and a password by User Profile Management (UPM). If you are already logged on, UPM takes the user ID and password from this session and tries to connect to the remote server. See Starting the Text Extender command line processor (optional).


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]