Informix Error -1113

Reasons / Common Causes

-1113 fires when a BYTE or TEXT variable, located in memory, is assigned a value larger than the available data memory can hold — per the official guidance, -1319 is the equivalent error for 4GL programs specifically.

1. A BYTE/TEXT value assigned that's larger than available data memory, per the official guidance — the direct, only cause.
2. BYTE/TEXT data kept entirely in memory rather than in a file, a design choice that scales poorly as the data involved grows.

Solutions / Resolution

1. Store large BYTE/TEXT values in a file instead of memory, per the official guidance — this is the documented fix, avoiding the in-memory size limit entirely.
2. Review the program for where the oversized value is being assigned, to confirm which BYTE/TEXT variable and value are responsible.

Examples

Storing large data in a file instead

/* ESQL/C: reference a large TEXT/BYTE value via a file locator instead
   of holding it entirely in memory */
loc_t doc_loc;
doc_loc.loc_loctype = LOCFNAME;
doc_loc.loc_fname = "large_document.txt";
doc_loc.loc_oflags = LOC_RONLY;
EXEC SQL INSERT INTO documents (id, content) VALUES (1, :doc_loc);

Diagnostic Checks

1. Identify which BYTE/TEXT variable and assignment triggered the error, and consider moving that data to a file-based approach instead of in-memory storage.

Related Errors / Related Topics

• -1319 — The 4GL-program equivalent of this same memory-allocation limit for BYTE/TEXT variables.

A BYTE/TEXT value too large for available memory — store it in a file instead (see -1319 for the 4GL-program equivalent).