Manage Learn to apply best practices and optimize your operations.

Receiving Several Fields In A Document With Only One Dblookup

The conventional DBLookUp allows you to receive one value (field) from a
document. You indicate the fieldname or the column-number. There is a way to
receive as many values from a document as you want. This is also a way to speed
up your applications.
Create a view with one column (i.e. column-nr 4) with the following code.

field1 + "~~" + field2 + "~~" + field3 + "~~"+ field4

lookup := @DbLookup( "" : "NoCache" ; @dbname ; viewname ; key ; 4 );

so you receive a value like this: field1~~field2~~field3~~field4

with @word now you can re-extract the values

i.e. For Field3 @word(lookup;"~~";3)

Dig Deeper on Domino Resources - Part 4

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials'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 ...