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

DTLDESCRIBE PROCEDURECOLUMNS 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; VARCHAR
COLUMN_NAME
Column name; VARCHAR
COLUMN_TYPE
Column type, not null; SMALLINT
Can be
0 - SQL_PARAM_TYPE_UNKNOWN
1 - SQL_PARAM_INPUT - input parameter
2 - SQL_PARAM_INPUT_OUTPUT - input/output parameter
3 - SQL_RESULT_COLUMN - Parm is a column inset
4 - SQL_PARAM_OUTPUT - output parameter
5 - SQL_RETURN_VALUE - Column is return value of procedure
DATA_TYPE
SQL datatype, not null; SMALLINT
TYPE_NAME
Type name, character string representing datatype, not null; VARCHAR
COLUMN_SIZE
Column size; INTEGER
BUFFER_LENGTH
Buffer length. Maximum number of bytes required to store column data; INTEGER
DECIMAL_DIGITS
Scale, NULL if not applicable; SMALLINT
NUM_PREC_RADIX
Precision; SMALLINT
NULLABLE
Nullable, not null, determines if column will accept a null value; SMALLINT.
Can be
0 - SQL_NO_NULLS
1 - SQL_NULLABLE
REMARKS
Remarks; VARCHAR
COLUMN_DEF
Column default value; VARCHAR
SQL_DATA_TYPE
SQL Datatype, not null; SMALLINT
SQL_DATETIME_SUB
Datetime subtype. Can be
1 - SQL_CODE_DATE
2 - SQL_CODE_TIME
3 - SQL_CODE_TIMESTAMP
CHAR_OCTET_LENGTH
Maximum length in bytes of a character type column; INTEGER
ORDINAL_POSITION
Ordinal Position if parameter given by Column name in result set, not null; INTEGER
IS_NULLABLE
Can the column contain nulls. “YES” if column can contain nulls, “NO” if not; VARCHAR
DTLDESCRIBE PROCEDURECOLUMNS is implemented for DB2400C and MSSQL.