Reference Manual

10.5.6
- 10.5.5
- 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 PROCEDURES Qualifier

Enables you to list the available stored procedures:

dtldescribe procedures, [qualifier1], [qualifier2], [procedure_name], [escape_character], [respect_case1], [respect_case2], [respect_case_procname]

After the basic syntax of

dtldescribe procedures

, 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
escape_character	Specifies the character to be used as the escape character. Default is ~.
respect _case1 , respect_case2	Set these parameters to Y to respect the case of the `qualifier1` and `qualifier2` parameters, 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.