LIST-LABEL Command

The LIST-LABEL command allows the user to specify a format for specialized block listings such as mailing labels. This command can be used to define how many blocks (or items) are displayed across each page or screen and how many rows (or attributes) are displayed for each block. The LIST-LABEL command also defines the number of vertical lines and horizontal spaces between blocks, the amount of indent from the left margin of the page or screen, and the maximum width of a row

Format

LIST-LABEL [DICT] filename [item-list] [selection] [output] [print] [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 selected. For a complete description of selection expression syntax, see the LIST Command.
output	Specifies which values from MultiValued attributes are to be included in the report. Use relational operators and values immediately following the name of the MultiValued attribute. Enclose values in double quotes or backslashes.
print	Specifies which values from MultiValued attributes are to be included in the report. Use relational operators and values immediately following the name of the MultiValued attribute. Enclose values in double quotes or backslashes.
modifiers	Include one or more keywords that specify the report format. These parameters affect headers, footers, spacing, totalling column figures, control breaks, and more. For complete information about using these keywords, see the section Connectives, Modifiers, and Options in the INFO/ACCESS User Reference Guide. Use the COL-HDR-SUPP modifier or the C option to suppress the header (page number, time, and date) at the top of each page of the report. This modifier also suppresses pagination and all top-of-forms, thus producing a continuous forms format without page breaks.
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

After the LIST-LABEL command is entered, the system displays the following prompt:

You can now determine the format of the label. Enter a response in the following format:

Format

count, rows, skip, indent, size, space [,C]

Parameter(s)

count	Number of labels (items) across each page or screen.
rows	Number of lines printed for each label. Remember to count the item-ID as one line. The item-ID is automatically included in the labels unless you use the ID-SUPP modifier or the I option in the query.
skip	Number of lines to skip vertically between labels.
indent	Number of indented spaces from the left margin to the label. Zero (0) is a valid response.
size	Maximum width for the data contained in each attribute (in other words, the width of each label in columns).
space	Number of horizontal spaces between labels.
C	Specifies that null attributes should not be printed. Otherwise, null attributes appear as all blanks. This parameter is optional.

The size parameter cannot exceed the page width (80 characters for terminals, and 80/132 characters for printers). Calculate label width as follows:

Format

(count * (size + space) + indent) <= (current page width)

Parameter(s)

current page width

Value defined by the TERM or SET-TERM commands for the terminal or printer.

If a value other than zero is specified for the indent parameter, the system prompts you to define headers for each row in a label:

The number of ? prompts corresponds to the value entered earlier for rows. At each ? prompt, enter the desired header. To avoid defining a header, simply press ENTER. Defined headers will appear at the left margin in the indent area of the listing.

Listing Items in a Mailing Label Format

The following example defines a format for a customer mailing, using sheets of mailing labels that have three labels in each horizontal row:

>LIST-LABEL CUSTOMERS FULL-NAME STREET CITY-ST ZIP ID-SUPP (C) ?3,4,2,0,20,5,C

JENKINS,HAROLD	PIRS,SANDRA	JOHNSON,ALICE
1222 MAIN ST.	112 APPLEBEE RD.	760 JEFFERSON ST.
INDIANAPOLIS,IN	WINSTON,NC	LOUISVILLE,KY
48865	88945	99475

LEARY,BILL	BOHANNON,JOHN	BUCKLER,JULIE
34 TREMONT ST.	126 TREMONT ST.	26 STONE AVE.
BOSTON,MA	BOSTON,MA	LINCOLN,IN
74332	21300	02144

PEERCE,JAN	JOHNSON,HENRY	ASH,MARY
89 RIALTO WAY	45 5OTH ST.	912A E. OAK ST.
LOS ALTOS,CA	OMAHA,NB	INDIANAPOLIS,IN
57685	39977	98754

EDGECOMB,DAVID	ORLANDO,AMY
338 BROADWAY	55 VENTURA HWY
MIAMI,FL	VENICE,CA
39007	89456

In the example above, the LIST-LABEL command defines a label format that consists of three labels across a page, four lines displayed for each label, two lines skipped between labels, no indented space from the left margin, a maximum of twenty characters for each attribute, five horizontal spaces between each label, and a continuous form report. This example also suppresses item-IDs.

Listing Labels with Defined Headers

The following example defines a format for a customer mailing similar to the one in the previous example. Here, however, headers have been defined for each row in a label:

>LIST-LABEL CUSTOMERS FULL-NAME STREET CITY-ST ZIP ID-SUPP (C) ?3,4,2,7,20,3,C ?Name ?Addr ?City ?Zip

Name	JENKINS,HAROLD	PIRS,SANDRA	JOHNSON,ALICE
Addr	1222 MAIN ST.	112 APPLEBEE RD.	760 JEFFERSON ST.
City	INDIANAPOLIS,IN	WINSTON,NC	LOUISVILLE,KY
Zip	48865	88945	99475

Name	LEARY,BILL	PEERCE,JAN	JOHNSON,HENRY
Addr	34 TREMONT ST.	89 RIALTO WAY	45 5OTH ST.
City	BOSTON,MA	LOS ALTOS,CA	OMAHA,NB
Zip	74332	57685	39977

Name	BOHANNON,JOHN	BUCKLER,JULIE	EDGECOMB,DAVID
Addr	126 TREMONT ST.	26 STONE AVE.	338 BROADWAY
City	BOSTON,MA	LINCOLN,IN	MIAMI,FL
Zip	21300	02144	39007

Name	ORLANDO,AMY	ORLANDO,AMY
Addr	55 VENTURA HWY	912A E. OAK ST.
City	VENICE,CA	INDIANAPOLIS,IN
Zip	89456	98754

The fourth format parameter, 7, specifies an initial indent of seven columns. The next four ? prompts correspond to the number of lines (rows) specified by the second format parameter. A header has been defined at each prompt.