Starting with Notes/Domino Version 7, you can do a join. You can back-end the Lotus Notes database with DB2, and use DB2 Access Views and Query Views to publish selected Lotus Notes fields in relational tables. You can then build a Query View that displays data from those tables. The Select statement is written in SQL, so your DB2 knowledge will come in handy.
Do you have comments on this Ask the Expert Q&A? Let us know.
Related information from SearchDomino.com:
Dig Deeper on Lotus Notes Domino Coding and Development
Related Q&A from Andre Guirard
Learn how you can use LotusScript and OLE to create and populate Microsoft Excel spreadsheets, as well as a little bit about Lotus Symphony. Continue Reading
Discover options you can use if you'd like external users to be able to access a workflow-based Notes Domino application through different ... Continue Reading
Learn why you may receive the error message: "Illegal circular use: Audit Trail" when trying to open Lotus Notes documents that use copied forms. Continue Reading