Adaptive Server version 12.0 allows you to install Java classes in the database and then reference them as datatypes in SQL. Version 12.0 also allows you to invoke Java static methods directly from SQL.
Adaptive Server version 12.5 extends these capabilities. You can now wrap Java static methods in SQL names and create SQLJ stored procedures or functions that you can use as you would Transarc-SQL stored procedures or built-in functions. This new functionality:
Allows Java methods to return output parameters and result sets to the calling environment.
Allows you to take advantage of traditional SQL syntax, metadata, and permission capabilities.
Complies with Part 1 of the ANSI SQLJ standard specification.
Allows you to use existing Java methods as SQLJ procedures and functions on the server, on the client, and on any SQLJ-compliant, third-party database.
