Reference Manual

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

Back Next

DTLDESCRIBE SCHEMAS Qualifier

Enables you to list the available schemas:

dtldescribe schemas, [filter_pattern],,,,,,,,,, [access_method]

After the basic syntax of

dtldescribe schemas

, the parameters in square brackets [ ] are optional. Except for the optional filter_pattern
and access_method
, all of the other positional parameters are ignored. If any 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
filter_pattern	Supply a pattern to filter the schemas that are returned to just those that start with the supplied character. Use an asterisk (*) as a wildcard to match one or more characters of any type.
access_method	For NRDB,NRDB2: 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, for example, 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

Parameter

Description

filter_pattern

Supply a pattern to filter the schemas that are returned to just those that start with the supplied character. Use an asterisk (*) as a wildcard to match one or more characters of any type.

access_method

For NRDB,NRDB2:

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, for example, 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

For example:

Dtldescribe schemas, d* ,,,,,,,,,, C

This example returns dev_schema but not eval_schema, if dev_schema is using the CAPX access method.

This function is implemented for CAPX, CAPXRT, DB2, DB2400C, IMSUNLD, MSSQL, NRDB, NRDB2, ORACLE, and DB2390IMG.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

DTLDESCRIBE SCHEMAS Qualifier

DTLDESCRIBE SCHEMAS Qualifier