Filter
Top Products
CHAPTER 3 Working with Database Objects
113
Choosing a block size for your database
Example
The following statement creates a large database on a UNIX raw partition with
a Catalog
PAGE SIZE of 4KB, and an IQ PAGE SIZE of 128KB. By default, the
IQ Store size is 8MB and the Temporary Store is 4MB.
CREATE DATABASE ’company’ IQ PATH ’/dev/rdsk/c2t6d0s3’
PAGE SIZE 4096
IQ PAGE SIZE 131072
Enabling Java in the database
By default, Java support is ON for IQ databases. It can be turned off with the
JAVA OFF option. With Java ON:
• You can write a Java procedure that accesses tables in the Catalog Store or
the IQ Store. These queries are processed like any other query.
• You cannot use a Java-based user-defined function within a query to an IQ
table, but you can use it on Catalog Store tables.
• Windows NT users can also use Java-based user-defined functions in
queries on tables in an Adaptive Server Anywhere database, or queries to
IQ tables from an Adaptive Server Anywhere database, using the remote
access capabilities described in the Adaptive Server IQ Installation and
Configuration Guide.
• You cannot store Java data in an IQ table. If you attempt to create an IQ
column of type Java, you receive an error, and you may cause the database
server to fail.
Additional support for Java will be provided in a subsequent release. For
information on Java support in Adaptive Server Anywhere, see Part 3, “Java in
the Database” in the Adaptive Server Anywhere User’s Guide. The chapter
entitled “Data Access Using JDBC” is particularly relevant for IQ users.