![]() |
Using Cloudscape's Java Extensions
|
Reference Manual |
Other Java-Smart Syntax in SQL-JSQL-J syntax includes other elements borrowed from Java syntax to facilitate working with Java objects and classes. It includes the keyword INSTANCEOF, which allows you to test whether an object belongs to a particular class. This is useful if you are storing objects that are members of a subclass in a column associated with a superclass data type. SQL-J also includes the NEW keyword, which allows you to construct new objects within an SQL-J statement: VALUES NEW java.lang.String('hello, world!')
SELECT NEW JBMSTours.Hotel( The conditional expression (?:) provides simple if-then control:
SELECT city.getName() IS NULL ? 'no name' For more information on these commands, see their manual pages in the Cloudscape Reference Manual. |
|
![]() 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. |