Using isql Interactively

You can use isql interactively for simple operations.

  1. If necessary, start the Replication Server.
  2. Log in to the Replication Server using the following command:
    isql -Uuser_name -Ppassword -Sserver_name

    Specify the name of the Replication Server using the -S flag.

    If your login is accepted, isql displays a prompt:
    1>
  3. Enter the RCL command you want to execute.

    When you press the Return key at the end of a line, isql increases the line number. Some commands require more than one line.

  4. To execute the command, enter “go” (on a line by itself, with no blanks) and press Return.

    To cancel the command, enter “reset” and press Return. The prompt’s line number is reset to 1.

    Some RCL commands display immediate results. Others execute asynchronously, that is, they return a system prompt without necessarily having completed the desired action and report only syntax errors.

  5. To exit isql, enter “quit” at the beginning of a line.
Note: You can check the status of asynchronous commands by executing RCL commands that display status or by querying the RSSD system tables at the affected sites. See Replication Server Reference Manual > Replication Server System Tables for more information on system tables and the stored procedures you can use to query them.
Related tasks
Starting Replication Server