Informix Error -6062: Dbsetfileview cannot be used when any column within the table allows nulls.
Cause and resolution
Dbsetfileview cannot be used when any column within the table allows nulls.
Because the buffer that dbsetfileview() constructs does not use alignment, dbsetfileview() cannot build a buffer for columns that might have null values.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-6062 fires when dbsetfileview() is used on a table with any nullable column — per the archived catalogue, the buffer dbsetfileview() builds doesn't use alignment, so it can't accommodate columns that might hold null values.
- A table with at least one nullable column, per the archived catalogue — the direct, only cause.
Solutions / Resolution
- Use dbsetstructview() instead, if available and appropriate, for tables with nullable columns — dbsetfileview()'s non-aligned buffer is specifically incompatible with them per the archived catalogue.
Examples
N/A
No specific triggering statement is documented beyond the function-level condition described above.
Diagnostic Checks
- Check whether any column in the table allows nulls.
Related Errors / Related Topics
No closely related error codes are cross-referenced for this code in this set yet.
dbsetfileview()'s unaligned buffer can't represent nullable columns — it only works on tables where every column is not-null.