Re: Informix Procedures

On Mon, Dec 3, 2012 at 4:20 AM, ECONOMIDES VASILIS < vasilis.economides@ctl.com> wrote: > I have IDS 10.00.UC6 I trust you are planning your upgrade. > 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? > The easiest way is to create an empty database and observe the procedures that are present in it. It is sufficient to note the maximum procid in the empty database; the procedures with that number or less are 'system defined' and those after are not. There are complications. The list of procedures can change from version to version, so what is correct in 10.00 will be different in 11.10, 11.50, 11.70 (probably). If you migrated your database (server) from earlier versions, then it could be that procids 1-20 were system defined, then user procedures were added with procids 21-30, then the system was upgraded and new system procedures were added with procids 31-40, and so on (all numbering purely hypothetical). You can compare the procedure signatures with the list you get from an empty database; that will work. But it is fiddly and version dependent. There isn't a simple way to know... (All with the caveat: As far as I know...) -- Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." --bcaec554d9d6c59ec304cff605a2