Interested to Buy Any Domain ? << Click Here >> for more details...
a cursor normally gets closed once we provide a commit . If
u try to close the same cursor with close cursor command
later after providing the commit will there be any sql-error.
- 3 Answers
- 7671 Views
- I also Faced
- E-Mail Answers
Answer Posted / manasa
WHEN THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS
NOT OPEN,then we get -501 error.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How many databases are there?
How would the varchar column remarks defined?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
Explain about cursor stability?
What is schema in db2?
What is the picture clause of null indicator variable?
What is an instance database?
What is check constraint in db2?
Explain about open switch business continuity software?
What is difference between alias and synonym in db2?
What is the usage of open cursor command?
What is copy pending and check pending in db2?
Is schema the same as database?
What do you mean by storage group (stogroup)?
