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

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  

---

Before you give the explain statement, what are the prerogatives?

0 Answers  

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

How does coalesce work?

0 Answers  

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

can we view the access paths created by dbrm ? how ? thx

2 Answers   IBM,

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---

What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,

---

How to see the structure of db2 table??

4 Answers   IBM,

---

What is explain plan in db2?

0 Answers  

---