Entering jQL Command Sentence

A jQL Command sentence is entered at the shell in response to a Command prompt (:) or a select prompt (>). If a Command such as SELECT or GET-LIST creates an implicit list whilst in jSHELL, it displays the select prompt. Each sentence must start with a jQL Command and can be of any length. Press to submit the constructed sentence. If you enter an invalid Command, the system will reject it and display an appropriate error message.

Example

SORT SALES WITH PART.NO = "ABC]" BY POSTCODE CUST.NAME
POSTCODE TOTAL VALUE DBL-SPC HDR-SUPP (P

SORT the jQL Command.
SALES the filename
WITH PART.NO = "ABC]"

The selection criterion: select all records, which contain a part number beginning with ABC.
BY POSTCODE
The sort criterion
CUST.NAME POSTCODE TOTAL VALUE

The output specification:

• Column 1 will contain the key of the SALES file
• Column 2 will contain the customer name
• Column 3 will contain the POSTCODE.
• Column 4 will contain VALUE (this is totaled at the end of the report)

DBL-SPC HDR-SUPP The format specifications - Double-space the lines and suppress the automatic header.

(P An option: redirect output to the system printer, rather than to the terminal.PART.NO, CUST.NAME, POSTCODE, VALUE.

References to data definition records defined in the dictionary level of the SALES file