Lotus Domino Designer 7 Help

DB2 ACCESS VIEWS

Creating a DAV
1. In Domino Designer, open the Notes database that resides in DB2 for which you want to create a DAV.

2. Select Create - Design - DB2 Access View.

3. Specify the fields (columns) to use in the DAV. Choose one of these options:

Choose Field

-- to chose from existing design elements.

In the Type field, select the design element to be used as a field source, or choose All. All instances of the chosen field selection source now appear in the left-hand list box.
Select fields for inclusion in the DAV by highlighting a field source. The fields appear in the right-hand list box.
Select all the fields that you want to include in the DAV.
Repeat for each field selection source, as required.

Insert Field

-- To add a blank field to the DAV in which you can type an existing field name or the name of one that will be added to a form associated with the DAV.

4. Set the properties for each field by double-clicking on the field and completing the Access View Entry dialog box:

Field	Action
Field name	Enter the field name if adding a new field. This is the matching field name for the DB2 column in the DAV, so it must be the actual name of a field that appears in the note (otherwise no matching field would be found and the column in the DB2 view would be blank) Note If you used the Choose Field method of specifying the fields for the DAV, you will be able to edit the field names in the properties, but if you change the field name so that it no longer matches a field name in the note, the corresponding column in the DB2 will be blank.
Notes type	Indicate the Notes data type for this field Note Formula, rich text, and rich text light Notes data types are not supported for use in DAVs.
DB2 type	Indicate the DB2 data type for this field. Notes will indicate a default value associated with the Notes type you choose. Note If you have an integer defined in the DAV, and an insert from DB2 supplies a real number (with a decimal), the insert will succeed and the decimal value will be truncated.
DB2 index field	Creates this column as a DB2 index field, which keys the database record for rapid retrieval
Allow truncation of Notes data	Specifies that the DB2 view can "clip" the notes data (only show DB2 column length characters)
Store multiple values Note: this option is enabled only for multi-value fields.	If a Notes field has multiple values, you can select to use: first value in the field only delimited values. For multi-value fields, all of the data values can appear in the view as delimited text.
DB2 multi-value delimiter	If you have chosen to use delimited values in this field, indicate the delimiter used. This delimiter is the one that will be used to separate multiple values in the DB2 column and the delimiter that will be used to parse DB2 INSERT or UPDATES into separate values. It is not related to the delimiter specified in the form design that is used by the Notes client. The default is a semicolon.
DB2 column length	This is used to define the column length in DB2 (essentially field length in Notes). This is only required for columns mapped to the DB2 Varchar data type (all other types are fixed length). The default for varchar is 100.

Note

You can change the order of the fields in the view by dragging and dropping them. For example, you may want to position frequently accessed fields at the beginning of the view.

5. Click Design - DB2 Access Views to specify the properties for the DAV itself. In the DB2 Access View dialog, complete the following:

Field	Action
Name	Enter a name for the DAV. This is the actual name of the DB2 view and must be a valid DB2 view name. If you enter spaces in the name, they will be converted to underscores in DB2 (e.g. zip code becomes zip_code).
Comment	Enter information about the DAV
Select the form(s) associated with this DB2 Access view	Specify the row selection criteria by doing one of the following: Select all forms to associate all forms in the database with the DAV. All data notes in the NSF will have a row in the access view. Select individual forms from the list box to associate with the DAV. This list is used by DB2 to determine the data with which to populate the DAV. Only data notes with a FORM item matching one of the selected values will be in the view.

6. Specify options for adding data to the DAV from DB2:

Field	Action
Compute with form on DB2 insert or update	Enable this option if the selected form(s) contain computed fields and you want the formulas to be computed when the note is created or updated using SQL.
Default form to use for DB2 inserts	DB2 users can perform inserts, updates, and deletes (given the right permissions) against data in the DAV. However, you can only perform these operations against one form associated in the DAV definition, even if multiple forms are selected. Specify the form that will be used for DB2 inserts, updates, and deletes.

7. Specify DAV options on the Advanced tab:

Field	Action
Include UNID in access view	Select to have the Notes UNID for each field appear in the DAV.
Include OID in access view	Select to have the OID for each note appear in the DAV. If SELECTed in the Query View's SQL formula, allows document links to work when notes are selected and copied as a table.
Include modified time in access view	Select this option to include the Notes modified time for each note in the DAV. Note that this timestamp is modified to GMT.
Normalize to GMT for time zone conversions	Select this option to standardize all dates and times in the DB2 view to GMT. This is especially useful for distributed DB2 applications that are accessed by users in different time zones.

8. Save the view.

9. (Optional - recommended) Click Validate. Validating the DAV verifies that the definition meets the minimum requirements to build a valid DB2 view and gives you a quick way to check the validity of the Access View definition while you are still in the DAV designer.

10. Close the view.

11. In the DAV work pane, click Create/Update in DB2.

12. Click Populate in DB2. This populates the view with the field data.

Notes:

The Populate task is an asynchronous server task. No notification of task progress is provided. Click Refresh List to check on the task status.

Populating a DAV against a large data set can be time consuming and contribute to server load. If you have created a DAV for a large database, consider populating the view during off hours.

Populating the view is a one-time event. After the view has been populated, it is kept in sync with normal Note updates and DB2 updates.

Viewing the status of your DAV

The following icons show the status of the DAV you are creating:

New DAV, not yet created or populated in DB2

New DAV that has been created in DB2 (but not yet populated)

DAV has been successfully created and populated in DB2

There is an error in the DAV

See Also

Managing DAVs

DB2 Access views

Glossary

Help on Help

All Help Contents

Glossary

Help on Help

All Help Contents

	New DAV, not yet created or populated in DB2
	New DAV that has been created in DB2 (but not yet populated)
	DAV has been successfully created and populated in DB2
	There is an error in the DAV