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
How to combine two function together?
What is database design and development?
Explain the process of the user request and data generating?
How can you log an error to the server event log from a stored procedure?
Where is dbms used?
State the acid rules?
Explain the role of indexing in databases?
Explain about query and reporting.
What are the types of database model?
What is normalization? Explain different levels of normalization?
Which data type cannot be used as a parameter in a udf?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
What are the 18 schemas?
Explain about the relational database?
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).