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 |
List some fields from sqlca?
What is cursor stability in db2?
What keyword does an SQL SELECT statement use for a string search?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
How can you compare table column after update and before update?
What information is used as input to the bind process?
What if we fail to give values in columns declared as NOT NULL ?
Which component is responsible for db2 startup and shutdown?
What is the purpose of the QUIESE Utility?
What is blu acceleration in db2?
What is buffer pool in the db2 database?