Answer Posted / raghu
first we have to def indexs.
select indexname from sysibm.sysindexs where tbname = tablename
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is dbrm? What it contains? When it will be created?
What is commit in db2?
What is reorg and runstats in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How is a typical db2 batch pgm executed?
What is the physical storage length of the data types date, time, and timestamp?
Explain the benefits you can get from mainframe connect?
How can deadlocks be resolved?
What is multi row fetch in db2?
What is the maximum size of a char data type in db2?
What does runstats do in db2?
Why cursor is used in db2?
What are the full forms of spufi and dclgen and why are they used?
What is drop table?
How do you select a row using indexes in db2?