Sybase DC38133-01-0902-01 manual Utility on, To create a database file named field.db

	♦ 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	You can create an Adaptive Server Anywhere database using the dbinit
Server Anywhere	utility. A simple Adaptive Server Anywhere database is a file, unlike
database	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

Loading the data into the database

The -boption forces use of blank padding in string comparisons. The -coption enforces case sensitivity for string comparisons. The -koption makes the system catalog more compatible with Adaptive Server Enterprise.

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