Sybase DC38133-01-0902-01 manual 318, Hh nn mm Ss.s

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

hh nn mm

ss[.s. . . ]

Description

Two digit hours (24-hour clock)

Two-digit minutes

Two-digit minutes if following a colon (as in hh:mm)

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