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