Derby¤ÏJava¤Ç¥×¥í¥·¡¼¥¸¥ã¡¼¤òµ½Ò¤·¤Þ¤¹¡£
´Êñ¤Ê¥µ¥ó¥×¥ë¤òºîÀ®¤·¤Þ¤·¤¿¡£
¿ô»ú¤ò100Çܤˤ·¤ÆÊÖ¤¹¥¹¥«¥é¡¼´Ø¿ô¤Ç¤¹¡£
´Êñ¤Ê¥µ¥ó¥×¥ë¤òºîÀ®¤·¤Þ¤·¤¿¡£
¿ô»ú¤ò100Çܤˤ·¤ÆÊÖ¤¹¥¹¥«¥é¡¼´Ø¿ô¤Ç¤¹¡£
¤ªÌó«¤Ç¤¹¤¬static¤Ê¥á¥½¥Ã¥É¤ò»ý¤Ä¥¯¥é¥¹¤òºîÀ®¤·¤Æ¤¯¤À¤µ¤¤
package net.shuffle.derby; public class MyProcedure { public static int mult100(final int in1) { return in1 * 100; } }Eclipse¤Ç¥½¡¼¥¹¤òºîÀ®¤·¡¢jar¥Õ¥¡¥¤¥ë(MyProcedure.jar)¤òºîÀ®¤·¤Þ¤¹
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.classpath' ,'SHUFFLE.PROCEDURE') ;
set schema=SHUFFLE ;
CREATE FUNCTION MULT100( IN1 INTEGER) RETURNS INTEGER
LANGUAGE JAVA
EXTERNAL NAME 'net.shuffle.derby.MyProcedure.mult100'
PARAMETER STYLE JAVA ;
¥³¥á¥ó¥È¤ò¤«¤¯