Answer Posted / 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 |
Post New Answer View All Answers
What are the 2 sqlcodes that are returned?
What is the difference between bind and rebind in db2?
What is node in db2?
Is db2 a programming language?
How do I connect my db2 database to ibm?
What is copy pending status in db2?
What is dbrm?
What is db2 bind?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How does a cursor work?
How to create backup table in db2?
How is deadlock resolved?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How can you do the explain of a dynamic sql statement?
Explain the contents that are a part of dclgen.