DSQL Functions

Go Up to Function Categories

The following table summarizes the InterBase API functions available for handling DSQL statements built or entered by users at run time:

DSQL functions

Function name	Purpose
isc_dsql_allocate_statement()	Allocate a statement handle.
isc_dsql_alloc_statement2()	Allocate a statement handle that is automatically freed on database detachment.
isc_dsql_batch_execute()	Batch and execute data in a parametized SQL statement.
isc_dsql_batch_execute_immed()	Batch and execute a group of INSERT, UPDATE, DELETE or DDL commands.
isc_dsql_describe()	Fill in an XSQLDA with information about values returned by a statement.
isc_dsql_describe_bind()	Fill in an XSQLDA with information about the input parameters of a statement.
isc_dsql_execute()	Execute a prepared statement.
isc_dsql_execute2()	Execute a prepared statement returning a single set of values.
isc_dsql_execute_immediate()	Prepare and execute a statement without return values for one-time use.
isc_dsql_exec_immed2()	Prepare and execute a statement with a single set of return values for one-time use.
isc_dsql_fetch()	Retrieve data returned by a previously prepared and executed statement.
isc_dsql_free_statement()	Free a statement handle, or close a cursor associated with a statement handle.
isc_dsql_prepare()	Prepare a statement for execution.
isc_dsql_set_cursor_name()	Define a cursor name and associate it with a statement handle.
isc_dsql_sql_info()	Request information about a prepared statement.

Advance To:

• Error-handling Functions