DB2 sqlcode -811 is expected when a query returns more than one row .
When DB2 sqlcode -811 is the issue,then
first we should find what are the keys for which 2 rows are returned
then decide what to be done .That is either to delete one row or handle multiple rows in the query(implement cursor logic).
For more understanding on how the issue can be handled,read here DB2 sqlcode -811
When DB2 sqlcode -811 is the issue,then
first we should find what are the keys for which 2 rows are returned
then decide what to be done .That is either to delete one row or handle multiple rows in the query(implement cursor logic).
For more understanding on how the issue can be handled,read here DB2 sqlcode -811
No comments:
Post a Comment