Filter
Top Products
Chapter 5. A Tutorial for Adaptive Server Enterprise Users
2. Connect to the server using the Interactive SQL utility:
dbisql -c "eng=field;dbn=field;uid=DBA;pwd=SQL"
The user ID and password must be entered in upper case, as the Adaptive
Server Anywhere database was created as case-sensitive.
3. Load the data using the READ command:
READ C:\TUTORIAL\RELOAD.SQL
❖ To load the data into the database as a batch process
1. Start an Adaptive Server Anywhere server running on the field database:
dbeng9 field.db
2. Run the script from Interactive SQL:
dbisql -c "eng=field;dbn=field;uid=DBA;pwd=SQL" reload.sql
The user ID and password must be entered in upper case, as the Adaptive
Server Anywhere database was created as case-sensitive.
What next? The system is now ready for replication.
☞ For the next step, inserting and replicating data, see the section “Start
replicating data” on page 66.
65