ASA Create Database Preferences

The ASA create database preferences determine the default values for creating new ASA databases.

Table 1. ASA Create Database preferences: Options
Property	Description
Create an ASA Connection Profile for This Database	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, WorkSpace generates a new connection profile name by appending a number to the existing name.
Ignore Trailing Blanks in String Comparisons	Select this option to be compatible with ISO/ANSI SQL. Default is that blanks are significant for comparisons.
Case Sensitive for String Comparisons	Select 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	Include checksums 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.

Table 2. ASA Create Database preferences: Java support
Property	Description
Java Support	Install support for jConnect meta-information. This property is automatically enabled if you enabled the Create an ASA Connection Profile for This Database property.

Table 3. ASA Create Database preferences: page size
Property	Description
Database Page Size	Size in bytes of pages. The default is 2048 bytes.