Load look up in sqr, where did you use?

Interview Candidate
Sep 5th, 2005
4
3399

Showing Answers 1 - 4 of 4 Answers

Ariraj S

Sep 5th, 2005

The LOAD-LOOKUP command defines an array containing a set of keys and
values and loads it into memory. The LOOKUP command looks up a key in the
array and returns the associated value. In some programs, this technique
performs better than a conventional table join.
LOAD-LOOKUP can be used in the SETUP section or in a procedure. If used in
the SETUP section, it is processed only once. If used in a procedure, it is
processed each time it is encountered.
LOAD-LOOKUP retrieves two fields from the database, the KEY field and the
RETURN_VALUE field. Rows are ordered by KEY and stored in an array. The
KEY field must be unique and contain no NULL values.
When the LOOKUP command is used, the array is searched (using a ?binary?
search) to find the RETURN_VALUE field corresponding to the KEY referenced
in the lookup.