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 the SQL query to select, delete and get count of duplicate rows in DB2?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
How to update more then one record using update?
List out the data types available.
What is pagespace?
What keyword does an SQL SELECT statement use for a string search?
What do you mean by NOT NULL? When will you use it?
What is the difference between static and dynamic SQL?
What is scrollable cursor in db2?
Where is the output of EXPLAIN stored?
What is a db2 package?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations