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.