Where could you look if you had a question about whether a
column has been defined as an index?
- 2 Answers
- 5225 Views
- I also Faced
- E-Mail Answers
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 |
Mention the downsides of page level lock.
How many databases are there?
What is auditing?
What are the four lockable units for DB2?
On the create tablespace, what does the CLOSE parameter do?
What are packages in db2?
Explain correlated sub-queries.
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
COBOL 
