PowerExchange for CDC and Mainframe
- PowerExchange for CDC and Mainframe 10.5.1
- All Products
dtldescribe records,[qualifier1], [qualifier2], [table_name], [comments], [ORDER], [escape_character], [respect_case1], [respect_case2], [respect_case3], [extended_information], [access_method]
Creator or schema name.
The primary table qualifier. If this parameter is blank, returns records for all available tables.
Set this parameter to Y to return any comments found in data in the database.
This field must be left blank except for a comma, which is needed to maintain the position of subsequent fields.
Specifies the character to be used as the escape character. Default is the ~ character.
Set these parameters to Y to respect the case of the
table_namevalues, respectively. Or leave these parameters blank.
Set this parameter to Y to returns 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 that no extended information is required.
For NRDB,NRDB2, CAPX, and CAPXRT only:
Specifies the valid access methods for which information is returned. The results of the DTLDESCRIBE are filtered to return information for only the specified access methods. This is useful 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 AKTM. If no value is used, the DTLDESCRIBE defaults to return all access method.