Is DECLARE TABLE in DCLGEN necessary? Why it used?

Answer Posted / obularaju

It not necessary to have DECLARE TABLE statement in
DCLGEN. This is used by the pre-compiler to validate the
table-name, view-name, column name etc., during pre-compile

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is release/acquire in bind?

663


What is the role of the data page in the db2 database?

594


What is db2 stogroup?

685


Can we insert update delete in view?

584


What is dpf in db2?

677






What are the rules for db2 programming?

652


Can you use max on a char column?

645


What is db2 bind process?

766


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

756


What is the difference between cursor stability and repeatable read isolation levels?

693


How would the varchar column remarks defined?

645


What are the different types of base tables?

590


How do we specify index to include or not during bind process.

1680


Which component is responsible for db2 startup and shutdown?

635


What is a page in db2?

619