User`s guide

7 Functions — Alphabetical List
7-190
procedures
Get stored procedures for catalogs
Syntax
p = procedures(dbmeta, 'cata')
p = procedures(dbmeta, 'cata', 'sch')
Description
p = procedures(dbmeta, 'cata') returns stored procedures in the catalog cata for
the database whose database metadata object is dbmeta.
p = procedures(dbmeta, 'cata', 'sch') returns the stored procedures in the
schema sch, of the catalog cata, for the database whose database metadata object is
dbmeta.
Stored procedures are SQL statements that are saved with the database. Use the exec
function to run a stored procedure. Specify the stored procedure as the sqlquery
argument instead of explicitly entering the sqlquery statement as the argument.
Examples
Get the names of stored procedures for the catalog DBA for the database metadata object
dbmeta:
p = procedures(dbmeta,'DBA')
p =
'sp_contacts'
'sp_customer_list'
'sp_customer_products'
'sp_product_info'
'sp_retrieve_contacts'
'sp_sales_order'
Execute the stored procedure sp_customer_list for the database connection conn, and
fetch all data: