Producing Vertical Listings with LIST-ITEM

Two INFO/ACCESS commands, LIST-ITEM and SORT-ITEM, produce a vertical display of all the data in specified file items, one item per page. Data is listed as it is stored in the file with no conversion codes applied.

The next query lists the item BLEAR6803 from the CUSTOMERS file:

>LIST-ITEM CUSTOMERS 'BLEAR6803'

 

 

PAGE   1

10:59:15  DD MMM YYYY

 

 

BLEAR6803

 

001 BILL

 

002 LEARY

 

003 34 TREMONT STREET

 

004 BOSTON

 

005 MA

 

006 6175278890

 

007 74332

 

008 918-27-3645

 

 

 

>

 

The SORT-ITEM command works the same way, except it also sorts the items by the specified attribute. This query sorts all items in the CUSTOMERS file by state, then by last name, and sends the report to the printer:

>SORT-ITEM CUSTOMERS BY STATE BY LAST-NAME (P)

See Also

Producing Reports with LIST and SORT

Using the LIST and SORT Commands

Displaying Selected Attributes

Using Selection Expressions

Using SORT Expressions

Using Print Limiters