Re: Informix Procedures

Procedures with and external_name column filled in are simply ones written in "C" or Java and not necessarily system procedures. Similarly, any system delivered procedures written in SPL (such as the one you mention) will not have an external_name. Practically the only way to tell which are system provided and which are user procs is to create an empty database and see what the highest procid is in there. Any procids greater than that are either user routines or were added later when a datablade was instantiated on first use. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, 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 Mon, Dec 3, 2012 at 7:20 AM, ECONOMIDES VASILIS < vasilis.economides@ctl.com> wrote: > Hi, > > I have IDS 10.00.UC6 and I would like to know which are the IDS > procedures/routines and which they are the user created procedures. > > I guess that the IDS procedures/routines are the ones that have the field > sysprocedures.externalname defined and the ones that are user created have > this field as null. > > But I have found one procedure that does not have the > sysprocedures.externalname defined and seems to be an IDS procedure. This > is: > ifx_allow_newline > > Is there a way via an SQL command to identify the ones that are IDS > specific > and the ones that are user specific? > > Thanks, > > Vasilis > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d04479769e6f69304cff66579