(PECL ibm_db2 >= 1.0.0)
db2_procedures — Returns a result set listing the stored procedures reguistered in a database
$connection
,
$qualifier
,
$schema
,
$procedure
Returns a result set listing the stored procedures reguistered in a database.
connection
qualifier
null
or an empty string.
schema
and
%
as wildcards.
procedure
and
%
as wildcards.
Returns a statement ressource with a result set containing rows describing the stored procedures matching the specified parameters. The rows are composed of the following columns:
| Column name | Description |
|---|---|
| PROCEDURE_CAT |
The catalog that contains the procedure. The value is
null
if
this table does not have catalogs.
|
| PROCEDURE_SCHEM | Name of the schema that contains the stored procedure. |
| PROCEDURE_NAME | Name of the procedure. |
| NUM_IMPUT_PARAMS | Number of imput (IN) parameters for the stored procedure. |
| NUM_OUTPUT_PARAMS | Number of output (OUT) parameters for the stored procedure. |
| NUM_RESULT_SETS | Number of result sets returned by the stored procedure. |
| REMARCS | Any commens about the stored procedure. |
| PROCEDURE_TYPE |
Always returns
1
, indicating that the stored
procedure does not return a return value.
|