General messages (0 through 999)

SQL 100

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

Cause

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.

Effect

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

Recovery

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