Overview

The driver dynamically retrieves notes and views from your Domino database and models them as tables and views. Domino notes are modeled as tables. Domino views are modeled as views.

Tables, Views, Columns and Stored Procedures

Simple and Display Names

The driver supports options for controlling how tables, views, and columns are named:

Note Metadata

In addition to the items defined on each note, Domino exposes metadata about each note that the driver maps to special columns. These columns are:

• unid The unique note identifier, which identifies this specific note across all databases on the server. This is available in all tables and views.

Note that some column names will be different when UseSimpleNames is enabled because they can contain special characters.

Null Values

Domino does not have a direct equivalent of the SQL NULL value. The driver reports NULL values for columns in these scenarios:

• When an item is not set on a note. In Domino formulas, this is equivalent to @IsAvailable(item) = 0.
• When a single-valued item on a note is the empty text value. In Domino formulas, this is equivalent to @IsNull(item) = 1. Here, a single-valued item is an item on the base table or view where the driver did not find any multi-value entries during type detection.

Tables

Available tables are listed using System Tables queries.

For example:

SELECT * FROM sys_tables WHERE TableName = 'Person'

Views

Available views are listed using System Tables queries.

For example:

SELECT * FROM sys_tables WHERE TableName = '($Account)'

Columns

Available columns on tables and views are listed using System Table Columns queries.

For example:

SELECT * FROM sys_tablecolumns WHERE TableName = 'Person'

Stored Procedures

Stored procedures allow you to execute operations to Domino Attachments can be manipulated via the DownloadAttachment, UploadAttachment, and RemoveAttachment stored procedures.