What does CURRENTDATA option in bind indicate
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 able to find all the Table names under a Particular Plan?
How to select the duplicate rows from a table?
Why might full image copies be faster to implement than an incremental image copy?
What is a Resource Control Table(RCT)? Describe its characteristics.
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
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 the picture clause of null indicator variable?
Can you Average the Characters ?
What is database manager in db2?
How does the processing of a correlated subquery differ from a non correlated subquery?
How connect db2 database to datastage?
What is auditing?