How to identify non-system stored procedures

When I use dbschema -d database -f all I get an output containing 2011 stored procedures. A count(*) of sysprocedures yields 2350. How can I identify in the sysprocedures table just those procedures which appear in the dbschema output. Is there a flag which indicates system or user stored procedures? Maybe the value of procid has a special meaning in the same way that tabid's <= 99 are system tables. Does anyone know? Thanks.

On Wed, 2006-12-27 at 17:28 -0800, Desmodromic wrote: > When I use > > dbschema -d database -f all> > I get an output containing 2011 stored procedures. > > A count(*) of sysprocedures yields 2350. > > How can I identify in the sysprocedures table just those procedures > which appear in the dbschema output. Is there a flag which indicates > system or user stored procedures? Maybe the value of procid has a > special meaning in the same way that tabid's <= 99 are system tables. > Does anyone know? System procedures: select count(*) from sysprocedures where mode = lower(mode) User procedures: select count(*) from sysprocedures where mode = upper(mode) Hope this helps, Carsten.

Desmodromic wrote: > When I use > > dbschema -d database -f all> > I get an output containing 2011 stored procedures. > > A count(*) of sysprocedures yields 2350. > > How can I identify in the sysprocedures table just those procedures > which appear in the dbschema output. Is there a flag which indicates > system or user stored procedures? Maybe the value of procid has a > special meaning in the same way that tabid's <= 99 are system tables. > Does anyone know? Add the following clause to your SELECT from sysprocedures: AND mode NOT IN ('P', 'd', 'r', 'o') These represent system procedures which dbschema will not print out. Art S. Kagel