Sybase 12.4.2 manual 109

CHAPTER 3 Working with Database Objects

Using relative pathnames

•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.

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.

109