db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jim McNamara" <3rdshiftco...@verizon.net>
Subject RE: calling a function
Date Tue, 03 Oct 2006 00:45:36 GMT


-----Original Message-----
From: Dan J Debrunner [mailto:ddebrunner@sbcglobal.net] 
Sent: Monday, October 02, 2006 8:15 PM
To: Derby Discussion
Subject: Re: calling a function


Thanks Dan!
I think it will work now. 
Have a great week,
jim


--- Jim McNamara <3rdshiftcoder@verizon.net> wrote:

CALL is used for procedures, not functions.

You can use VALUES to execute a function like this:

VALUES DISTRIBTOTALAMOUNT()

This page might also help:

http://wiki.apache.org/db-derby/DerbySQLroutines

Dan.


Mime
View raw message