What is a composite index and how does it differ from a
multiple index?
Answer / s
Composite index consists of two or more columns
A tablespace can have multiple indexes.
But the column to be indexed can only appear once in the
index
| Is This Answer Correct ? | 0 Yes | 2 No |
what is the difference between normal select query and currosor
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
Can a Db2 table data be retrived through JCL?
What is isolation level in db2?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is a thread?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is filter factor?
How do I change the column size in db2?
What does db2 blu stand for?