Using Data-at-Execution Parameters

    To handle data-at-execution text or image parameters

1. When calling SQLBindParameter to bind a program buffer to the statement parameter:
   • Use a pcbValue of SQL_LEN_DATA_AT_EXEC(length) where length is the total length of the text or image parameter data.
   • Use an rgbValue of a program-defined parameter identifier.
2. Calling SQLExecDirect or SQLExecute returns SQL_NEED_DATA, which indicates that data-at-execution parameters are ready for processing.
3. For each data-at-execution parameter
   1. Call SQLParamData to get the program-defined parameter ID. It will return SQL_NEED_DATA if there is another data-at-execution parameter.
   2. Call SQLPutData one or more times to send the parameter data, until length is sent.
4. Call SQLParamData to indicate that all the data for the final data-at-execution parameter has been sent. It will not return SQL_NEED_DATA.