Where could you look if you had a question about whether a
column has been defined as an index?
Answers were Sorted based on User's Feedback
Answer / sadiq afroze
This information can be found in SYSIBM.SYSINDEXES
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sushmitha
in our company we use Platinum tool.
in platinum for the option 1 - we can see if the column has
been defined as an index.
| Is This Answer Correct ? | 2 Yes | 0 No |
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What is a synonym ?
Is db2 a database?
What is ACQUIRE/RELEASE in BIND?
what is the difference between declaring the cursor in WS section and Procedure division?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is cloudant database?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Explain package in db2 and its advantages?
Explain various types of locks in db2?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?