How to write stored procedure in DB2?? I used SQL syntax to write the SP however it seems that DB2 doesn't recognize 'procedure' in my 'create procedure <procedure_name>' syntax? Anybody can help?
Stored Procedures are written Java or C++ with the SQL embedded in the Java. Build an SQL String and use Prepared Statement Object to pass it to Db2 through default Connection. Default connection is what you use to connect to DB2 from a remote program.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.