Hi there, still Derby newby which is digging through the documentatins but cannot find wht he needs ...
trying to make a dum funtion MYFUNC without any parameters returning a number it gets via soem sql lookups. Any examples out there of how a function is to be declared without parameters and how the java program can do SQL against Derby ? So that I can use this function like ij> values myfunc; For the declaration I tried: CREATE FUNCTION MYFUNC RETURNS BIGINT PARAMETER STYLE JAVA CONTAINS SQL LANGUAGE JAVA EXTERNAL NAME 'com.xyz.DerbyFunctions.myfunc' and got ij> CREATE FUNCTION TEST1 RETURNS BIGINT PARAMETER STYLE JAVA CONTAINS SQL LANGUAGE JAVA EXTERNAL NAME 'com.xyz.DerbyFunctions.myfunc'; ERROR 42X01: Syntax error: Encountered "RETURNS" at line 1, column 23. So QUESTION: 1) How to make this CREATE FUNC call correctly ? 2) Is it possible to make a function so I do not need to add () for no parameters 3) How to I do SQL against Derby in my Java static method ?!?! Thanx B-)
