Reference Manual

10.5.5
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

DTLDESCRIBE TABLES Qualifier

Enables you to list the available tables.

Use the following syntax:

dtldescribe tables, [qualifier1], [qualifier2], [table_name], [comments], [ORDER], [escape_character], [respect_case1], [respect_case2], [respect_case3], [extended_information], [access_method]

After the basic syntax of

dtldescribe tables

, 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. If you leave this parameter blank, all tables are returned.
comments	Set this parameter to Y to return any comments found in data in the database.
ORDER	Leave this field blank except for a comma, which is required 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 values, respectively. Or leave these parameters blank.
extended_information	Set this parameter to Y to return the following fields that contain extra information. Applicable to NRDB, NRDB2, and CAPX only. Default is N, which indicates that 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 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 The following extraction map access methods are applicable only to CAPX and CAPXRT: XDB2 - B XMSSQL - L XORACLE - P