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 PKEYS Qualifier

DTLDESCRIBE PKEYS Qualifier

dtldescribe pkeys, [
qualifier1
], [qualifier2], [
table_name
], [
comments
], [ORDER], [
escape_character
], [
respect_case1
], [
respect_case2
], [
respect_case3
], [
extended_information
],[
access_method
]
After the basic syntax of
dtldescribe pkeys
, 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
,
qualifier2
Returns the first and second data map qualifiers.
table_name
The primary table qualifier. Returns the table name.
comments
Set this parameter to Y to return any comments found in data in the database.
ORDER
This field must be left blank except for a comma, which is needed to maintain position of subsequent fields.
escape_character
Specifies the character to be used as the escape character. Default is the ~ character.
respect_case1
,
respect_case2
,
respect_case3
Set these parameters to Y to respect the case of the
qualifier1
,
qualifier2
and
table_name
parameters, respectively. Or leave these parameters blank.
extended_information
This field must be left blank except for a comma, which is needed to maintain position of subsequent fields.
access_method
For NRDB, NRDB2, CAPX, and CAPXRT only:
Specifies the valid access method or methods for which information is returned. The results of the DTLDESCRIBE are filtered to return information for only the specified access methods. Use this parameter to return a list of data maps that are applicable for certain access methods. Any number or combination of access method identifiers can be used, such as OS or AKT. If no value is specified, the DTLDESCRIBE returns information for all access methods by default.
  • ADABAS - A
  • CAPX / RT - C
  • DATACOM - X
  • DB2 - Z
  • DB2390IMG - G
  • DB2UNLD - W
  • DL1 - D
  • ESDS - E
  • IDMS - I
  • KSDS - K
  • MQ - Q
  • ODBA - O
  • RRDS - N
  • SEQ - S
  • TAPE - T
  • USER - U
PKEYS is implemented for:
  • ADABAS
  • DB2
  • DB2390IMG
  • DB2400C
  • DB2UDB
  • MSSQL
  • NRDB / NRDB2 (only for DL/I, ODBA, KSDS and Datacom data maps)
  • ORACLE