SPBeforePollCall

This property names the stored procedure that is executed for every poll call. If the property SPBeforePollCall has a value (the name of a stored procedure), then at the start of each poll call, the connector calls the stored procedure, passing it the values of the connector properties ConnectorID and PollQuantity. The procedure will update PollQuantity number of rows, setting the connector-id column to ConnectorID where status=0 and connector-id is null. This enables load balancing in the connector.

Note:
In the case where a poll call fails prematurely (the database is down, or the connection is lost), the connector-id remains set. This may result in records being skipped during polling. It is therefore recommended that periodically, the connector-id is reset back to null for all records in the event table with a status of 0.

Default value: None

Possible values: The name of the stored procedure to be executed for each poll call

Required: No

Copyright IBM Corp. 1997, 2004