External routines can be specified in CREATE PROCEDURE and CREATE FUNCTION statements because they can be used to define Java procedures and Java functions as external routines.
external-routine-name ::= 'JAR-file-name:Java-method-name [Java-signature]'
Java-method-name ::= Java-class-name.method-identifier
Java-class-name ::= [package-name.]class-identifier
Java-signature ::= ([Java-parameters])[returns type-name]
Java-parameter ::= type-name[,type-name]...
Default coding format | Type name containing a package name, as interpreted by HiRDB |
---|---|
Integer | java.lang.Integer |
Short | java.lang.Short |
BigDecimal | java.math.BigDecimal |
Double | java.lang.Double |
Float | java.lang.Float |
String | java.lang.String |
Date | java.sql.Date |
Time | java.sql.Time |
Timestamp | java.sql.Timestamp |
ResultSet | java.sql.ResultSet |