how can you access index

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


Please Help Members By Posting Answers For Below Questions

How to find the maximum value in a column in the db2 database?

611


Which command is used to connect to a database in DB2 ? Give the Syntax.

602


What does db2 mean?

587


What is db2 purescale?

550


What are iseries servers?

566






What is dclgen (declaration generator)?

603


How to view db2 table structure?

593


What type of database is db2?

523


Explain the contents that are a part of dclgen.

659


Which isolation level provides maximum concurrency?

666


What are bind parameters in db2?

613


How to resolve deadlock issue

17972


How do I add a column to a table in db2?

618


How can you find out the # of rows updated after an update statement?

641


What is the picture clause of null indicator variable?

691