The begin transaction subcommand has the following syntax:
distribute command_tags begin [system] transaction ['tran_name'] [for 'user'[/'password' | no_password]]
For the syntax and description of command_tags, see “Command tags”.
The system keyword tells Replication Server not to apply this transaction inside begin transaction/commit transaction pairs. In Adaptive Server, it is used for transactions started internally or started in system stored procedures. For LTL version 200 or later, system is available with Replication Server version 11.5 or later.
tran_name is an optional varchar(30) value that identifies the transaction. The transaction name does not have to be unique. Replication Server makes the transaction name available to function strings in a system-defined parameter.
user and password are varchar(30) values that identify the login name and password of the user executing the transaction. user and password should be enclosed in quotes. They are both required for asynchronous procedure calls submitted from a non-primary site.
For LTL version 101 or later, password is optional and can be omitted when user is supplied. For LTL version 100, password must be supplied if user is supplied.
Use the no_password option when the primary database employs a “unified login” or when the user on the primary database has set a proxy. In both cases RepAgent does not recognize a user password. For LTL version 200 or later, no_password is available with Replication Server version 11.5 or later.
