Fetch stored procedure definition in Java
Gurpreet Sachdeva asked whether a deployed Java stored procedure's definition can be fetched. Art Kagel asked for clarification. Marcus Haarmann guessed the source was wanted and said Java UDRs deploy as jar files, so the jar must be found or decompiled. Doug Lawry gave a query joining sysprocedures and sysprocbody (datakey = 'T', ordered by seqno) to read the procedure text. No confirmation from the asker.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Is it possible to fetch deployed stored procedure's definition in Java.
Not sure what your question is? Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jan 28, 2014 at 5:36 AM, GURPREET SACHDEVA <gusachde@cisco.com>wrote: > Is it possible to fetch deployed stored procedure's definition in Java. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c36780d57f2d04f106bdb9
I suspect, you have an existing old instance and want to get the source for the java SPL. Correct ? Since Java deployment is through jar files, you have to search for the deployed jar files. If you have no source code available, there could be a chance to de-compile it (not really nice). Marcus Haarmann ----- Ursprüngliche Mail ----- Von: "Art Kagel" <art.kagel@gmail.com> An: ids@iiug.org Gesendet: Dienstag, 28. Januar 2014 13:13:29 Betreff: Re: Fetch stored procedure definition in Java [32364] Not sure what your question is? Art Art S. Kagel, Principal Consultant ASK Database Management Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jan 28, 2014 at 5:36 AM, GURPREET SACHDEVA <gusachde@cisco.com>wrote: > Is it possible to fetch deployed stored procedure's definition in Java. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c36780d57f2d04f106bdb9 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
SELECT T1.procid, data
FROM sysprocedures AS T1, sysprocbody AS T2
WHERE procname = 'test_proc'
AND T2.procid = T1.procid
AND datakey = 'T'
ORDER BY T1.procid, T2.seqno
Regards,
Doug Lawry