Listing the Description

Use the Schema Administrator LIST command to list the SQL description. The following describes the syntax for this command.

LIST Command

── LIST ─┬───────┬─┬─ DATABASE <database title> ─────────────────┬─────►
         └─ SQL ─┘ └─ LOGICAL DATABASE <logical database title> ─┘
►─┬──────────────────────────┬─────────────────────────────────────────┤
  └─ : ─┬─ REMOTE ───────────┤
        ├─ PRINTER ──────────┤
        └─ FILE <file name> ─┘

Syntax

<database title>

──┬────────────────┬─<database name>─┬──────────────────┬──────────────┤
  ├─ (<usercode>) ─┤                 └─ ON <pack name> ─┘
  └─ * ────────────┘

<logical database title>

── <logical database name> OF ─┬─ <database name> ──┬──────────────────┤
                               └─ <database title> ─┘

Explanation

Parameter

Description

SQL

Causes the SQL schema to be listed. SQL is the default when no parameter is entered.

<database title>

Specifies the name and optionally the location of the database for which the description is to be listed.

<logical database title>

Specifies the name and optionally the location of the logical database for which the description is to be listed.

REMOTE

Causes output to be sent to a remote file. REMOTE is the default when the Schema Administrator is run from a terminal.

PRINTER

Causes output to be printed. PRINTER is the default when the Schema Administrator is run in batch mode.

FILE

Causes the designated file to be created on disk containing the schema information.

Note: Although the output from the LIST command provides the information in the form of SQL schema syntax, this syntax is not guaranteed to be accepted as input to produce a native SQL database.
Prev  Up  Next
Generating the SQL Descriptions  Home  Using the DMQUERY Utility