C-LANG Statements › MON_TYPE Statement—Specify the Type of Database Change to Monitor

MON_TYPE Statement—Specify the Type of Database Change to Monitor

The MON_TYPE statement specifies the type of database change to monitor for.

Supported Job Type

This statement is required for the Database Monitor job type.

Syntax

This statement has the following format:

MON_TYPE I|D|ID

I

Monitors for an increase in the number of rows in the database table.

D

Monitors for a decrease in the number of rows in the database table.

ID

Monitor for an increase or a decrease in the number of rows in the database table.

Notes:

• The specified table is polled (by default, every 10 seconds) for changes to the number of rows.
• MONTYPE is an alias of MON_TYPE.

Example: Monitor for an Increase in the Number of Rows in a Table

In the following example, the table Inventory_List is monitored for an increase in the number of rows in the table. By default, the database is checked for changes every 10 seconds. When the number of rows increases the job completes.

AGENT CYBDB1
TABLE_NAME Inventory_List
MON_TYPE I