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 store Java data in an IQ table or a catalog store table. If you attempt to create an IQ column of type Java, you receive an error.
Java application programming Interface (API) can be used in stored procedures.
The JDBC interface can be used with to access SQL data only, because you cannot store Java data in any table in an IQ database.
Sybase IQ has been certified with the combined Java/Stored Procedure debugger, which is supplied on the Network Client CD.
These Java features are supported in the catalog store only:
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.
You cannot use Java classes as data types in IQ tables, but you can use Java classes as data types in catalog store tables.
The Java API classes supported by SQL Anywhere are also supported in the IQ catalog store.
Sybase IQ supports access to SQL Anywhere tables from IQ, and to IQ tables from SQL Anywhere, by means of proxy tables. Additional Java features should work when you use remote data access capabilities to access IQ tables from Anywhere, or Anywhere tables from IQ:
You can use Java-based user-defined functions in queries on tables in an SQL Anywhere database, or queries to IQ tables from an SQL Anywhere database. For details on using remote data access capabilities, see Chapter 4, “Accessing Remote Data,” in System Administration Guide: Volume 2.
You can include Java operations in a SQL statement.
You can use Java API classes in SQL statements.
You can treat the Java API classes as extensions to the available built-in functions provided by SQL.
For details on Java support in Sybase IQ, see:
“Introduction to Java in the Database,” in SQL Anywhere Server – Programming, in the SQL Anywhere Studio documentation in Sybooks Online Help
Appendix C, “Debugging Logic in the Database” in System Administration Guide: Volume 2.
