Search results
11 sty 2012 · The statement returns sqlcode 100 and does not throw an exception. From the Oracle documentation I understand that the error code is accompanied by an exception. What may be the reason behind this behaviour? The documentation says the error code 100 is DATA NOT FOUND; we have data for the select query.
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.
17 wrz 2024 · SQLCODE 100 signifies that a query has successfully executed, but no rows were found that match the criteria. How can I handle SQL error codes in my application? You can handle SQL error codes by implementing error handling mechanisms in your application code.
SQLCODE=100 indicates that the SQL operation was successful, but found no data to act upon. This can occur for a number of reasons. For a SELECT these include: the specified table contains no data; the table contains no data that satisfies the query criteria; or row retrieval has reached the final row of the table.
So it means, 100 is the SQL code of success and failure for SPUFI. Not necessarily (at least not as worded). In your case, you should get the 100 at "end" or if there are no rows found. The 100 is raised when "ROW NOT FOUND" which might be caused by a few other things also (look in the DB2 Messages and Codes linked to from the forums).
+100 row not found for fetch, update or delete, or the result of a query is an empty table
19 sty 2018 · I can see that record is present in DELTA1, but I am getting SQLCODE 100(record not found). I displayed the values to see whether correct values are populated in host variables, that also looks fine. Try to run sql by itself outside the program and see what happens.
