Answer Posted / mani
After creating index by using CREATE command
CREATE UNIQUE INDEX IDX_EMP ON EMPLOYEE(EMP_ID)
To retreive index:
SELECT INDEX_NAME FROM USER_INDEX WHERE TBNAME='EMPLOYEE'
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Explain about cursor stability?
Can one database have multiple instances?
What is db2 catalog database?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
On which levels locks can be applied?
How to access db2 tables in mainframe?
What types of tables are there in the db2 database?
Explain the contention situations caused by locks?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How do I optimize a query in db2?
Define declaration generator (dclgen).
What is check constraint. Explain with example.
What are the full forms of spufi and dclgen and why are they used?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is ibm db2 used for?
