how to resolve -811
Answers were Sorted based on User's Feedback
Answer / srini
Declare cursor instead of singleton select,as the query you
are running has multiple records.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is a buffer pool?
What do you do to keep the cursor from closing after a commit?
How does a cursor work?
Is the primary key a clustered index?
where can we use index and subscript ? with example ?
what is the difference between join and union?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
Is ibm db2 open source?
What are the prerogatives?