Fields in the DECS Connection Document

The Domino Enterprise Connection Services (DECS) connection document provides values for Connectivity and Table Selection options. The fields in the DECS connection document are described below.

Field

Description

Data source

Specifies the name of the source ODBC database as listed in the ODBC Administrator.

The Connector for ODBC is available with the following drivers:

  • DataDirect Release HCL-branded driver for native Connector for ODBC
  • DataDirect Sybase Wire Protocol
  • DataDirect Oracle Wire Protocol
  • DataDirect DB2 Wire Protocol
  • DataDirect SQL Server Wire Protocol
  • DataDirect Oracle Wire Protocol
  • Data Direct MySQL Wire Protocol

The default driver is the native ODBC (bullet above) driver. You can optionally use the Sybase Wire Protocol or Oracle Wire Protocol by entering the appropriate data source name (DSN) in this field. To configure a DSN, see the section entitled "Understanding and Using the ODBC Drivers" earlier in this chapter.

User Name

Specifies the user name required to log in to the specified datasource.

Password

Specifies the password associated with the User Name.

Driver Threading

Specifies whether single or multiple threading will be used for this connection.

Select the single threading box if your ODBC driver does not support multi-threading.

Selection Type

Specifies the metadata type for the connection.

  • Select Table to connect to a database table.
  • Select View to connect to a database view.

Spaces in a table or column name are not permitted.

Owner

Lists the available owner names for the above table or view in the specified Datasource. On IBM i, this lists libraries by library name.

A selection list displays all owners. Choose the owner of the table or view being connected to from the list (Optional).

Name

Lists the available table or view defined for the specified Owner.

A selection list displays all table or view names for the selected Owner. Choose the table or view to connect to.

If an owner is not specified, all names are listed for the specified Selection Type.

Spaces in a table or column name are not permitted.

Column(s)

Lists the columns defined for the specified Name.

Spaces in a table or column name are not permitted.

Comment

Enables you to add comments to the connection document that help describe its intent or usage. This is a rich text field. You can paste doclinks, as well as normal text characters here.