Fetch stored procedure definition in Java

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