Method 1: Non-query Statements Without Parameters

Go Up to DSQL Programming Methods

There are two ways to process a SQL statement string containing a non-query statement without placeholder parameters:

• Use isc_dsql_execute_immediate() to prepare and execute the string a single time.
• Use isc_dsql_allocate_statement() to allocate a statement string for the statement to execute, isc_dsql_prepare() to parse the statement for execution and assign it a name, then use isc_dsql_execute() to carry out the statement’s actions as many times as required in an application.

Topics

• Using isc_dsql_execute_immediate()
• Using isc_dsql_prepare() and isc_dsql_execute()