HPlogo QUERY/iX Reference Manual > Chapter 6 QUERY/iX COMMANDS (cont)

REPORT ALL

MPE documents

Complete PDF
Table of Contents

E0300 Edition 7 ♥
E1098 Edition 6

Prints data item values of entries located by the last retrieval command without formatting.

Syntax


  R[EPORT]  [output control statement;] ALL [,character][,-]
For example: 

  >REPORT ALL,X
Where character = X

Parameters

output control statements

alter the standard output parameters. (Refer to the section on Output Control Statements under the REPORT command.)

character

is any printable ASCII character, except a minus sign (-). When character is used, the data item names are omitted from the report. In addition, negative values of type P or Z and positive values of type Z are printed with an overpunch character.

-

is a minus sign. When a minus sign is used, the data item names are printed with the data item values. In addition, QUERY edits negative values of type P or Z and positive values of type P to include the value sign. If the minus sign (-) not is used, negative values of type P or Z and positive values of type Z are printed with an overpunch character. Refer to the next page for more information on overpunch.

Discussion

The REPORT command prints a report of the data entries located by the last FIND, MULTIFIND, or SUBSET command.

REPORT output can be directed to any desired output device through the MPE :FILE command and the QUERY OUTPUT= command. Refer to the OUTPUT= command for more information.

If you are using REPORT ALL on an item type of U or X with a length greater than 50 characters, QUERY prints the data item value in multiples of 50 characters.

If you are using the REPORT ALL command in session mode and output is defined as LP, QUERY leaves 2 blank lines at the end of the page (page default is 60 lines). Extra lines can be eliminated by using the NOPAGE output control statement.

For multiple data set access (refer to the JOIN and MULTIFIND commands), REPORT ALL prints the data base name and data set name for each data set entry contained in a compound entry.

The following table summarizes the REPORT ALL options:

Table 6-1 REPORT ALL Options

COMMAND OVERPUNCH USED DATA ITEM NAMES PRINTED
REPORT ALLYY
REPORT ALL, XYN
REPORT ALL, -NY

Overpunch Characters

If the minus option is not used, QUERY prints negative values of type P or Z and positive values of type Z with a special character in the rightmost digit substituting for the minus or plus sign. This special character is called an overpunch character and varies according to the rightmost digit in the value. Table 6-2 "Overpunch Characters" shows the overpunch characters. For example, the number -104 is represented as 10M in QUERY.

Table 6-2 Overpunch Characters

RIGHTMOST DIGIT IN VALUE POSITIVE REPRESENTATION NEGATIVE REPRESENTATION
0{}
 (may vary with terminal)(may vary with terminal)
1AJ
2BK
3CL
4DM
5EN
6FO
7GP
8HQ
9IR

Table 6-3 "Output of P and Z Type Values" shows the representation of P and Z type values which depends on how you entered the value and which REPORT ALL option, if any, you used. In this table, P4 and Z4 data types are shown. The output may vary for other lengths.

Table 6-3 Output of P and Z Type Values

COMMAND AND DATA TYPE VALUE INPUT AS: +55 VALUE INPUT AS: 55 VALUE INPUT AS: -55
REPORT ALL
P4 TYPEITEMNAME = 0055ITEMNAME = 0055ITEMNAME = 005N
Z4 TYPEITEMNAME = 005EITEMNAME = 0055ITEMNAME = 005N
REPORT ALL, X
P4 TYPE00550055005N
Z4 TYPE005E0055005N
REPORT ALL, -
P4 AND Z4 TYPESITEMNAME = 55ITEMNAME = 55ITEMNAME = -55

Examples

Example 1 

  >FIND ALL LAST-NAME
  USING SERIAL READ
  13  ENTRIES QUALIFIED
  >REPORT ALL

  ACCOUNT          =54283540
  LAST-NAME        =CORCORAN
  FIRST-NAME       =CLIFFORD
  INITIAL          =C
  STREET-ADDRESS   =6105 VALLEY GREEN DR.
  CITY             =CARMEL
  STATE            =CA
  ZIP              =93921
   .                  .
   .                  .
   .                  .
As shown in the example above, once entries have been found, REPORT ALL prints the value for each item to which you have access.

Example 2 

  >REPORT ALL,X

  54283540
  CORCORAN
  CLIFFORD
  C
  6105 VALLEY GREEN DR.
  CARMEL
  CA
  93921
  7.10000

  54283545
  MAYFIELD
  WILLIAM
  CONTROL-Y
  < CONTROL Y >
When REPORT ALL is used with a character, the data values are printed without the data item names and data set names. You can terminate the report at any time by entering CONTROL-Y.



Chapter 6 QUERY/iX COMMANDS (cont)

REPORT procedure