You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Array and Load-Lookup

1 reply [Last post]
Guest's picture

hi, can any body explain about diff between load lookup and array?

Lepa's picture
User offline. Last seen 2 years 26 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Array and Load-Lookup

Load Lookup will get populated at compilation time, and we can adjust the size of the load-lookup and the size can actually increase automatically. It is normally used to reduce the complexity of joins so users can query from a preloaded load-lookup instead of joining tables.

Arrays on the other hand gets populated at Execution time. We can not modify the size of the array once the array has been created and you retrieve array data using the get and put commands.

There might be other differences that I've missed but I think I've covered a good portion :)

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog