DQL Statements › DISPLAY Statement › Basic Syntax

Basic Syntax

Purpose

You can create a DISPLAY statement without including headings or a PICTURE clause. The basic statement is simpler without it.

Syntax Diagram

The following is the basic syntax of DISPLAY with a PICTURE clause.

►►─ DISPLAY ─┬────────┬─┬─────────────────────────────┬───────────────────────►
             └─ FROM ─┘ └─ table-name ─┬────────────┬─┘
                                       └─ (status) ─┘

 ►─┬─ key-name ────┬─┬──────────────────────────┬─────────────────────────────►◄
   └─ column-name ─┘ └─ PICture 'edit-pattern' ─┘

Explanation

This section explains each keyword in the DISPLAY format.

FROM

Used for readability only.

table-name

Specifies the Datadictionary name of the table where CA Dataquery obtains the values of the columns and keys indicated. You only need to include the table name if the column or key in the statement refers to a table which is different than the most recently named table in the query.

(status)

(Optional) If authorized, use to specify a Datadictionary definition of a table that is being tested by programmers responsible for its maintenance. If the FIND or COUNT statement specifies a TEST status for a table, all subsequent statements in the same query reference the same status and version of the table, unless a different status is specified. The following chart describes each status you can specify.

Note: The status must be enclosed in parentheses, and there must be no spaces between the table name and the left parenthesis.

TEST

Finds the named table in the first test version that meets the specifications.

Tnnn

(Where nnn refers to the version number of the test status you want.) Finds the named table in the specified test version.

PROD

PRODuction is the default status if not specified.

key-name

Specifies the name of a key contained in the table specified in the DISPLAY statement or the most recently named table in a previous statement.

column-name

Specifies the name of a column that is either in the table named in the DISPLAY statement or in the previously named table. A column also can be a result from a previous SET statement in the query. And, a column can be one occurrence in a repeating field. If that is the case, use subscripts to identify which occurrence is to be used. A typical subscript looks like this:

SALES-RESULTS (5,2)

(See the CA Dataquery User Guide for more information.)

PICTURE 'edit-pattern'

See PICTURE Clause for information about PICTURE clauses.

Example

The following illustrates a basic query which displays the data resulting from query execution.

    FIND 10 CAI-SLSHST-REC ROWS
    DISPLAY FROM CAI-SLSHST-REC SLMN-ID
                                ORD-ID

Output

A sample of the first screen of output generated from the preceding query follows:

 =>
 
 ------------------------------------------------------------------------DQED0
 DATAQUERY:  COLUMN VALUE DISPLAY                      ROW 00001 PAGE  00001
 -----------------------------------------------------------------------------
 SLMN-ID                          I4790
 ORD-ID                           01002
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 -----------------------------------------------------------------------------
 <PF1> HELP          <PF2> RETURN        <PF3> PREV ROW      <PF4> NEXT ROW
 <PF5> NOT USED      <PF6> STATS         <PF7> BACKWARD      <PF8> FORWARD