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.

STATUS

value

Optional: HTTP status number.
Default: 200.

MESSAGE

value

Optional: HTTP status message.
Default: OK.

UAPATH

value

Optional. User agent save response path.

UAFILE

value

Optional. User agent save response file.

UACACHE

value

Optional. Cache-Control max-age.
Default. 0.

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)