Search results
SQLCODE = 100: No data was found. For example, a FETCH statement returned no data because the cursor was positioned after the last row of the result table. +100: SQLCODE > 0 and not = 100: Successful execution with a warning. +sqlcode-num: SQLCODE < 0: Execution was not successful. -sqlcode-num
- SQL codes
SQLCODE = 100: No data was found. For example, a FETCH...
- Error (−) SQL codes
SQLCODE = 100: No data was found. For example, a FETCH...
- SQL codes
SQLCODE = 100: No data was found. For example, a FETCH statement returned no data because the cursor was positioned after the last row of the result table. +100: SQLCODE > 0 and not = 100: Successful execution with a warning. +sqlcode-num: SQLCODE < 0: Execution was not successful. -sqlcode-num
SQLCODE = 100: No data was found. For example, a FETCH statement returned no data because the cursor was positioned after the last row of the result table. +100: SQLCODE > 0 and not = 100: Successful execution with a warning. +sqlcode-num: SQLCODE < 0: Execution was not successful. -sqlcode-num
Error code can be handled in the program by using SQLCODE validation after each query executed. Most of very frequent error codes described below. The SQLCODE is equal to 000, the query executed successfully.
+100: ROW NOT FOUND FOR FETCH, UPDATE OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE: One of the following conditions occurred: * No row met the search conditions specified in an UPDATE or DELETE statement. * The result of a SELECT INTO statement was an empty table.
21 wrz 2018 · When you try to update a row and the condition in where clause is not matched, then DB2 returns +100 SQL code. +100 SQL Code + 100 ROW NOT FOUND FOR FETCH, UPDATE OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE.
12 maj 2013 · When I execute the exact same query with hardcoded WHERE statements in SQL Server Management Studio, data is retrieved as expected. The SQLCODE I receive is 100. When I omit the PERFORM VARYING loop and give my query hardcoded data, my QUESTION-CODE and ANSWER-CODE fields contain the correct data, but the AMOUNT one is first empty, then zero.
