HP NonStop SQL/MX - Page 25

HP NonStop SQL/MX Messages Manual—640324-001
2-1
2
General Messages (0 through 999)
SQL 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.
100 The "no data" completion condition (SQLCODE = +100).