Following is a illustration of how to perform a @DBLookup when the source of data resides in an entirely different database and server.
var dbName=Server-Name+"!!"+Database-Path
result= @DbLookup(dbName,viewName,lookupKey, {lookupField or column no})
This is a small trick which most of us would often forget and wont care about....
It can turn into a real head ache though..... :)
Hope this helps.
Thanks IBM for giving us so much adequate documentation.
ReplyDelete