General messages (0 through 999)

SQL 100

100 The "no data" completion condition (SQLCODE=+100).


You have reached the end of a cursor, and there is no more data to be returned. When you enter a noncursor query (SELECT * FROM t WHERE...; DELETE FROM t WHERE...;), SQL/MX returns warning 100 to indicate that zero rows satisfied the predicate, and zero rows were affected. In embedded SQL/MX, on a cursor FETCH, SQL/MX returns this warning to indicate that it has reached the end of rows.


You will not be able to get any more rows from this cursor or SELECT statement.


This is an informational message. Start a new cursor for a new read.