Welcome to jBASE's new documentation site! Many answers to your questions can be found by searching the Knowledgebase or viewing the jBASE Documentation. We also have a Google Group for peer discussion about jBASE. If you are unable to find the information you are looking for, jBASE Support will be glad to assist in resolving your technical problems. Enjoy and please provide comments and feedback .

How can we help you?

SORT-LABEL

Description

Outputs data in a format suitable for producing labels.  It takes the general form:

SORT-LABEL file-specifier {record-list} {selection-criteria} {sort-criteria} {USING file-specifier}{output-specification} {format-specification} {(options}

 the user is then prompted to supply formatting criteria as:

COL,ROW,SKIP,INDENT,SIZE,SPACE(,C):

where: 

COL
Number of columns required to list the data across the page.
ROW
Number of lines for each record. Each element of the output specification will be output on a separate line, if more elements exist in the output specification than there are rows specified, the extra elements will be ignored. If more rows are specified than elements, the output specification for these rows will be blank.
SKIP
Number of blank lines between each record.
INDENT
Number of spaces for left margin.
SIZE
Number of spaces required for the data under each column.
SPACE
Number of horizontal spaces to skip between columns.
C
Optional. Suppresses null or missing data. If absent, null or missing values are output as blanks. If present the C must be upper case and not in quotes.

 

Note: 

The total number of columns specified must not exceed the page width, based on the calculation:

COLs * (SIZE + SPACE) + INDENT <= page width

ROW must be a minimum of one for each field, plus one for the record key (if not suppressed). If record keys are not suppressed, the first row of each label will contain the record key. The records will be sorted in key order unless you specify a sort criteria clause.

If INDENT is not zero, the user will be prompted to supply a series of HEADERs that will appear in the left margin for each field. If a heading is not required for a particular line, press RETURN.

Multivalued fields appear on separate lines.

If COL-HDR-SUPP or HDR-SUPP, or the C or H options are specified, the page number, date, and time will not be output and the report will be generated without page breaks.


See also the LIST-LABEL command.

Back to JQL

Was this article helpful?