Is DECLARE TABLE in DCLGEN necessary? Why it used?
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.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How can I declare methods within my JSP page? 06.01.09
You can declare methods for use within your JSP page as declarations. The methods can then be invoked within any other methods you declare, or within JSP script...How can I declare methods within my JSP page 24.12.08
You can declare methods for use within your JSP page as declarations. The methods can then be invoked within any other methods you declare, or within JSP script...How to declare the Temp table ? 23.07.08
#TableName ##TableName Global declaration...When is the results table for the query in a DECLARE CURSOR statement created ? 10.04.08
The results table for a query specified in a DECLARE CURSOR statement of a cursor is created during the execution of the OPEN CURSOR statement....Can we declare DB2 HOST variable in COBOL COPY book ? 24.03.08
NO. If we declare DB2 host variable in COBOL COPY book, at the time of Pre-compilation we get the host variable not defined, because pre-compiler will not expan...Is it mandatory to use DCLGEN? If not, why would you use it at all? 12.03.08
It is not mandatory to use DCLGEN. Using DCLGEN, helps detect wrongly spelt column names etc. during the pre-compile stage itself (because of the DECLARE TABLE...What are the contents of a DCLGEN ? 12.03.08
EXEC SQL DECLARE TABLE statement which gives the layout of the table/view in terms of DB2 datatypes.A host language copy book that gives the host variable defin...What is Declaration Generator(DCLGEN) 09.03.08
DCLGEN is a facility that is used to generate SQL statements that describe a table or view. These table or view descriptions are then used to check the validity...What are the types of tables? 14.04.07
1) Transparent table 2) Pool table 3) Cluster table are data dictionary table objects 4) Sorted table 5) Indexed table 6) Hash table 7) Internal tables....How can I declare methods within my JSP page? 26.03.06
You can declare methods for use within your JSP page as declarations. The methods can then be invoked within any other methods you declare, or within JSP script...