What do you do to keep the cursor from closing after a
commit?
Answer / guest
You add the keyword "WITHHOLD" to the declare statement of
the cursor
| Is This Answer Correct ? | 20 Yes | 0 No |
What is an instance database?
What is meant by explain?
List out the buffer pools in db2
How do I delete a column in db2?
select distinct(empid),distinct(dept),name from EMP will the above query work?
Update command
Can we insert update delete in view?
What db2 400?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What are types of indexes?
When is the authorization check on DB2 objects done - at BIND time or run time?
What is the purpose of using commit?