SAP Note 27829 - Informix: dbaccess->table->info->status fails

Symptom:

Key word: INF DBACCESS
The status query of a table with 'dbaccess -> table -> info -> status' does not return all values.
The query 'Commit/Rollback?' appears when leaving the menu

Cause and prerequisites

The selected table or the Informix Dictionary are blocked by another transaction.

Solution
After starting 'dbaccess' with the menu point 'query', enter the SQL statement 'set isolation to dirty read'. Call up the status of the affected table, as before.
The isolation level, once set, is retained for the entire session, unless it is changed explicitly.