1.

What Is Load-lookup? Give The Syntax For Load-lookup?

Answer»

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


Discussion

No Comment Found

Related InterviewSolutions