Welcome Guest. Sign in or Signup

1 Answers

Arrays vs Load Lookup in SQR

Asked by: 2441 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?

Related Questions

1 Answers



  1. 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 Thumb up 0 Votes Thumb down 0 Votes


Answer Question