Problem solve Get help with specific problems with your technologies, process and projects.

Can I switch to DECS to retrieve external data upon exiting a key field?

I am a UK Notes 6 developer who is about to inherit a system that uses Lotus Domino to connect to an Oracle DB.

I want to avoid having to install native connectivity on all my clients, so can I switch to DECS to retrieve external data upon exiting a key field? That is, as part of document creation in a form, the user enters a customer order number and then exits the field. Upon doing this, other fields are populated with data from the Oracle DB obtained via the key field entered (e.g., work orders, customer name, etc.).

From what I have read about DECS, data retrieval can only be initiated by higher level triggers like opening and closing a form. Any ideas or suggestions will be gratefully received. Thanks.
The key to this is to use a form and infobox to get the key information from the user, then, when they enter the information, open a lookup document that inhertits the key value and triggers the DECS lookups.

Dig Deeper on LEI and DECS for Lotus Notes Domino

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...