Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

DTLDESCRIBE PROCEDURES Qualifier

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.