Specifications

CHAPTER 3 Managing the Database
Users Guide 83
Creating and deleting a SQL Anywhere database
In InfoMaker you work within an existing database. With one exception,
creating or deleting a database is an administrative task that is not performed
directly in InfoMaker. The one exception is that you can create and delete a
local SQL Anywhere database from within InfoMaker.
For information about creating and deleting other databases, see your DBMS
documentation.
❖ To create a local SQL Anywhere database:
1 From the Objects view, launch the Create ASA Database utility included
with the ODBC interface.
The Create Adaptive Server Anywhere Database dialog box displays.
2 In the Database Name box, specify the file name and path of the database
you are creating.
If you do not provide a file extension, the database file name is given the
extension DB.
3 Define other properties of the database as needed.
If you are using a non-English database, you can specify a code page in the
Collation Sequence box.
For complete information about filling in the dialog box, click the Help
button in the dialog box.
4 Click OK.
When you click OK, InfoMaker does the following:
• Creates a database with the specified name in the specified directory
or folder. If a database with the same name exists, you are asked
whether you want to replace it.
• Adds a data source to the ODBC.INI key in the registry. The data
source has the same name as the database unless one with the same
name already exists, in which case a suffix is appended.
• Creates a database profile and adds it to the registry. The profile has
the same name as the database unless one with the same name already
exists, in which case a suffix is appended.
• Connects to the new database.