In Db2, Is It Always Mandatory To Use Dclgen? If Not, Why Would You U

1.	In Db2, Is It Always Mandatory To Use Dclgen? If Not, Why Would You Use It At All?
Answer» It is not always MANDATORY to use DCLGEN USING DCLGEN, helps detect wrongly spelt column names etc during the pre- compile stage itself ( because of the DECLARE TABLE ) DCLGEN being a tool, would GENERATE accurate host variable definitions for the table reducing CHANCES of error. It is not always mandatory to use DCLGEN Using DCLGEN, helps detect wrongly spelt column names etc during the pre- compile stage itself ( because of the DECLARE TABLE ) DCLGEN being a tool, would generate accurate host variable definitions for the table reducing chances of error.

In Db2, Is It Always Mandatory To Use Dclgen? If Not, Why Would You Use It At All?

Answer»

It is not always MANDATORY to use DCLGEN USING DCLGEN, helps detect wrongly spelt column names etc during the pre- compile stage itself ( because of the DECLARE TABLE ) DCLGEN being a tool, would GENERATE accurate host variable definitions for the table reducing CHANCES of error.

It is not always mandatory to use DCLGEN Using DCLGEN, helps detect wrongly spelt column names etc during the pre- compile stage itself ( because of the DECLARE TABLE ) DCLGEN being a tool, would generate accurate host variable definitions for the table reducing chances of error.

Discussion

No Comment Found

Related InterviewSolutions

Explain What Are The Disadvantages Of Page Level Lock In Db2?
Explain In Brief How Does Db2 Determine What Lock-size To Use?
Name The Various Locking Levels Available?
When Do You Specify The Isolation Level?
Differentiate Between Cs And Rr Isolation Levels?where Do You Specify Them?
Explain What Are The Various Isolation Levels Possible ?
Explain How Can You Do The Explain Of A Dynamic Sql Statement?
What Does It Mean - Explain Has Output With Matchcols = 0?
Can You Tell Where Is The Output Of Explain Stored?
Can You Tell What Do You Need To Do Before You Do Explain?