Where could you look if you had a question about whether a
column has been defined as an index?
Answer Posted / sadiq afroze
This information can be found in SYSIBM.SYSINDEXES
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Mention some fields that are a part of sqlca.
How to check last update on table in db2?
What os does db2 run on?
what is the role of the cursor in db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
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 ?
What is a plan and package in db2?
What is the max length of sqlca?
Before you give the explain statement, what are the prerogatives?
Explain package in db2 and its advantages?
How can you classify the locks in db2?
What is the function of logging in the db2 database?
what is utility for parm lib
How to find the number of rows in a db2 table?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference