Arrays vs Load Lookup in SQR

Asked by: Interviewer 2831 views SQR

SQR allows you to have Arrays. It also supports a concept called Load Lookup. What are Load Lookups and how do they differ from Arrays?

bude on Feb 27, 2019 Reply

Load-Lookup contains set of keys and values that’s loads into memory.By using load lookup we can improve performance without using multiple joins in single select statement. By using lookup command we can perform the operations.

syntax:
Begin-setup
Load-Lookup
Name=Sri
Table=Rithu
key=Saru
return-value=Latha
—
End-setup

0 Votes 0 Votes 0 Votes