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 optimizer?
What is null in db2?
What are db2 objects?
Explain packages.
What are the two types of logging in the db2 database? Explain them.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Is schema the same as database?
How does db2 sample database connect?
What does db2 plan contain?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How to find the number of rows in a db2 table?
What is a page in db2?
What is a collection in db2?