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
- 9184 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 are the levels of isolation available with DB2V4
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is ibm db2 database?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
What do you mean by between and in? Is between inclusive of specified range values?
Can SQL statements/queries be included in a copybook?
What's the maximum number of characters that a tablename can have?
What is nvl in db2?
why we create view.
How does DB2 use multiple table indexes?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
COBOL 
