If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
No Answer is Posted For this Question
Be the First to Post Answer
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Which isolation level provides maximum concurrency?
What is a plan and package in db2?
What is a predicate?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is a view? Why use it?
How to connect to db2 database from windows command line?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
How does one remove entries from the SCT02 table?
What is the use of commit in db2?
What is a db2 schema?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)