Verifying that RTL works

  1. Log in to the primary Adaptive Server and execute some DML operations, such as inserting new rows into testtab:

    insert into testtab values(4,4,'testrow 4')
    insert into testtab values(5,5,'testrow 5')
    insert into testtab values(6,6,'testrow 6')
    go
    
    

    This should be the output:

    (1 row affected)
    (1 row affected)
    (1 row affected)
    
    
  2. Log in to Sybase IQ and verify that the changes to testtab have replicated to the Sybase IQ database:

    select * from dbo.testtab
    go
    

    If replication is successful, this is the output:

    c1           c2           c3
    ---------    ---------    ---------
    1            1            testrow 1
    2            2            testrow 2
    3            3            testrow 3
    4            4            testrow 4
    5            5            testrow 5
    6            6            testrow 6
    (6 rows affected)