CONNECT
The CONNECT command connects to a remote database. By default a connection object is in auto-commit mode, which means that it automatically commits changes after executing each statement.
CONNECT ---------- DRIVER --------- value ---------------------->
>-- DATABASE ------- value ---------------------->
>-- USER ----------- value ---------------------->
>-- PASSWORD ------- value ----------------------|
Keywords
|
DRIVER |
The symbolic name of the database driver used to locate the service's property entry. For example:
CONNECT DRIVER(SQLSERVER) DATABASE(NORTHWIND) USER(USER) PASSWORD(PASSWORD)
Searches for a corresponding property like:
driver.sqlserver=com.ddtek.jdbc.sqlserver.SQLServerDriver
|
|
DATABASE |
The symbolic name of the database used to locate the service's property entry. For example:
CONNECT DRIVER(SQLSERVER) DATABASE(NORTHWIND) USER(USER) PASSWORD(PASSWORD)
Searches for a corresponding property like:
database.northwind=jdbc:datadirect:sqlserver://99.99.99.99:1234
|
|
USER |
The user profile to be used to log into the database server. |
|
PASSWORD |
The password for the database server that corresponds to the USER keyword. |
Examples
RDML
USE BUILTIN(JSM_COMMAND) WITH_ARGS('CONNECT DRIVER(SQLSERVER) DATABASE(NORTHWIND) USER(user) PASSWORD(password)') TO_GET(#JSMSTS #JSMMSG)
RDMLX
use builtin(jsmx_command) with_args(#jsmhandle 'connect driver(sqlserver) database(northwind) user(user) password(password)') to_get(#jsmsts #jsmmsg)