>>-DEALLOCATE ROW--:variable-----------------------------------><
 

DEALLOCATE ROW frees all the memory that is associated with the ESQL/C typed or untyped row variable that variable identifies. If you do not explicitly release memory resources with DEALLOCATE ROW, deallocation occurs automatically at the end of the program. To deallocate memory for an ESQL/C collection variable, use the DEALLOCATE COLLECTION statement.

After you deallocate a ROW variable, you can use the ALLOCATE ROW statement to reallocate resources, and you can then reuse a ROW variable. The following example shows how to deallocate resources for the ROW variable, a_row, using the DEALLOCATE ROW statement:

EXEC SQL BEGIN DECLARE SECTION; row (a int, b int) a_row;
EXEC SQL END DECLARE SECTION;
. . .
EXEC SQL allocate row :a_row;
. . .
EXEC SQL deallocate row :a_row;

Related statements: ALLOCATE ROW and DEALLOCATE COLLECTION

For a discussion of ROW data types, see the IBM Informix Guide to SQL: Tutorial. For complex data types, see the IBM Informix ESQL/C Programmer's Manual.