Priya B wrote:
Does Derby allow users to create VTI calls with
parameter markers for arguments; so that we can
prepare the vti once and execute it with different
values?
Something like:
SELECT vti.* FROM new MyVTI(?) vti;
and then set the parameter value at run time?
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
Hi Priya,
This usage works when preparing the invocation of a table function:
select * from table fooFunc( ? ) s
You then set the parameter before exectuting the prepared statement. I
think that the short answer to your question is "yes". The resolution of
? parameters works for table functions the same way that it works for
other Derby functions.
Hope this helps,
-Rick
