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
When Db2 executes an SQL statement, it returns information about the statement execution. This information includes the SQL return code (SQLCODE) and the SQLSTATE, which indicate whether statement execution was successful. The SQLCODE value is set by Db2 after each statement is executed, as shown in the following table.
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.
23 paź 2012 · premkrishnan wrote: Did you try a Spufi and execute for count (*) where you have no records meetting a condition? I can explain it to you, but i can not understand it for you.
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).
SQL return codes that are preceded by a minus sign (−) indicate that the SQL statement execution was unsuccessful. The SQLCODE value is set by Db2 after each statement is executed, as shown in the following table. Successful execution, if SQLWARN0 is blank. If SQLWARN0 = 'W', successful execution with warning. No data was found.
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.
