What is cursor in dbms?
No Answer is Posted For this Question
Be the First to Post Answer
how to resolve -811
What is load utility in db2?
How would the varchar column remarks defined?
How to see the structure of db2 table??
Plan has the optimized access path in it. But is that optimized access path is attained or known
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
what is Runstats? Whem will u choose to runatats?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
On which levels locks can be applied?
What is image copy?
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).