Fields in the DECS Connection Document - DB2® Connection Document

The Domino® Enterprise Connection Services (DECS) connection document provides values for Connectivity and Table Selections options. The fields in the DECS connection document are described as follows.


Field	Description
Database	Specifies the name of the DB2® database.
Userid	Specifies the user name required to log in to the DB2® database. This matches the DB2® Username property.
Password	Specifies the password associated with the user name. This matches the DB2® Password property and displays as hidden text.
Data Journallng Journalled/Non-Journalled Data	Enables support for SQL queries against non-SQL data external to DB2®. When the target is a non-journaled data source SQL queries are not supported unless you enable this option. If your database does not have journaling enabled, set this to off. If your database has journaling enabled, set this to on. This option sets the access mode to read-only (transaction isolation level of uncommitted read), which enables SQL queries. The default access level is read-write (transaction isolation level committed read). The requirement for this option is most common when connecting to DB2® UDB for IBM® i tables. For non-DB2 UDB for IBM® i users, this option disables all data insert and modification operations through this connection.
Selection Type	Specifies the metadata type for a connection. Select Table to connect to a DB2® table. Select View to connect to a DB2® view. Select Procedure to connect to a DB2® stored procedure. Spaces in a table or column name are not permitted.
Owner	Lists the available owner names for the preceding table, view, or procedure selection type in the specified Database. On IBM® i, this lists libraries by library name. A selection list displays all DB2® owners. Choose the owner of the table, view, or procedure being connected to from the list (Optional).
Name	Lists the available table, view, or procedure names defined for the specified Owner. A selection list displays all DB2® tables, views, or procedures for the selected Owner. Choose the table, view, or procedure 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 or parameters (stored procedure) 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.