Search results
+100 row not found for fetch, update or delete, or the result of a query is an empty table
Use the SQL message finder to quickly find specific SQL codes and messages. This tool allows you to search for an SQLCODE, message ID, SQLSTATE, or SQLSTATE class code.
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
If this error appears on release 2.2 and the DBRM was built on 2.3, the program needs to be precompiled again to correct the problem. The statement cannot be executed. Correct the logic of the application program to ensure that a valid SQL statement is provided in the operand of the PREPARE or EXECUTE IMMEDIATE statement before that statement ...
iSeries SQLCODE and message with the following results: v If the SQLSTATE is not recognized by DB2 UDB for iSeries, the common message for the class is issued. v If the SQLSTATE and SQLCODE correspond to a single DB2 UDB for iSeries SQLCODE, DB2 UDB attempts to convert the returned tokens into the replacement data that the SQL message expects ...
12 maj 2013 · 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.
See previous messages for more information. Check the status of the remote system and the communications network for possible problems. If the application server is DB2 for IBM i, check the QSYSOPR message queue for error messages. SQLCODE or SQLCODEs:-30080: SQLSTATE or SQLSTATEs: 08001
