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. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

DTLDESCRIBE PROCEDURECOLUMNS Qualifier

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.