Accessing documents in a Lotus Notes database
Notes/Domino development expert Andre Guirard offers a new Notes/Domino developer and DBA some advice on accessing documents in a Lotus Notes database.
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: