Notifier property sheet: Logic tab

Properties are read at startup. When you change properties, you must shut down and restart the MobiLink synchronization server for them to take effect.

The Logic tab of the Notifier property sheet has the following components:

When this notifier event occurs    Select one of the following Notifier events that causes the SQL statement below to execute. When you select an event from the dropdown list, the contents of the SQL statement pane below change to the SQL statement for the selected event.

• begin_connection    The SQL statement runs in a separate transaction after the Notifier connects to the database and before the first poll. If the Notifier loses its connection to the consolidated database, it will re-execute this transaction immediately after reconnecting.

  For more information, see .

• begin_poll    The SQL statement is executed before each Notifier poll.

  For more information, see .

• end_connection    The SQL statement runs as a separate transaction just before a Notifier database connection is closed.

  For more information, see .

• end_poll    The SQL statement is executed after each poll.

  For more information, see .

• request_cursor    The SQL statement for the Notifier to collect push requests from the consolidated database. You must specify a SQL statement for this event. The result set of this statement must contain five columns, and can optionally contain two other columns. These columns can have any name, but must be in the following order in the result set:

  • request id

  • gateway

  • subject

  • content

  • address

  • resend

  • interval time to live

  For more information, see .

• request_delete    The SQL statement specifies cleanup operations. The statement takes the request id as its only parameter. The placeholder for a parameter is a question mark (?).

  You should define a SQL statement for this event unless you have provided another process to do the cleanup.

  For more information, see .

• shutdown_query    The SQL statement is executed right after begin_poll. The result should contain only the value yes (or 1) or no (or 0). To shut down the Notifier, specify yes or 1.

  For more information, see .

Execute this SQL statement    Type the SQL statement that is to be executed when the specified Notifier event occurs.

See also