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

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers  

---

What are common abends

1 Answers   SPIC, Virtusa,

---

What kind of database is db2?

0 Answers  

---

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?

3 Answers   CTS,

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

What is DCLGEN?

2 Answers  

---

What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,

---

What is syscat in db2?

0 Answers  

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

how to fetch multiple records without using cursor

14 Answers   HCL,

---

What is the difference between oracle and db2?

0 Answers  

---

What is the maximum length of sqlca?

0 Answers  

---