Answer Posted / rbs
Hi S,
Above, u defined the INDEX. Is index and Leaf Pages are
same?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the role of the data page in the db2 database?
What is a dbrm in db2?
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 ?
What is role in db2?
define clustering index.
What is cursor with hold option in db2?
What is dbrm library?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is the difference between bind and rebind in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How do you concatenate the firstname and lastname from emp table to give a complete name?
Mention the various locks that are available in db2.
What is buffer pool and list some of them?
What is declare cursor?
What do you mean by between and in? Is between inclusive of specified range values?