LIST-ITEM Command

The LIST-ITEM command displays all attribute values for specified file items. This command is useful for producing a simple listing of data or dictionary items.

Format

LIST-ITEM [DICT] filename [item-list] [selection] [modifiers] [(options)]

Parameter(s)

DICT

Specifies the file dictionary.

filename

Name of the file.

item-list

List of individual item-IDs. Enclose each item-ID in single quotes.

selection

Specifies one or more conditions that an item must meet to be included in the report. For a complete description of selection expression syntax, see the LIST Command.

modifiers

Include one or more keywords that specify the report format. These parameters affect headers, footers, spacing, and more. For complete information about using these keywords, see the section Connectives, Modifiers, and Options in the INFO/ACCESS User Reference Guide.

options

Include one or more single-character codes that specify the report format and direct or modify output. They must be enclosed in parentheses, can be entered in any order, and need not be separated by spaces or any delimiters such as commas. For complete information about using these parenthetical options, see the section Connectives, Modifiers, and Options in the INFO/ACCESS User Reference Guide.

Description

By default, the LIST-ITEM command displays items on the screen. The display includes line numbers for each attribute, unless the S option is used.

Listing a File Item

To list all attribute values of an item for a customer in the CUSTOMERS file, specify the item-ID. For example:

>LIST-ITEM CUSTOMERS "AORLA55VEN"

 

PAGE 1               10:36:26  dd mmm yyyy

   AORLA55VEN

001 AMY

002 ORLANDO

003 55 VENTURA HIGHWAY

004 VENICE

005 CA

006 6178905699X450

007 89456

008

>

The following example lists all data elements for customers from the CUSTOMERS file whose last name is Johnson. The example shows the use of the LIST-ITEM command with a selection expression.

>LIST-ITEM CUSTOMERS WITH LAST-NAME "JOHNSON"

 

PAGE 1               10:46:22  dd mmm yyyy

   AJOHN760JE

001 ALICE

002 JOHNSON

003 760 JEFFERSON STREET

004 LOUISVILLE

005 KY

006

007 99475

 

   HJOHN455OT

001 HENRY

002 JOHNSON

003 45 5OTH STREET

004 OMAHA

005 NB

006

007 39977

 

>