User's Manual

♦ uid=sa The login ID to use to log on to the database.
♦ pwd=sysadmin The password to use to log on to the database.
♦ C:\tutorial\field The directory in which to place files holding the data.
♦ field_user The user ID for which to extract the database.
☞ For more information on extraction utility options, see “The extraction
utility” on page 303.
Running this command produces the following files:
♦ Reload script The reload script is named reload.sql , and is placed in
the current directory.
♦ Data files Files containing data to load into the database. In this case,
these files are empty.
Creating an Adaptive
Server Anywhere
database
You can create an Adaptive Server Anywhere database using the dbinit
utility. A simple Adaptive Server Anywhere database is a file, unlike
Adaptive Server Enterprise databases.
You should create the Adaptive Server Anywhere database so that it is
compatible with Adaptive Server Enterprise database behavior, unless you
have set options in your Adaptive Server Enterprise server that are different
from the default.
❖ To create a database file named field.db
1. Enter the following command from the c:\tutorial\field directory:
dbinit -b -c -k field.db
The -b option forces use of blank padding in string comparisons. The -c
option enforces case sensitivity for string comparisons. The -k option
makes the system catalog more compatible with Adaptive Server
Enterprise.
Loading the data into the
database
You can load the data into the database using the Adaptive Server Anywhere
Interactive SQL utility or the rtsql utility. rtsql is an alternative to
Interactive SQL for batch processes only, and is provided for the runtime
database.
❖ To load the data into the database using Interactive SQL
1. Start an Adaptive Server Anywhere server running on the field database:
dbeng9 field.db
64