Specifies whether the provider should wait for bulk operation results to complete when using the asynchronous Bulk API. Only applies when UseBulkAPI is set to true.

Data Type

bool

Default Value

false

Remarks

When WaitForBulkResults is set to false, the driver submits bulk data modification operations to Certinia and returns control immediately without waiting for the job to finish processing. This results in faster execution, but result details are not yet available. In this case, the Info#TEMP table contains information about the created batch or job which you can use with stored procedures to manually retrieve the final results.

When WaitForBulkResults is set to true, the driver waits for Certinia to finish processing each bulk operation before returning. This enables the LastResultInfo#TEMP table to include detailed information about each affected row, such as IDs, status values, and any error messages, without requiring additional queries.

Retrieving Results

The job and batch IDs found in either Info#TEMP or LastResultInfo#TEMP can be used with stored procedures to retrieve detailed job and batch results:

• Bulk API v1: GetJob, GetBatch, GetBatchResults
• Bulk API v2: GetJobInfoV2, QueryResultsV2

Performance Considerations

Choosing not to wait for results reduces execution time and allows your application to continue sooner, but requires additional follow-up steps to track success or failure. Enabling this property introduces more processing time, but provides detailed results in a single operation.

This property is useful for balancing speed versus detailed operational insight in bulk data modification workflows.