Deleting records in a query view
You can delete records in a query view through Notes or in DB2. Refresh the view to update the Query view display. However, it is important to remember that, when using Notes, you can only delete DAV (Notes) data, not federated data.

Inserting/updating records in a query view
You can insert and update records in a query view through DB2 or Notes. However, because query views are not dynamic, not all new documents or changes to existing documents display immediately. After changes, rebuild the view using Shift-F9 to update the query view display.

Separating multi-value items
DAVs store text lists as a text string, and since Query Views read data directly from DB2, that is exactly what is returned to a Query View. So, if you have a multi-value item that you want to separate out in your QV, you must use the @Explode formula on the column that contains multiple values. In addition, to ensure that the view is set up to handle many lines of data, on the View properties - Style tab, set the Row Height and Shrink Rows to Content options to accommodate your data.

Updating query views
As query views can be built from a combination of Notes and federated data, how the query view is updated depends on the nature of the data that was added or changed and how it was added.

• On the Options tab of the View Properties box, select "Maximum number of rows returned by a SQL query" and then specify the number of rows.
• Add the NOTES.INI variable DB2QueryViewRowLimit=value to the server's NOTES.INI file. Set the value to 0 for "unlimited" rows returned. Without this variable, the default is 500 rows.

For more information about NOTES.INI variables, see the NOTES.INI Appendix in the Domino Administrator help.

See Also

DB2 query views

Glossary