To reference a Java-SQL column, use the following syntax:
column_reference ::= [ [ [database_name.]owner.]table_name.]column_name | database_name..table_name.column_name
A reference to a column whose datatype is a Java-SQL class.
If the value of the column is null, then the column reference is also null.
If the value of the column is a Java serialization, S, and the name of its class is CS, then:
If the class CS does not exist in the current database or if CS is not the name of a class in the database associated with the serialization, then an exception is raised.
The database associated with the serialization is normally the database that contains the column. Serializations contained in work tables and in temporary tables created with “insert into #tempdb” are, however, associated with the database in which the serialization was stored originally.
The value of the column reference is:
where CSC is the column reference. If the expression raises an uncaught Java exception, then an exception is raised.
The expression yields a reference to an object in the Java VM, which is associated with the database associated with the serialization.