arealso upper case.
Forthe digit formats, the case of the option setting controls padding. Ifthe
symbolsare the same case (such as DD), the number is padded with zeroes.
Ifthe symbols are mixed case (such as Mm), the number is not zero padded.
SR_Time_Formatoption TheMessage Agent uses this option when
replicatingcolumns that store a time. The option is a string buildfrom the
followingsymbols:
Symbol Description
hh Twodigit hours (24-hour clock)
nn Two-digitminutes
mm Two-digitminutes if following a
colon(as in hh:mm)
ss[.s.. .] Two-digit seconds plus optional
fractionsof a second.
Usingmixed case in the formatting string suppresses leading zeroes.
SR_Timestamp_Format TheMessage Agent replicates datetime
informationusing this option. ForAdaptive Server Anywhere this is the
timestamp,datetime, and smalldatetime data types. ForAdaptive Server
Enterprise,this is the datetime and smalldatetime data types.
Theformat strings are taken from the SR_Date_Format and
SR_Time_Formatsettings.
Thedefault setting is the SR_Date_Format setting, followed by the
SR_Time_Formatsetting.
Subscribe_by_remoteoption When set to ON, operations from remote
databaseson rows with a subscribe by value that is NULL or an empty string
assumethe remote user is subscribed to the row. When set to OFF, the
remoteuser is assumed not to be subscribed to the row.
Theonly limitation of this option is that it will lead to errors if a remote user
reallydoes want to INSERT (or UPDATE) a row with a NULL or empty
subscriptionexpression (for information held only at the consolidated
database). This is reasonably obscure and can be worked around by
assigninga subscription value in your installation that belongs to no remote
user.
☞Formore information about this option, see “Using the
Subscribe_by_remoteoption with many-to-many relationships” on
page118, and “Using the Subscribe_by_remote option with many-to-many
318