Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How to execute stored procedures?
What do you mean by commit and rollback?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is rebind in db2?
What is a storage group (stogroup)?
What is the physical storage length of date data type?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is sqlca’s maximum length?
How will you return the number of records in table?
What are the benefits of using the db2 database?
On which levels locks can be applied?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Explain package in db2 and its advantages?
How to take backup of table in db2?
