Filter
Top Products
CHAPTER 3 Working with Database Objects
109
• Case sensitive (
CASE RESPECT).’ABC’ compares NOT EQUAL to
‘abc’. Note that the default login is now user ID DBA and password SQL
(uppercase). Passwords are case sensitive for a case-sensitive database,
and case-insensitive for a case-insensitive database. Usernames are always
case insensitive.
• Catalog page size of 2048 bytes (
PAGE SIZE 2048).
• 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 64KB (
IQ PAGE SIZE 65536).
• IQ message file and IQ Temporary Store are in the same directory as the
Catalog Store. See also “Using relative pathnames”.
• 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 sequence 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').
• Java is enabled (
JAVA ON).
Note Either CREATE DATABASE commands must include CASE IGNORE, or
else connections to newly created databases must be made with case-sensitive
userid/password combinations.
For a full description of all parameters, see the
CREATE DATABASE statement
in the Adaptive Server IQ Reference Manual. Following are several examples
of creating an IQ database.
Using relative
pathnames
You can create a database using a relative or fully qualified pathname for each
of the files for the database. Sybase recommends that you create databases with
relative pathnames.
If your database is on UNIX, you can define a symbolic link for each pathname,
as described in the Adaptive Server IQ Reference Manual.