Using isql interactively

To use isql interactively:

  1. If necessary, start the Replication Server, as described in “Starting 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.

    NoteYou 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. Refer to Chapter 8, “Replication Server System Tables,” in the Replication Server Reference Manual for more information on system tables and the stored procedures you can use to query them.