Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

subscribe_by_remote option [SQL Remote]

Controls the interpretation of NULL or empty-string SUBSCRIBE BY values.

Allowed values

On, Off



  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY USER DEFINED OPTION Yes Yes, with SET ANY USER DEFINED OPTION
Allowed to set temporarily? No No No

When the option is set to On, operations from remote databases on rows with a SUBSCRIBE BY value that is NULL or an empty string assume that the remote user is subscribed to the row. When it is set to Off, the remote user is assumed not to be subscribed to the row.

The only limitation of this option is that it leads to errors if a remote user really does want to INSERT (or UPDATE) a row with a NULL or empty subscription expression (for information held only at the consolidated database). This is reasonably obscure and can be worked around by assigning a subscription value in your installation that belongs to no remote user.