![]() |
Using Cloudscape's Java Extensions
|
Reference Manual |
Using Methods to Emulate SQL-92 FunctionsSQL-92 specifies several built-in functions that can be executed within a DBMS. Typical functions are mathematical and string functions. Instead of retrieving raw data from the DBMS and doing all computing in the application, functions allow you to do some computing in the DBMS. For example, the SQL-92 text functions, such as SUBSTRING and LENGTH, perform some operations on VARCHAR columns within the DBMS. Cloudscape includes most but not all of the SQL-92 functions. However, because it is integrated with Java, its real power is that it lets you invoke Java methods. You don't need SQL-92 functions; you have Java. If a built-in function duplicates a Java method, use whichever is more convenient. In addition, you can define an alias for any static Java method, making it appear as a native built-in function. You use the CREATE METHOD ALIAS statement. Alias definitions are specific to a database; to use an alias when connected to a database, you must already have defined the alias within that database. For more information, see Using java.lang Methods as Functions. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |