Identifying System Stored Procedures

[red_valsen]

Is there a way to readily identify system SPs -- similar to identifying system tables by IDs of 99 or less? Our developers have been creating SPs as user 'informix', so that filter won't work.

[Doug Lawry]

It would seem that sysprocedures.mode is uppercase for your own UDRs and lowercase for system UDRs. See also:

http://informix-technology.blogspot.co.uk/2012/02/procedures-procedimentos-owner-vs.html
http://dbaspot.com/informix/135029-how-identify-non-system-stored-procedures.html
http://pic.dhe.ibm.com/infocenter/idshelp/v117/topic/com.ibm.sqlr.doc/ids_sqr_053.htm

Regards,
Doug Lawry