Previous Topic: Physical Database DDL StatementsNext Topic: Components of a Physical DDL Statement


Statement Summary

Physical Database Description Statements

The following table summarizes the statements described in this chapter in order by verb. The statement descriptions are arranged in alphabetic order by noun.

Statement

Purpose

ALTER ARCHIVE JOURNAL

Modifies the definition of an archive journal file

ALTER AREA

Modifies the definition of an area

ALTER BUFFER

Modifies the definition of a database buffer

ALTER DBGROUP

Modifies a database group within a database name table

ALTER DBNAME

Modifies an entry in the database name table

ALTER DBTABLE

Modifies a database name table definition

ALTER DISK JOURNAL

Modifies the definition of a disk journal file

ALTER DMCL

Modifies a DMCL definition

ALTER FILE

Modifies the definition of a database file

ALTER JOURNAL BUFFER

Modifies the definition of a journal buffer

ALTER SEGMENT

Modifies the definition of a segment

ALTER TAPE JOURNAL

Modifies the definition of a tape journal file

CREATE ARCHIVE JOURNAL

Defines an archive journal file

CREATE AREA

Defines an area

CREATE BUFFER

Defines a database buffer

CREATE DBGROUP

Adds a database group to a database name table

CREATE DBNAME

Adds an entry to the database name table

CREATE DBTABLE

Creates a database name table

CREATE DISK JOURNAL

Defines a disk journal file

CREATE DMCL

Defines a DMCL

CREATE FILE

Defines a database file

CREATE JOURNAL BUFFER

Defines a journal buffer

CREATE SEGMENT

Defines a segment

CREATE TAPE JOURNAL

Defines a tape journal file

DISPLAY ARCHIVE JOURNAL

Displays the definition of an archive journal file

DISPLAY AREA

Displays the definition of an area

DISPLAY BUFFER

Displays the definition of a database buffer

DISPLAY DISK JOURNAL

Displays the definition of a disk journal file

DISPLAY DMCL

Displays a DMCL definition

DISPLAY FILE

Displays the definition of a database file

DISPLAY JOURNAL BUFFER

Displays the definition of a journal buffer

DISPLAY SEGMENT

Displays the definition of a segment

DISPLAY TAPE JOURNAL

Displays the definition of a tape journal file

DROP ARCHIVE JOURNAL

Deletes the definition of an archive journal file

DROP AREA

Deletes the definition of an area

DROP BUFFER

Deletes the definition of a database buffer

DROP DBGROUP

Deletes a database group from the database name table

DROP DBNAME

Deletes an entry from the database name table

DROP DBTABLE

Deletes the definition of a database name table

DROP DISK JOURNAL

Deletes the definition of a disk journal file

DROP DMCL

Deletes a DMCL definition

DROP FILE

Deletes the definition of a database file

DROP JOURNAL BUFFER

Deletes the definition of a journal buffer

DROP SEGMENT

Deletes the definition of a segment

DROP TAPE JOURNAL

Deletes the definition of a tape journal file

GENERATE DBTABLE

Generates a database name table load module

GENERATE DMCL

Generates a DMCL load module

PUNCH ARCHIVE JOURNAL

Punches the definition of an archive journal file

PUNCH AREA

Punches the definition of an area

PUNCH BUFFER

Punches the definition of a database buffer

PUNCH DISK JOURNAL

Punches the definition of a disk journal file

PUNCH DMCL

Punches a DMCL definition

PUNCH FILE

Punches the definition of a database file

PUNCH JOURNAL BUFFER

Punches the definition of a journal buffer

PUNCH SEGMENT

Punches the definition of a segment

PUNCH TAPE JOURNAL

Punches the definition of a tape journal file