User`s guide

procedurecolumns
7-187
procedurecolumns
Get stored procedure parameters and result columns of catalogs
Syntax
pc = procedurecolumns(dbmeta, 'cata', 'sch')
pc = procedurecolumns(dbmeta, 'cata')
Description
pc = procedurecolumns(dbmeta, 'cata', 'sch') returns the stored procedure
parameters and result columns for the schema sch, of the catalog cata, for the database
whose database metadata object is dbmeta.
pc = procedurecolumns(dbmeta, 'cata') returns stored procedure parameters
and result columns for the catalog cata, for the database whose database metadata
object is dbmeta.
Running the stored procedure generates results. One row is returned for each column.
Examples
Get stored procedure parameters for the schema ORG, in the catalog tutorial, for the
database metadata object dbmeta:
pc = procedurecolumns(dbmeta,'tutorial', 'ORG')
pc =
Columns 1 through 7
[1x19 char] 'ORG' 'display' 'Month' '3'...
'12' 'TEXT'
[1x19 char] 'ORG' 'display' 'Day' '3'...
'4' 'INTEGER'
Columns 8 through 13
'50' '50' 'null' 'null' '1' 'null'
'50' '4' 'null' 'null' '1' 'null'