Hi Iam trying to create a table function which returns a JDBC ResultSet. For this Iam follwing the documentation provided here http://db.apache.org/derby/docs/dev/devguide/cdevspecialtfbasic.html
When Iam trying to register my function by ising the below mentioned construct I get a syntax error which says Syntax error: encountered TABLE at line xxx, colum xx CREATE FUNCTION createviews () RETURNS TABLE ( WSID INT, WSNAME VARCHAR( 255 ) ) LANGUAGE JAVA PARAMETER STYLE DERBY_JDBC_RESULT_SET NO SQL EXTERNAL NAME 'com.views.create' Is there something which Iam missing out. Any help is greatly appreciated. Cheers Brjc -- View this message in context: http://www.nabble.com/Derby-Style-table-functions-tp14281733p14281733.html Sent from the Apache Derby Developers mailing list archive at Nabble.com.
