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
> |