What DB2 Catalog column tell you when an index needs table
reorganized ?
Mention some fields that are a part of sqlca.
What's the difference between DB2 active log and archive log? Thanks a lot...
When DB2 connection fails, will online program work or give errors.
How to define the a field which accepts value till 99999.99 in db2
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What is the use of COMMAREA ?Minimum how much data we can pass from it?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What do you need to do before you do EXPLAIN ?
What is ibm db2 used for?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What else is there in the PLAN apart from the access path?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?