An example

This section provides instructions for performing a simple update in the primary database, and then viewing the replicated changes in the replicate database.

Log in to the primary Adaptive Server using the isql utility. For example:
```
isql -Usa -P -Sprimary_dataserver_name
```
The isql prompt appears:
```
>1
```
Choose the primary database. For example, enter:
```
1> use pubs2
2> go
```
Verify that Chastity Locksley is listed in the au_lname and au_fname columns of the authors table. To view all author names in the authors table, enter:
```
1> select au_fname, au_lname 
2> from authors
3> go
```
Adaptive Server prints out the contents of the au_fname and au_lname columns.

Change the name of Chastity Locksley to Chastity Hilton in the authors table. Enter:

1> update authors
2> set au_lname = “Hilton”
3> where au_lname = “Locksley”
4> go

Verify that the change has taken place at the primary database. For example, enter:
```
1> select au_fname, au_lname
2> from authors
3> where au_fname = “Chastity”
4> go
```
The primary Adaptive Server prints out “Chastity Hilton.”
Log in to the replicate Adaptive Server using the isql utility. For example:
```
isql -Usa -P -Sreplicate_dataserver_name
```
The isql prompt appears.
Choose the replicate database. For example, enter:
```
1> use pubs2
2> go
```
Verify that the change has replicated to the replicate database. Enter:
```
1> select au_fname, au_lname
2> from authors
3> where au_fname = “Chastity”
4> go
```
The replicate Adaptive Server prints out “Chastity Hilton.” Congratulations! You have a working replication system.