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
- 7072 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
What is universal database?
What is nvl in db2?
What are the two types of logging in the db2 database? Explain them.
How to test SQL -911 error while developing COB-DB2 program
What are iseries servers?
Explain package in db2 and its advantages?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What kind of database is db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
List out the data types available.
Which isolation level provides maximum concurrency?
What is the maximum length of sqlca?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the purpose of using commit?
what is diffrence b/w file-aid tool and file-aid utility???
