Java Stored procedure

[Aparna Sharma]

Hi,

I had a general question about writing Stored procedures using WSAD. The database is DB2 and our plan is to write Java Stored procedures. I read some where that in terms of efficiency SQL stored procedure is first , then C stored procedure and last comes Java Stored procedure.

Any thoughts on this?

Thanks,
Aparna S.

-fyi-
on DB2 stored proceduresIBM RedBook link

[Kuldeep Vaishnav]

well as such stored procs itself is a big performance hit(we are converting all our sql stor procs to java classes currently) compared to jdbc..but within stored procs u may right bout the numbering....