What is meant by index cardinality?
Answers were Sorted based on User's Feedback
Answer / prabhavathi p
A sequential arrangement of material.
directs attention to some fact, condition;
| Is This Answer Correct ? | 2 Yes | 0 No |
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is isolation level in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
What is the role of data manager in the db2 database?
What is a page in db2?
What is the difference between cursor and select statement?
What parameters are used to control the free space in DB2?
Explain about cursor stability?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx