Informix Error -820: No more data to display.

Reasons / Common Causes

-820 fires in the interactive tool's non-scrolling display mode once every selected row has already been shown — per the official guidance, without scrolling support, previously displayed rows can't be shown again.

1. Reaching the end of the result set in a non-scrolling display, per the official guidance — the expected, normal way this message appears, not a fault.
2. An attempt to page/scroll backward in a display mode that doesn't support it.

Solutions / Resolution

1. Restart the query from the beginning, per the official guidance, if the earlier rows need to be seen again.
2. Enter a new query, per the official guidance, if a different result set is actually needed.
3. If scrolling back through results is a frequent need, check whether the interactive tool offers a scrolling display mode as an alternative to the non-scrolling default.

Examples

Restarting the query to see earlier rows again

SELECT * FROM orders WHERE status = 'pending';
-- after reaching the end of the non-scrolling display:
SELECT * FROM orders WHERE status = 'pending';
-- re-run to see the rows again from the start

Diagnostic Checks

1. Confirm this is expected — reaching the end of a non-scrolling display is normal behavior, not an error condition requiring investigation.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -820 in this set yet.

Expected behavior, not a fault — restart the query (or use a scrolling display mode, if available) to see earlier rows again.