NOTIFY_MODULUS option

Controls the default frequency of notify messages issued by certain commands.

Any integer

DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.

100000

This option sets the default number of notify messages Sybase IQ issues for certain commands that produce them. The NOTIFY clause for some of the commands (such as CREATE INDEX, LOAD TABLE, and DELETE) will override this value. Other commands that do not support the NOTIFY clause (such as SYNCHRONIZE JOIN INDEX) will always use this value. Its default virtually does not restrict the number you can receive.