Reference Manual

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

Back Next

DTLDESCRIBE TABLES Returned Information

The following table describes the columns:

Column Name	Description	Extended information
qualifier_1	Creator/Schema name.	No
qualifier_2	PowerExchange Data Map name will be returned, or null for NRDB2.	No
tablename	Return table name.	No
comments	Comments column always present. Comment information is included only if requested by specifying the comments indicator in the describe.	No
type	Type of object for which metadata was returned, such as TABLE or MATERIALIZED VIEW.	No
Acc_mth	The access method (from data map)	Yes
Acc_mths01	Adabas	Database ID
Acc_mths01	SEQ, KSDS, ESDS	MapFileName
Acc_mths01	IDMS	MapSubSchemaName
Acc_mths01	ODBA or DL/I	DBDName
Acc_mths01	Datacom	Database ID
Acc_mths01	CAPX or CAPXRT	The access method of the original data map
Acc_mths01	Other access methods	NULL
Acc_mths02	Adabas	File Number
Acc_mths02	ODBA or DL/I	DBDType
Acc_mths02	Datacom	Table record length
Acc_mths02	IDMS or VSAM	C (if table is valid for data capture) or NULL
Acc_mths02	CAPX	Condense option (Full, Part or None)
Acc_mths02	DB2UNLD	Null indicator value
Acc_mths02	Other access methods	NULL
Acc_mths03	Datacom	Table ID
Acc_mths03	IDMS or VSAM	Database name
Acc_mths03	CAPX or CAPXRT	Creator of the capture registration
Acc_mths03	DB2	DB2 Sub system ID
Acc_mths03	DB2UNLD	Unload type
Acc_mths03	Other access methods	Not Used. (comma needed to maintain position of later fields)
Acc_mths04	Datacom	Version
Acc_mths04	CAPX or CAPXRT	Name of the registration's source table
Acc_mths04	DB2 or DB2UNLD	DB2 table name
Acc_mths04	Other access methods	Not Used. (comma needed to maintain position of later fields)
Acc_mths05	Datacom	Recovery (Y/N)
Acc_mths05	DB2UNLD	Unload file name
Acc_mths05	Other access methods	Not Used. (comma needed to maintain position of later fields)
Acc_mths05	Base Record	Describes the dependencies for a table. For example, ROOT(SEG2(SEG3,SEG4),SEG5) For Datacom, Base Record returns the short table name.

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

DTLDESCRIBE TABLES Returned Information

DTLDESCRIBE TABLES Returned Information