EXPERT RESPONSE
The Redbook Domino Designer 6 A Developer's Handbook is a good place to start. Notes/Domino is very unlike the relational database you're used to. There are no joins. You can design forms that use key data in the current document to look up data from views in the same or other databases, and display those values on the form without storing them there. But you can't do that in a view.
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:
Learning Guide: DB2
Tip: DECS and DCR external data access considerations
Tip: Changing a Lotus Notes database mail file from 'archive' to 'mail'
Reference Center: Lotus Notes/Domino database resources and tips
|
