DB_ProcedureColumns Function

Action

Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures. The information is returned as a result set on the specified statement.

Syntax

hstmnt = DB_ProcedureColumns (hdbc, catalog-name, schema-name, proc-name, column-name)
Variable Description
hstmnt

The returned handle to the executed SQL statement. This is an input parameter for other DBTester functions, for example DB_FetchNext. HSQL.

hdbc

The handle to a database as returned by DB_Connect. HDATABASE.

catalog-name

Catalog name. STRING.

schema-name

String search pattern for schema names. STRING.

proc-name

String search pattern for procedure names. STRING.

column-name

String search pattern for column names. STRING.

Notes

  • DB_ProcedureColumns corresponds to SQLProcedureColumns. For additional information about SQLProcedureColumns, see SQLProcedureColumns Function.

  • The catalog-name argument cannot contain a wildcard.

  • The following wildcard characters are supported for arguments:
    Wildcard character Matches
    % The percent sign matches any character sequence.
    _ The underscore matches any single character.
  • To omit a variable argument, which is not a required argument, specify the argument as an empty string ("").

  • When you receive a valid statement handle, you can call DB_FetchNext or DB_FetchPrevious to manipulate the information.

Example

[ ] STRING cat, sch, proc, col,ignore, proc-name, proc-col
[ ] hstmnt = DB_ProcedureColumns (hdbc, cat, sch,"","") 
[ ] // { retrieve procedure and procedure column names; ignore the rest.
[-] while (DB_FetchNext (hstmt, ignore, ignore, proc-name, proc-col) == TRUE) {
	[ ] //print procedure and procedure column names ...
[-] }