Search results
+100 row not found for fetch, update or delete, or the result of a query is an empty table
3 cze 2008 · So, the same result in points would be 7 points (for 7 wins) + 0 points (for 4 losses) + 3.5 points (for 7 draws) = 10.5/18 or 10.5 points out of 18 possible points. Points are easier for determining ranking while the (+7 -4 =7) explains better where the points came from.
23 paź 2012 · SQlcode 100 means no records found So when WS-ACC-N is not found in TABLEA you will get Sqlcode 100 and not 0
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.
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.
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).
