File name
The file name for the new database. Usually you should use the {db_location} macro to specify the path for your database.
For example, {db_location}\mydatabase.db. If an Agent will manage more than one SQL Anywhere database then you must create each database in a separate directory.
It is recommended that you place each database in a separate subdirectory of the {db_location} directory.
CHAR collation
Specifies the collation for CHAR, VARCHAR and LONG VARCHAR data types in the new database.
NCHAR collation
For SQL Anywhere only, specifies the collation for NCHAR, NVARCHAR and LONG NVARCHAR data types in the new database.
This command can only be used in a remote task marked as Requiring or Creating a Remote Database.
The type of database (UltraLite or SQL Anywhere) created by the command is determined by the remote schema name specified
for the remote task. If the file name specified uses a directory that does not exist on the remote device then the directory
is created. The file name specification may be absolute or relative. If a relative file name is specified, it is taken to
be relative to the current working directory of the Agent. This is not supported for SQL Anywhere in Windows Mobile.
The CREATE DATABASE statement can be used to initialize a database on a desktop computer, which can later be copied to a Windows
Mobile device.
Parameters