Please allow ads on our site
Please log in to access this content. You will be redirected to the login page shortly.
LoginWhat Is Load-lookup? Give The Syntax For Load-lookup?
Structured Query Report (sqr) Tutorial Structured Query Report (sqr) Interview Questions in Structured Query Report (sqr) Tutorial 3 years ago
The LOAD-LOOKUP COMMAND defines an array containing a SET of KEYS and values and loads it into memory. With LOAD-LOOKUP, you can REDUCE the number of tables that are joined in one SELECT. Use this command in conjunction with one or more LOOKUP commands.
Syntax: begin-setup
load-lookup
name=prods
table=products
key=product_code
return_value=description
end-setup
The LOAD-LOOKUP command defines an array containing a set of keys and values and loads it into memory. With LOAD-LOOKUP, you can reduce the number of tables that are joined in one SELECT. Use this command in conjunction with one or more LOOKUP commands.
Syntax: begin-setup
load-lookup
name=prods
table=products
key=product_code
return_value=description
end-setup
Posted on 20 Feb 2022, this text provides information on Structured Query Report (sqr) Tutorial related to Structured Query Report (sqr) Interview Questions in Structured Query Report (sqr) Tutorial. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.
Take Quiz To Earn Credits!
Turn Your Knowledge into Earnings.
Answers
No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
