Previous Topic: SYSTEM.AMNext Topic: SYSTEM.AREA


SYSTEM.AMDEP

Description

A row of SYSTEM.AMDEP identifies a table or view referenced in an access module.

Column name

Column description

Data type

Null specifi- cation

NAME

Access module name.

CHAR(8)

NOT NULL

VERSION

Access module version.

SMALLINT

NOT NULL

TABSCHEMA

Schema-name qualifier of the table.

CHAR(18)

NOT NULL

TABLE

Table or view name.

CHAR(18)

NOT NULL

STAMP

Date and time the table was created or last altered.

TIMESTAMP

NOT NULL

TYPE

Type of table:

  • T—Base table
  • V—View

CHAR(1)

NOT NULL

FILLER

Reserved for future use.

BINARY(25)

NOT NULL