Home
HCL Domino Designer User Guide and Reference
This guide provides information on using HCL Domino Designer and programming language reference information.
DB2® Access views
Domino® Designer includes two types of design elements to assist you in managing data contained in DB2® enabled Notes® databases:
DAV security
It is important to note that even though DAVs exist in DB2®, Domino® still manages user access to them. The ability to read Domino data from DB2 is enforced with the same basic security as that for using the NSF itself. Therefore, in order to access a DAV through DB2, the DB2 user's associated Notes® ID must:

HCL Domino Designer User Guide and Reference
This guide provides information on using HCL Domino Designer and programming language reference information.
- What's new in Domino Designer 14.5?
  The following features are new for developers in HCL Domino® Designer 14.5.
- What's new in Nomad Designer?
  HCL Nomad for web browsers v1.0.10 introduces the capability to design Notes databases. For more information, see HCL Nomad for web browsers User Documentation, Nomad web Designer.
- Accessibility and keyboard shortcuts
  Accessibility features assist users who have a disability, such as restricted mobility or limited vision, to use information technology content successfully.
- Application Design
  Welcome to the Application Design section of Domino® Designer Help.
- Application Management
  Welcome to the Application Management section of Domino® Designer Help.
- Domino® Query Language
  Domino® Query Language (DQL) is a facility running on a Domino server that provides a terse, shorthand syntax for finding documents. It supports a wide variety and complexity of search terms. It leverages existing design elements, avoiding the need to write detailed code to access them. DQL consolidates all methods in Domino for searching document contents.
- Composite Applications - Design and Management
  Composite applications are a key element in a service-oriented architecture (SOA) and contextual collaboration strategy. The ability to create and edit composite applications lets you easily integrate different types of components and technologies.
- DB2® Access views
  Domino® Designer includes two types of design elements to assist you in managing data contained in DB2® enabled Notes® databases:
  - DAV security
    It is important to note that even though DAVs exist in DB2®, Domino® still manages user access to them. The ability to read Domino data from DB2 is enforced with the same basic security as that for using the NSF itself. Therefore, in order to access a DAV through DB2, the DB2 user's associated Notes® ID must:
  - Creating a DAV
  - Managing DAVs
    Once you have created a DAV, you can use Domino® Designer to edit the dav definition, or DB2® or Notes® to act on data it contains.
  - Troubleshooting DAVs
- Programming Overview and User Interface
  This section contains general guidelines and examples that show where to use Java, LotusScript, and the formula language.
- Formula Language
  This section documents the formula language.
- LotusScript® Language
  Welcome to the LotusScript® Language section of Domino® Designer Help.
- LotusScript/COM/OLE Classes
- Java/CORBA Classes
  This section documents the Java/CORBA classes.
- Connectors
  Connectors provide native access to a wide variety of DBMS products, ODBC, the platform File system, Enterprise Resource Planning systems, and Transaction Processing systems.
- Javadoc™ for Domino® Designer related APIs
  As part of providing additional Java™ reference documentation, Domino® Designer ships with a help plugin that contains Javadoc™ for additional Domino Designer related APIs.

DAV security

It is important to note that even though DAVs exist in DB2®, Domino® still manages user access to them. The ability to read Domino® data from DB2® is enforced with the same basic security as that for using the NSF itself. Therefore, in order to access a DAV through DB2®, the DB2® user's associated Notes® ID must:

Have access to the Domino® server on which the DB2® enabled Notes® database resides.
Have access to the DB2® enabled Notes® database.
Have proper Notes® Access Control List (ACL) permissions to perform the requested operation. For example, the user must have Reader access or higher to issue a SELECT against the DAV, and they must have Author or Depositor access to INSERT into the DAV
Be included in the reader lists of the specific notes that are included in the DAV.

Note: Because notes in NSFs translate to rows in DB2® enabled Notes® databases, Domino® essentially adds row level security to DB2® data through the use of reader lists. If two different users perform a select on a DAV (SELECT * from test.dav), they might get different numbers of rows returned, depending on the notes to which they have read access

Furthermore, the following must be true in order for either a Domino® Designer or DB2® user to access DAVs:

The Domino® server on which the DB2® enabled NSF resides must be up and running.
The user who is trying to access this data must have both a DB2® OS account name ID (to use in the SQL connect statement) and a Notes® User ID.
In order to run any query views, Notes® data or federated data, You need a DB2® OS account name in addition to your Notes® user ID. These IDs must be linked in the Domino® Directory via a DB2® account name in your Person document (Administration tab). This maps your Notes® ID to a DAV or QV. Have the Domino® Administrator use the "Set DB2® user name" tool in the Domino® Administrator Client to set this field.
The DB2® user must have access to the DAV itself (this is the default when the DAV is created in Designer)