Re: [luciddb-users] How To Use Applib Functions?

[John V. S. <js...@gm...>]

Mitchell Halligan wrote:
> Hello,
> 
> There is probably an easy answer to this, but I am somewhat new to
> LucidDB and completely stumped.  I running a query and decided to
> format the Timestamp columns.  For this, I used
> applib.timestamp_to_char in my select.  However, running the query
> told me that I need execute permission.  This seemed reasonable, so I
> tried granting the permission on applib.timestamp_to_char over to my
> user.  But, I get a procedure not found error.  I have resorted to
> trying to load the applib.jar into my schema and define the function
> following the directions in how to set up a udf.  This hasn't helped
> and got me thinking I must be making this overly complicated.

Follow the example here:

http://pub.eigenbase.org/wiki/LucidDbOlap

The SPECIFIC keyword is required by SQL:200n so that GRANT doesn't have 
to deal with overload ambiguities.

JVS