Hi
Still working on my porting an SQL Server database to a derby one, I
have some questions for you.
Before, thanks to Army for the function creation.
I have read the IBM forum about derby stored procedure and I have
created one which works prefectly in ij but i cant call the procedure
from an ODBC link !? I just put :
CALL ALTTIME2(1)
And the link said : wrong syntax !
Like it doesnt understand everuthing including the word 'CALL' !
Ok .. thanks odbc .. it helps a lot... if you have any idea about this one.
Another question about stored procedure :
I want to create a stored procedure which the goal will be to do a
select with a 'where in ' and a list of integer. This list of integer
should be the parameter of my stored procedure, but how can i do that ?
or perhaps its not the right way to do it ?
Thank you a lot
Nicolas
