Setting ASA Create Database Preferences

Create an ASA connection profile for this database

Click this option to create a new Adaptive Server Anywhere connection profile, and automatically install jConnect meta-information. (Default.)

The default name is the same as the database name. If a connection profile with the same name as the database already exists in WorkSpace, the tooling generates a new connection profile name by appending a number.

Ignore trailing blanks in string comparisons

Click this option to be compatible with ISO/ANSI SQL. Default is that blanks are significant for comparisons.

Case sensitive for string comparisons

Click this option to be compatible with ISO/ANSI SQL. Default is that all comparisons are case insensitive. User IDs and other identifiers are case insensitive, even in case sensitive databases.

Include checksum with each database page

Checksums are used to determine whether a database page has been modified on disk.

ASE compatible

Do not create the SYS.SYSCOLUMNS and SYS.SYSINDEXES views. Default is to create these tables, for compatibility with Watcom SQL. These views conflict with Adaptive Server Enterprise compatibility views dbo.syscolumns and dbo.sysindexes.

Install jConnect meta-information support

Click this option to use the Sybase jConnect JDBC driver to access system catalog information. You do not need to install jConnect to use JDBC for other purposes. Selected automatically when you select Create an ASA connection profile for this database.

Database page size, in bytes

Select a page size from the drop-down list. Default is 2048.

The page size when you create the database cannot be larger than the page size used by the current Adaptive Server Anywhere server. The first set of databases started sets the server page size.