Interested to Buy Any Domain ? << Click Here >> for more details...
how can you access index
- 4 Answers
- 9400 Views
- IBM, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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'
| Is This Answer Correct ? | 4 Yes | 1 No |
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.
| Is This Answer Correct ? | 5 Yes | 3 No |
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
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / raghu
first we have to def indexs.
select indexname from sysibm.sysindexs where tbname = tablename
| Is This Answer Correct ? | 1 Yes | 0 No |
Which component is used to execute the sql statements?
i have a db2 variable how do u declare tht into working storage section ?
What is cursor?
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
What is the difference between dbm cfg and db cfg file in db2 ?
How to create backup table in db2?
What is meant by dclgen?
What is IMAGECOPY ?
what is the difference between join and union?
What are the functions in DB2?
What is the use of predicate?
Name some fields from SQLCA
COBOL 
