What are cursors? Explain different types of cursors?

Answer Posted / vishnuvardhan reddy

in db2 there are two types of cursors
1.scrolable cursor
2.non scrolable cursor

scrolable cursor:
scrolable cursor can be moved in sequential
forword (or)backword direction in the resultant table.

Non scrolable cursor:
simplest cursor is the non scrolable cursor
it is always moved in a sequential direction.

Is This Answer Correct ?    2 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to combine two function together?

1665


What is database design and development?

609


Explain the process of the user request and data generating?

658


How can you log an error to the server event log from a stored procedure?

563


Where is dbms used?

625






State the acid rules?

688


Explain the role of indexing in databases?

645


Explain about query and reporting.

1694


What are the types of database model?

550


What is normalization? Explain different levels of normalization?

59850


Which data type cannot be used as a parameter in a udf?

580


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3441


What are the 18 schemas?

615


Explain about the relational database?

613


When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

1789