User's Manual

are also upper case.
For the digit formats, the case of the option setting controls padding. If the
symbols are the same case (such as DD), the number is padded with zeroes.
If the symbols are mixed case (such as Mm), the number is not zero padded.
SR_Time_Format option The Message Agent uses this option when
replicating columns that store a time. The option is a string build from the
following symbols:
Symbol Description
hh Two digit hours (24-hour clock)
nn Two-digit minutes
mm Two-digit minutes if following a
colon (as in hh:mm)
ss[.s... ] Two-digit seconds plus optional
fractions of a second.
Using mixed case in the formatting string suppresses leading zeroes.
SR_Timestamp_Format The Message Agent replicates datetime
information using this option. For Adaptive Server Anywhere this is the
timestamp, datetime, and smalldatetime data types. For Adaptive Server
Enterprise, this is the datetime and smalldatetime data types.
The format strings are taken from the SR_Date_Format and
SR_Time_Format settings.
The default setting is the SR_Date_Format setting, followed by the
SR_Time_Format setting.
Subscribe_by_remote option When set to ON, operations from remote
databases on rows with a subscribe by value that is NULL or an empty string
assume the remote user is subscribed to the row. When set to OFF, the
remote user is assumed not to be subscribed to the row.
The only limitation of this option is that it will lead 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.
☞ For more information about this option, see “Using the
Subscribe_by_remote option with many-to-many relationships” on
page 118, and “Using the Subscribe_by_remote option with many-to-many
318