What's New in SQL Anywhere Studio
What's New in Version 6.0.1
New features in version 6.0.1
There are some changes made to the Java support. These include the following:
Updating Java fields You can now use standard UPDATE syntax to update a field in a column of Java data type. The following statement was not supported before 6.0.1, but is now supported:
UPDATE Product SET JProd>>unit_price = 16.00 WHERE ID = 302
Use of the EVALUATE function is no longer required.
Compressed jar files You can now install compressed jar files and zip files into the database. However, you should not use the jar utility that comes with the Sun JDK. Other zip utilities do produce suitable files.
Result sets from Java procedures You can wrap Java methods in a stored procedure, which can return a result set or multiple result sets to the calling environment.
For information on this feature, see Returning result sets from Java methods.
Default internal connection When a database connection is established for internal JDBC operations, it is now recommended that you use the following URL:
jdbc:default:connection
In version 6.0.0, an empty string was used to establish this connection. While the empty string does still work, it is deprecated. The new URL corresponds to the SQLJ1 proposed standard.