How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What are some SQL aggregates and other built-in functions?
List out the buffer pools in db2
why we create view.
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
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
What is check constraint in db2?
what is rebinding ?
what's the error code for Unique Index Violation?
what are the bind parameters?
What is database reorganization?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).