Reference Manual

10.5.5
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

DTLDESCRIBE PROCEDURECOLUMNS Qualifier

Enables you to list the available columns and information for given stored procedures:

dtldescribe procedurecolumns, [qualifier1], [qualifier2], [procedure_name], [column_name], [escape_character], [respect_case1], [respect_case2], [respect_case_procname], [respect_case_colname]

After the basic syntax of

dtldescribe procedurecolumns

, all of the parameters in brackets [ ] are optional. If any of the parameters are coded, you must include the intervening commas so that the parser can determine which field is included.

The following table describes the parameters:

Parameter	Description
qualifier1	Catalog name.
qualifier2	Schema name.
procedure_name	Procedure name.
column_name	Column name.
escape_character	Specifies the character to be used as the escape character. Default is the ~ character.
respect_case1 , respect_case2	Set these parameters to Y to respect the case of the qualifier1 and qualifier2 values, respectively. Or leave these parameters blank.
respect_case_procname	Set this parameter to Y to respect the case of the procedure_name value. Or leave this parameter blank.
respect_case_colname	Set this parameter to Y to respect the case of the column_name value. Or leave this parameter blank.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

DTLDESCRIBE PROCEDURECOLUMNS Qualifier

DTLDESCRIBE PROCEDURECOLUMNS Qualifier