The CREATE DATABASE statement has two required parameters and several optional parameters.
You must specify the file name for catalog store and the IQ PATH. All other parameters are optional.
Case-sensitive (CASE RESPECT). “ABC” compares NOT EQUAL to “abc”. The default login is user ID DBA (uppercase) and password sql (lowercase). By default, passwords are case sensitive. User names are always case insensitive.
Catalog page size of 4096 bytes (PAGE SIZE 4096).
When comparing two character strings of unequal length, IQ treats the shorter one as if it were padded with blanks to the length of the longer one, so that ‘abc’ compares equal to ‘abc’ (BLANK PADDING ON).
Incompatible with Adaptive Server Enterprise.
IQ page size is 128KB (IQ PAGE SIZE 131072).
IQ message file and IQ temporary store are in the same directory as the catalog store.
For a raw device, IQ SIZE and TEMPORARY SIZE are the maximum size of the raw partition. For operating system files, see the discussion of this parameter below.
IQ temporary store size is half the IQ size.
jConnect JDBC driver is enabled (JCONNECT ON).
The collation ISO_BINENG is used. The collation order is the same as the order of characters in the ASCII character set. In a case-sensitive database, all uppercase letters precede all lowercase letters (for example, both 'A' and 'B' precede 'a').
IQ RESERVE and TEMPORARY RESERVE are 0.
SYSTEM PROCEDURE AS DEFINER is OFF.