Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the max length of sqlca?
What is a system catalog table in db2?
Which component is responsible for db2 startup and shutdown?
If I have a view which is a join of two or more tables, can this view be updateable?
How do I change the column size in db2?
Explain package in db2 and its advantages?
How to restart a DB2 program?
What is consistency token in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is bind and rebind in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Where do you specify them?
How can you count the number of rows from a table tab?
How do I start db2 in windows?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
