Chapter 4. Tutorialsfor Adaptive Server Anywhere Users
❖Toadd a remote user
1. Select the SQL Remote Users folder.
2. From the File menu, choose New ➤SQL Remote User.
TheCreate a New Remote User wizard appears.
3. Create a remote user with user ID field_user with the following options:
♦Enterthe password field_pwd.
♦Ensurethat Remote DBA authority is selected, so that the user can run
theMessage Agent.
♦Selectthe message type FILE, and enter the address field.
Aswith the publisher address, the address of the remote user is taken
relativeto the SQLREMOTE environment variable or registry entry.
Asyou have not set this value, the address is taken relative to the
directoryfrom which the Message Agent is run. Youshould run the
MessageAgent from your tutorial directory for the addresses to be
interpretedproperly.
☞Forinformation about setting the SQLREMOTE value, see
“Settingmessage type control parameters” on page 214.
♦Ensurethat the Send Then Close option is selected.
(Inmany production environments you would not choose Send Then
Close,but it is convenient for this tutorial.)
4. When you have finished, click Finish to create the remote user.
Youhave now created the users who will use this system.
Add publications and subscriptions
Thissection describes how to add a publication to a database, and how to
adda subscription to that publication for a user. Thepublication replicates
allrows of the table SalesRep and some of the rows of the Customer table.
❖Toadd a publication
1. Select the Publications folder in the left pane.
2. From the File menu, choose New ➤Publication.
ThePublication Creation wizard appears.
3. Name the publication SalesRepData.
4. On the Tables tab, select SalesRep from the list of Available Tables.
ClickAdd.
Thetable appears in the list of Selected Tables on the right.
37