KB#01214-How to get a list of SPROCs from a BBj program | BASIS International Ltd.
Here is a simple BBj program that will print out a list of SPROCs in a database along with their descriptions. The java.sql.DatabaseMetaData interface in the Java API docs contains the information about SPROCs (or other database items like tables, functions, indexes, etc.).
!dbMeta in the sample code is an instance of this interface.