Interested to Buy Any Domain ? << Click Here >> for more details...
What does CURRENTDATA option in bind indicate
- 1 Answers
- 8978 Views
- IBM, I also Faced
- E-Mail Answers
Answer / s
CURRENTDATA tells DB2 whether data upon which the cursor is
positioned should remain current with the data in the base
table.
| Is This Answer Correct ? | 8 Yes | 0 No |
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What is table space in db2?
Define predicate?
What are some characteristics of columns that benefit from indexes?
can we view the access paths created by dbrm ? how ? thx
What is syscat in db2?
When DB2 connection fails, will online program work or give errors.
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
Which catalog table stores referential constraints?
What are the Isolation levels 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).
Explain correlated sub-queries.
COBOL 
