Answer / 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'

Answer / pandu

first of all create index
create index<indexname> on <tablename>(<columnname>);
after that we have to access to that by
Select * from <indexname>


Correct me is am i wrong...
Thank You.

Answer / ashok kumar

we generally use the folling query for create index

CREAT INDEX <index name> on <table name>(cols1,cols2,...)

for accessing columes :

SELECT ENAME FROM EMP
WHERE cols1 and cols2

Answer / raghu

first we have to def indexs.
select indexname from sysibm.sysindexs where tbname = tablename

What is the use of runstats in db2?

0 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---

What is IMAGECOPY ?

6 Answers  

---

What is package versioning? Please give an example.

1 Answers  

---

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.

2 Answers   Syntel,

---

What is dbrm? When it will be created?

0 Answers  

---

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,

---

What's The Error Code For Unique Index Voilation?

0 Answers   IBM,

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

---

Which command is used to remove all rows from a table?

0 Answers  

---

What is a trigger in the db2 database?

0 Answers  

---