db2_procedure_columns

db2_procedure_columns

Returns a result set listing stored procedure parameters

resource **db2_procedure_columns** resource $connection  $qualifier string $schema string $procedure  $parameter

Returns a result set listing the parameters for one or more stored procedures.

connectionA valid connection to an IBM DB2, Cloudscape, or Apache Derby database.

qualifierA qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass null or an empty string.

schema The schema which contains the procedures. This parameter accepts a search pattern containing and as wildcards. _``%

procedure The name of the procedure. This parameter accepts a search pattern containing and as wildcards. _``%

parameter The name of the parameter. This parameter accepts a search pattern containing and as wildcards. If this parameter is null, all parameters for the specified stored procedures are returned. _``%

Returns a statement resource with a result set containing rows describing the parameters for the stored procedures matching the specified parameters. The rows are composed of the following columns:

db2_column_privileges``db2_columns``db2_foreign_keys``db2_primary_keys``db2_procedures``db2_special_columns``db2_statistics``db2_table_privileges``db2_tables