Chapter 4. Tutorialsfor Adaptive Server Anywhere Users
mkdir c:\tutorial\HQ
mkdir c:\tutorial\field
3. Create the HQ database:
♦StartSybase Central.
♦Inthe left pane, select the Adaptive Server Anywhere plug-in.
♦Inthe right pane, click the Utilities tab.
♦Double-clickCreate Database in the right pane.
TheCreate Database wizard appears.
♦Createa database with filename
c:\tutorial\HQ.db.
Usethe default settings for this database.
AnAdaptive Server Anywhere database is simply a file, which can be
copiedto other locations and computers when necessary.
Thenext step is to add a pair of tables to the consolidated database.
❖Toadd tables to the consolidated database
1. Connect to the HQ database from Sybase Central, with a user ID of DBA
anda password of SQL.
2. Select the Tables folder of the HQ database in the left pane.
3. From the File menu, choose New ➤Table and create a table named
SalesRepusing the TableCreation wizard.
4. Add the following columns to the table (you can add a column by
choosingFile ➤Add Column):
Key Column DataType Size/Prec
Primarykey Rep_key char 5
Name char 40
Youdo not need to use the Column property sheet.
5. Save the table by choosing File ➤Save Table or pressing Ctrl+S.
6. From the File menu, choose New ➤Table and create a table named
Customerwith the followingcolumns:
Key Column DataType Size/Prec
Primarykey Cust_key char 10
Name char 40
Rep_key char 5
33