Begin detailed description.

This figure is a flowchart that depicts the functions that you call to pass multiple values to parameter markers. Two different methods that pass multiple values are depicted in the flowchart. One of these methods uses an array insert, and one method does not. In this description, these methods are presented in two separate tables respectively.

The following table describes the process that uses an array to pass multiple values to parameter markers. Each row in this table represents a function call in this process. Each of these functions are required. The functions are presented in the order in which you call them in your application.
Function call Description
SQLAllocHandle() Allocates a statement handle.
SQLPrepare() Prepares the SQL query.
SQLBindParameter() Binds parameter markers in the SQL statement to arrays. You call this function once for each parameter marker in the SQL statement.
SQLSetStmtAttr() Specifies the number of elements each array contains with the SQL_ATTR_PARAMSET_SIZE statement attribute
SQLExecute() Executes the SQL statement. You call this function only once to execute the SQL statement with each set of values.
SQLFreeHandle() Frees the statement handle.
The following table describes the process that does not use arrays to pass multiple values to parameter markers. Each row in this table represents a function call in this process. Each of these functions is required. The functions are presented in the order in which you call them in your application.
Function call Description
SQLAllocHandle() Allocates a statement handle.
SQLPrepare() Prepares the SQL query.
SQLBindParameter() Binds parameter markers in the SQL statement to application variables. You call this function once for each parameter marker.
SQLExecute() Executes the SQL statement. You call this function once for each set of values that you use for the parameter markers.
SQLFreeHandle() Frees the statement handle.

End detailed description.