how to tell which is user's stored procedures in ids10

Posted in 2006

roger@star2000.com.tw — 15 Nov 2006 16:38:48 -0800 — source: Usenet: comp.databases.informix

Hi , In ids10, sysprocedures had added lots of system stored procedure. How can I tell the difference from the stored procedure that user created or system provided By " select * from sysprocedures" ?

↪ replying to roger@star2000.com.tw

Art S. Kagel — Thu, 16 Nov 2006 09:34:18 -0500 — source: Usenet: comp.databases.informix

roger@star2000.com.tw wrote: > Hi , > In ids10, sysprocedures had added lots of system stored procedure. > How can I tell the difference from the stored procedure that user > created or system provided > By " select * from sysprocedures" ? Myschema uses: SELECT procname, owner, procid, mode, retsize, symsize, datasize, codesize, numargs FROM "informix".sysprocedures WHERE procname MATCHES ? AND mode NOT IN ('P', 'd', 'r', 'o'); For some early versions of IDS 'p' should also be in that list but I don't know if any current versions still use 'p'. Routines that once were coded as 'p' are now coded as 'd'. See the Guide to SQL Reference section on the sysprocedures system catalog table for more details. Art S. Kagel