Interested to Buy Any Domain ? << Click Here >> for more details...
Is it mandatory to use DCLGEN? If not, why would you use it
at all?
- 2 Answers
- 8990 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhisek
No,it is not mandatory to use DCLGEN,it is used by the pre-
compiler to validate the table names,view names and column
names during pre-compile.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
what is Runstats? Whem will u choose to runatats?
What DB2 Catalog column tell you when an index needs table reorganized ?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is the meaning of -805 SQL return code?
What is PRIME TABLE and what are the uses of it
What types of tables are there in the db2 database?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
How do you select a row using indexes in db2?
How to resolve -805 error in DB2?
Explain what are the various isolation levels possible?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
How do I change the column size in db2?
COBOL 
