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

DTLDESCRIBE COLUMNS Qualifier

Enables you to list the available columns:
dtldescribe columns, [
qualifier1
], [
qualifier2
], [
table_name
],[
comments
], [ORDER], [
escape_character
], [
respect_case1
], [
respect_case2
], [
respect_case3
], [
extended_information
], [
access_method
]
After the basic syntax of
dtldescribe columns
, 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
Always NULL if the dtldescribe operation is done by using NRDB2. Otherwise, this parameter returns the PowerExchange data map name.
table_name
The primary table qualifier. Returns the table name. If this parameter is blank, returns columns for all available tables.
comments
If set to Y this will return any comments data found in the database.
ORDER
Optional argument, Y will force order by column number or blank will leave column order undefined.
escape_character
Specifies the character to be used as the escape character. Default is ~.
respect_case1
respect_case2
respect_case3
Set to Y this will respect the case of qualifier1, qualifier2 and tablename respectively - alternative is blank.
extended_information
Set this parameter to Y to return additional information that depends on the data access method.
Applicable to NRDB, NRDB2, DB2 for z/OS, and DB2 for i5/OS only.
Defaults to N, which indicates no extended information is required.
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 only for the specified access methods. Use this method to return a list of data maps applicable for certain access methods. You can use any number or combination of access method identifiers. If you specify no value, the DTLDESCRIBE returns all access methods.
  • 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