db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ivan Ooi" <olibr...@gmail.com>
Subject Re: using sql statement in procedure or function
Date Fri, 04 Aug 2006 02:20:59 GMT
Nice if I can use SQLJ directly inside there :-) cleaner.

String ls_code ;

#sqlj{
select code
  into :ls_code
  from staff
 where year = 1960
};

nice to have and nice to dream off :-(

On 8/4/06, Stanley Bradbury <Stan.Bradbury@gmail.com> wrote:
>
> Ivan Ooi wrote:
> > hi all,
> >
> >   Is there anyway that i can use SQL statement to query my data in
> > procedure or function ?
> > Will Derby going to implement that ? Why not take a look JoSQL.sf.net
> > <http://JoSQL.sf.net>,
> > good if Derby can take this library in :-)
> >
> > Thanks
> Hi -
> The Derby WIKI page on Procedures and Functions is a good place to look
> for information and examples of doing this.
>
> URL:  http://wiki.apache.org/db-derby/DerbySQLroutines
>
> You will need to use a Procedure to return multiple values - a function
> can only return a single value.
>
>
>
>
>

Mime
View raw message