5.6.5 SEND
The SEND command is used to connect to the database, to execute the query and to format the result set.
If a working list is available then the contents of the working list is returned else a database select is done.
Syntax:
|
Command |
Keyword |
Value |
Developer notes for Command/Keyword/Value |
|
SEND |
DRIVER |
value |
Conditional. Database driver name. |
|
DATABASE |
value |
Conditional. Database name. |
|
|
USER |
value |
Conditional. Database server user login. |
|
|
PASSWORD |
value |
Conditional. Database server user password. |
|
|
RESULTSET |
*UPDATABLE |
Optional. ResultSet concurrency mode. |
|
|
*READONLY |
Default. |
||
|
NUMBERFORMAT |
|
Optional. See NUMBERFORMAT. |
|
|
ARCHIVE |
|
Optional. See ARCHIVE. |
|
|
ENCODING |
|
Optional. See ENCODING. |
|
|
UAPATH |
value |
Optional. User agent save response path. |
|
|
UAFILE |
value |
Optional. User agent save response file. |
|
|
UACACHE |
value |
Optional. Cache-Control max-age. |
|
|
UADISPOSITION |
value |
Optional. Content-Disposition filename. |
|
|
CHARSET |
*YES |
Optional. Include charset attribute. |
|
|
*NO |
Do not include charset attribute. |
||
|
*TEXT |
Default. Include charset attribute if content is text. |
The driver keyword value is a symbolic name used to locate the service's property entry:
driver.sqlserver=com.ddtek.jdbc.sqlserver.SQLServerDriver
The database keyword value is a symbolic name used to locate the service's property entry:
database.northwind=jdbc:datadirect:sqlserver://10.2.1.28:1433
Example
SEND DRIVER(SQLSERVER) DATABASE(NORTHWIND) USER(user) PASSWORD(password)