What is the maximum size of varchar data type in db2?
No Answer is Posted For this Question
Be the First to Post Answer
What is catalog database in db2?
How many databases can be created inside an instance in db2 ?
What is a page in db2?
What is read-only cursor?
What is the size of a data page?
What do you mean by commit and rollback?
What is cascading rollback?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
How can you get the number of rows impacted by the last executed query?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
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 an instance in db2?