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)