Sybase 12.4.2 User Manual

CHAPTER 3    Working with Database Objects

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

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.