What is correlation names?
Answer / s
Correlation names are used in the SQL statment as an
alternate name to a qualified table.
| Is This Answer Correct ? | 0 Yes | 1 No |
How is a typical DB2 batch program executed ?
What is meant by repeatable read?
Is db2 a database?
What are bind parameters in db2?
what are bind concepts in db2 cobol?
What is copy book?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
can you use symbolic parameters in JOB?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
Are view updateable?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
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).