Where could you look if you had a question about whether a
column has been defined as an index?
Answers were Sorted based on User's Feedback
Answer / sadiq afroze
This information can be found in SYSIBM.SYSINDEXES
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sushmitha
in our company we use Platinum tool.
in platinum for the option 1 - we can see if the column has
been defined as an index.
| Is This Answer Correct ? | 2 Yes | 0 No |
wht is d/f between union and joins ?
what is the name of the default db2 catalog database?
How to resolve deadlock issue
How do you find the maximum value in a column in db2?
Describe what a storage group(STOGROUP) is?
What does db2 stand for?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
How can the duplicate values be eliminated from db2 select?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
What is dbrm? What it contains?
What are the 4 environments which can access DB2 ?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?