Replicating test data

The following commands assume that you set up the MARKET_INDEX table for replication:

Using isql from a command prompt, insert data into the ASE source table:

insert into MARKET_INDEX values
    (10,'Test1','Test1','Test1','2006-09-18')
go
insert into MARKET_INDEX values
    (20,'Test2','Test2','Test2','2006-09-18')
go
insert into MARKET_INDEX values
    (30,'Test3','Test3','Test3','2006-09-18')
go

Log in to the target IQ database using Interactive SQL (dbisql) to select data from the target table using the following SQL statement. Verify that the data was replicated properly:
```
commit;
select * from MARKET_INDEX
```

Using isql from a command prompt, insert data into the ASE source table:

update MARKET_INDEX
    set INDEX_NAME='Update Test'
    where MARKET_INDEX_ID=20
go
delete MARKET_INDEX
    where MARKET_INDEX_ID=30
go

Use Interactive SQL for IQ (dbisql) and select data from the target table using the following SQL statement. Verify that the data was replicated properly:
```
commit;
select * from MARKET_INDEX
```