You can specify the sqlda pointer in the USING DESCRIPTOR clause of the EXECUTE statement.
Each time the EXECUTE statement is run, the values that the descriptor structure describes are used to replace question-mark ( ? ) placeholders in the PREPARE statement.
The sqlda.sqld value specifies the number of input values that are described in occurrences of sqlvar. This number must correspond to the number of dynamic parameters in the prepared statement.
The following example shows how to use an sqlda structure to execute a prepared statement in ESQL/C:
EXEC SQL execute prep_stmt using descriptor pointer2
Related statements: ALLOCATE DESCRIPTOR, DEALLOCATE DESCRIPTOR, DECLARE , EXECUTE IMMEDIATE, FETCH , GET DESCRIPTOR , PREPARE, PUT , and SET DESCRIPTOR
For a task-oriented discussion of the EXECUTE statement, see the IBM Informix Guide to SQL: Tutorial.
For more information about concepts that relate to the EXECUTE statement, see the IBM Informix ESQL/C Programmer's Manual.