HP 3000 Manuals HP 3000 Manuals
REPORT ALL
Prints data item values of entries located by the last retrieval command
without formatting.
Syntax
[,character]
R[EPORT] [output control statements;] ALL [,- ]
For example:
>REPORT ALL,X
Where character = X
Parameters
output control alter the standard output parameters. (Refer to
statements 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 3-5. REPORT ALL Options
----------------------------------------------------------------------------------------------
| | | |
| COMMAND | OVERPUNCH | DATA ITEM |
| | USED | NAMES PRINTED |
| | | |
----------------------------------------------------------------------------------------------
| | | |
| REPORT ALL | Y | Y |
| | | |
| REPORT ALL, X | Y | N |
| | | |
| REPORT ALL, - | N | Y |
| | | |
----------------------------------------------------------------------------------------------
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 3-6 shows the overpunch characters.
For example, the number -104 is represented as 10M in QUERY.
Table 3-6. Overpunch Characters
-----------------------------------------------------------------------------------------------
| | | |
| RIGHTMOST DIGIT | POSITIVE | NEGATIVE |
| IN VALUE | REPRESENTATION | REPRESENTATION |
| | | |
-----------------------------------------------------------------------------------------------
| | | |
| 0 | } | } |
| | (may vary with terminal) | (may vary with terminal) |
| | | |
| 1 | A | J |
| | | |
| 2 | B | K |
| | | |
| 3 | C | L |
| | | |
| 4 | D | M |
| | | |
| 5 | E | N |
| | | |
| 6 | F | O |
| | | |
| 7 | G | P |
| | | |
| 8 | H | Q |
| | | |
| 9 | I | R |
| | | |
-----------------------------------------------------------------------------------------------
Table 3-7 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 3-7. Output of P and Z Type Values
-------------------------------------------------------------------------------------------------
| | | | |
| COMMAND AND | VALUE INPUT AS: | VALUE INPUT AS: | VALUE INPUT AS: |
| DATA TYPE | +55 | 55 | -55 |
| | | | |
-------------------------------------------------------------------------------------------------
| | | | |
| REPORT ALL | | | |
| | | | |
| P4 TYPE | ITEMNAME = 0055 | ITEMNAME = 0055 | ITEMNAME = 005N |
| | | | |
| Z4 TYPE | ITEMNAME = 005E | ITEMNAME = 0055 | ITEMNAME = 005N |
| | | | |
-------------------------------------------------------------------------------------------------
| | | | |
| REPORT ALL, X | | | |
| | | | |
| P4 TYPE | 0055 | 0055 | 005N |
| | | | |
| Z4 TYPE | 005E | 0055 | 005N |
| | | | |
-------------------------------------------------------------------------------------------------
| | | | |
| REPORT ALL, - | | | |
| | | | |
| P4 AND Z4 TYPES | ITEMNAME = 55 | ITEMNAME = 55 | ITEMNAME = -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.