REPORT ALL

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 3-9 REPORT ALL Options

COMMAND	OVERPUNCH USED	DATA ITEM 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-10 “Overpunch Characters” shows the overpunch characters. For example, the number -104 is represented as 10M in QUERY.

Table 3-10 Overpunch Characters

RIGHTMOST DIGIT IN VALUE	POSITIVE REPRESENTATION	NEGATIVE 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-11 “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 3-11 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 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.