5.31.2 CONNECT

The CONNECT command is used to connect to the remote database. You must do this before you can perform any activity on the database.

Syntax:

Command	Keyword	Value	Developer notes
CONNECT	DRIVER	value	Required. Database driver name.
	DATABASE	value	Required. Database name.
	USER	value	Required. Database server user login.
	PASSWORD	value	Required. Database server user password.

 

Example

CONNECT DRIVER(DB2) DATABASE(SALES) USER(user) PASSWORD(password)

The driver keyword value is a symbolic name used to locate the service's property entry:

driver.db2=com.ibm.as400.access.AS400JDBCDriver

The database keyword value is a symbolic name used to locate the service's property entry:

database.sales=jdbc:as400://DBHOST/LIBRARY;naming=sql;errors=full;date format=iso;translate binary=true