IBM DB2 Question:
Download Questions PDF

what is the difference between normal select query and
currosor

Answer:

using select in embedded sql with where clause should fetch
only one row , but cursor can be used when we need more rows
to be retrieved one at a time.

In case more than one row is retrieved in a select clause it
will throw -811 sql error.

Download IBM DB2 Interview Questions And Answers PDF

Previous QuestionNext Question
when we are tying to update a table having 100 rows. if the
program abends when updating 51 row . how to start updating
again from the 51 row . What was the logic?
What are Bind concepts in DB2 cobol?