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 PROCEDURES Returned Information

DTLDESCRIBE PROCEDURES Returned Information

The following table describes the columns:
Column Name
Description
PROCEDURE_CAT
Procedure Catalog, null if not present; VARCHAR.
PROCEDURE_SCHEM
Procedure Schema, null if not present; VARCHAR.
PROCEDURE_NAME
Procedure Name, not null; VARCHAR.
NUM_INPUT_PARAMS
Number of input parameters, not null (N/A for SQL Server); INTEGER.
NUM_OUTPUT_PARAMS
Number of output parameters, not null (N/A for SQL Server); INTEGER.
NUM_RESULT_SETS
Number of result sets, not null (N/A for SQL Server); INTEGER.
REMARKS
Comments; VARCHAR.
PROCEDURE_TYPE
Procedure type.
DTLDESCRIBE PROCEDURES is implemented for DB2400C and MSSQL.