The Parameter Settings section of the SQL Server Adapter Connectivity Map properties contains the top-level parameters displayed in the following table.
Table 1–21 Inbound Adapter Connectivity Map Parameter Settings
Name |
Description |
Required Value |
---|---|---|
Pollmilliseconds |
Polling interval in milliseconds. |
A valid numeric value. The default is 5000. |
PreparedStatement |
The Prepared Statement used for polling against the database. |
The Prepared Statement must be the same Statement you created using the Database OTD Wizard. Only a SELECT Statement is allowed. Additionally, no place holders should be used. This is a SQL statement that cannot contain any input data (i.e. you cannot use "?" in the Prepared Query). |