Is it mandatory to use DCLGEN? If not, why would you use it
at all?
Answer Posted / guest
Just an addition to the above answer. By using the DCLGEN,
the program would use correct data types and column lengths
which avoids stage 2 processing of predicates, if the data
types and lengths mismatched.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is db2 restart?
How to check table size in db2 sap?
What do you mean by rollback?
What is database alias db2?
What is a bind in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What are bind parameters in db2?
What are the two types of logging in the db2 database? Explain them.
What is the default page size of buffer pools?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How is deadlock resolved?
What is a db2 schema?
How to find the number of rows in a db2 table?
What is the maximum number of columns in a db2 table?
How can you count the number of rows from a table tab?