What is a db2 schema?
No Answer is Posted For this Question
Be the First to Post Answer
What does the REORG Utility do?
What is buffer pool?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
What is a Resource Control Table(RCT)? Describe its characteristics.
What is EXPLAIN?
How to resolve -818 sql code in DB2?
Define predicate?
What is null indicator in cobol db2?
What do you mean by NOT NULL? When will you use it?
What is the use of predicate?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is db2 isolation?