Answer Posted / guest
A cursor is a programming device that is used to handle the
rows that are returned by the query as the host language
(cobol) can handle only one row at a time. its also a small
file that has the result set. The cursor has to be
declared,opened, fetched and closed to access the data
returnee by the query.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Define check constraint.
List down the data types in the db2 database.
Name the various locking levels available?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Explain what are the various isolation levels possible?
What is an instance in db2?
Explain about rct in db2?
How to compare data between two tables in db2?
What is query_cache_limit?
List out the buffer pools in db2
What is the reason behind not using select * in embedded sql programs?
What r the comman abends in db2, jcl and cobol???????
What is bind in db2?
What is copy pending and check pending in db2?
