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