Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > SET AUTOFREE >

Closing Cursors Implicitly

A potential problem exists with cursors that have the Autofree feature enabled. In a database that is not ANSI-compliant, if you do not close a cursor explicitly and then open it again, the cursor is closed implicitly. This implicit closing of the cursor triggers the Autofree feature. The second time the cursor is opened, the database server generates an error message (cursor not found) because the cursor is already freed.

Related Information

Related statements: CLOSE , DECLARE , FETCH , FREE , OPEN , and PREPARE

For more information on the Autofree feature, see the IBM Informix ESQL/C Programmer's Manual.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]