Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 14. Utilities and Options Reference       

The SQL Remote Open Server

Purpose 

To take replication data from Replication Server and apply it to the SQL Remote stable queue. This utility is needed only for databases participating in both Replication Server (and using a Replication Agent) and SQL Remote replication.

Syntax 

ssqueue [ switches ] [ open-server-name ]

Command-line switches 

Switch	Description
open-server-name	An open server name, which must be declared in the interfaces file (sql.ini).
-c "keyword=value; ..."	Supply database connection parameters
-cq "keyword=value; ..."	Supply database connection parameters for the stable queue
-dl	Display messages in window
-o file	Output messages to file
-v	Verbose operation

Description 

The SQL Remote Open Server is used to enable an Adaptive Server Enterprise database to take part in both SQL Remote replication while acting as a primary site in a Replication Server installation (or a replicate site using asynchronous procedure calls).

The name of the executable is as follows:

• ssqueue.exe     Windows NT platforms.

• ssqueue     UNIX platforms.

Command-line switch details 

open-server-name     Replication Server must connect to the SQL Remote Open Server, which therefore must have an open server name. This open server name is set on the command line, and must correspond to a master and query entry in the interfaces file (sql.ini) on the machine running the SQL Remote Open Server, and to a query entry on the interfaces file of the machine running Replication Server.

The default value for the open server name is SSQueue.

-c "parameter=value; ..."     Specify connection parameters to the database holding the data being replicated. This connection is required for the SQL Remote Open Server to gain access to the SQL Remote system tables.

The connection parameters must come from the following list:

Parameter	Description
UID	Login ID
PWD	Password
DBN	(optional) Database name. If this parameter is not supplied, the connection defaults to the default database for the login ID.
ENG	Server name.

-cq "parameter=value; ..."     Specify connection parameters for the stable queue. If not supplied, the values default to the -c values.

-dl     Display messages in the window or on the command line and also in the log file.

-o     Append output to a log file. Default is to send output to the screen.

-v     Verbose output. This switch displays the SQL statements contained in the messages to the screen and, if the -o switch is used, to a log file.