SQL names

Some of the methods in the UDTMetaData class set an SQL name for an opaque type or a JAR file that contains the opaque type or UDR code. The SQL name is the name of the object as referenced in SQL statements. For example, assume your application makes the following call:

mdata.setSQLName("circle2"); 

The name as used in an SQL statement is as follows:

CREATE TABLE tab (c circle2);

Similarly, assume the application sets the JAR file name as follows:

mdata.setJarFileSQLname("circle2_jar");

The JAR file name as referenced in SQL is as follows:

CREATE FUNCTION circle2_output (...) 
RETURNS circle2 
EXTERNAL NAME
   'circle2_jar: circle2.fromString (...)'
LANGUAGE JAVA
NOT VARIANT
END FUNCTION;