How many clustering indexes can be defined for a table?
Answer Posted / s
Only one clustering index can be defined.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is host variable?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
Mention the definition of cobol in varchar field.
How to check last update on table in db2?
What is coalesce in db2?
What is the max length of sqlca?
Define check constraint.
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is multi row fetch in db2?
What is lock escalation in db2?
What is node in db2?
What are the uses of db2 optimizer?
How can deadlocks be resolved?
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 ?...
What is ibm db2 used for?