In this section: |
The FOCUS GRAPH command plots data retrieved with request statements in the form of a graph, with horizontal and vertical axes. Many of the elements used in TABLE requests are used in exactly the same way in GRAPH requests.
The GRAPH environment also includes a set of parameters that control the look of the graph and offer additional control at run time (for example, pause to adjust paper before printing, select a device, etc.).
In the syntax samples that follow, the elements are the same as those used in TABLE requests. The complete set is shown here but the elements are described more fully in Chapter 4, Sorting Tabular Reports.
To enter the GRAPH environment, enter the following:
GRAPH FILE filename
Heading strings can contain any character except the double quotation mark ("), and can also contain field references and formatting controls.
Heading: This syntax is used to specify graph headings:
[HEADING [CENTER]] "string1" ["string2"]
Field reference format: This syntax is used to specify field reference format:
<[prefix.]fieldname[>]
Formatting controls: The following formatting controls may be specified as part of a graph request:
Tab to column "n" . . . . . . . . .<n Tab "n" columns to the right . . . .<+n Tab "n" columns to the left . . . . <-n Return to column 1 and advance "n" lines. . . . . . .</n Name a color for a line . . . . . . <.color Select special font [BIG, SLANT or BLOCK on HP7220]. .<.fontname ("BIG" doubles the character sizes, "BLOCK" quadruples them) Reset controls to default settings <.CLEar
The following syntax is used to specify the subject and graph type:
command object1 [[AND|OVER] object2...object5]
where:
Is one of the following: PRINT, WRITE, SUM, ADD or COUNT.
Display fields can be any of the following:
[prefix.]fieldname [AS 'string'] [IN position] COMPUTE name1 [/format1] = expression1;[AS 'string1'] COMPUTE name2 [/format2] = expression2;[AS 'string2']
The following syntax is used for horizontal sorting of data:
ACROSS fieldname [IN-GROUPS-OF n [TOP]][AS 'string'] ACROSS fieldname [IN position]
The following syntax is used:
BY fieldname [IN-GROUPS-OF n [TOP]][AS 'string']
The following syntax is used:
ON [GRAPH] SAVE [AS filename] FORMAT GRAPH
To complete a graph request, type the command END on a separate line:
END
If you do not wish to complete the graph request, use one of the following methods to abort the request and return to FOCUS:
QUIT
HT
To concatenate unlike data sources in a single graph request, divide your request into one main request that retrieves the first file, and a subrequest for each concatenated file. The main request defines the data fields, sorting criteria, and output format for each file. The MORE command concatenates each file after the first. The syntax is:
GRAPH FILE file1 main request MORE FILE file2 subrequest MORE . . . END
Note: IF and WHERE selection tests apply only to the subrequest in which they appear.
To set the parameters that control the GRAPH environment, use the appropriate variation of the SET command. The syntax is as follows:
SET parameter=value,parameter=value...
For example:
SET HAXIS=75,VAXIS=40 SET GRID=OFF,BARSPACE=2,BARWIDTH=3
Note:
To review the current parameter settings, issue the command:
? SET GRAPH
which produces a listing of the values.
The table that follows lists all of the parameters in alphabetic sequence, showing the name, range of values (default is underlined), and function of each.
Parameter Name |
Range of Values |
Parameter Function |
---|---|---|
AUTOTICK |
ON/OFF |
When ON, FOCUS automatically sets the tick mark intervals. (See also HTICK and VTICK.) |
BARNUMB |
ON/OFF |
Places the summary values at the ends of the bars on bar charts, or slices on pie charts. |
BARSPACE |
0-32767 |
Specifies the number of lines separating the bars on bar charts. |
BARWIDTH |
1-32767 |
Specifies the number of lines per bar on bar charts. |
BSTACK |
ON/OFF |
Specifies that the bars on a bar chart are to be stacked rather than placed side by side. |
DEVICE or TERMINAL |
IBM3270 |
Specifies the plotting device or terminal to be used. When the default is used, low-resolution graphics are sent to your terminal or to the printer if PRINT=OFFLINE (see the SET command in the Developing Applications manual). Medium- and high-resolution devices are selected by entering one of the following parameter settings for the DEVICE (or TERMINAL). |
Medium-resolution devices: |
||
|
AJ |
Specifies Anderson Jacobson - Model AJ830. |
|
AJ12 |
Specifies Anderson Jacobson - Model AJ832 (12 Pitch). |
|
DIABLO |
Specifies Diablo - Model 1620. |
|
DIABLO12 |
Specifies Diablo - Model 1620 (12 Pitch). |
|
GS |
Specifies Gencom. |
|
GS12 |
Specifies Gencom (12 Pitch). |
|
HIGHRES |
Specifies generic device for most medium-resolution graphic devices. |
|
HIGHRS12 |
Specifies generic device -see above (12 Pitch). |
|
TRENDATA |
Specifies Trendata - Model 4000A. |
|
TRENDT12 |
Specifies Trendata - Model 4000A (12 Pitch). |
High-resolution devices from Hewlett-Packard: |
||
|
HP7220 |
Specifies HP Models 7229A and 7470A. Both are 4-pen plotters with no paper advance. Model 7470 requires a special Y cable (Part #17455). |
|
HP7220S |
Specifies HP Model 7220S, 4-pen plotter with paper advance. |
|
HP7220C |
Specifies HP Models 7220C and 7475A. Both are 8-pen plotters with no paper advance. Model 7475 requires a special Y cable (Part #17455). |
|
HP7220T |
Specifies HP Model 7220T, 8-pen plotter with paper advance. |
|
HP7221 |
Specifies HP Model 7221, 4-pen plotter with no paper advance. |
|
HP7221S |
Specifies HP Model 7221S, 4-pen plotter with paper advance. |
|
HP7221C |
Specifies HP Model 7221C, 8-pen plotter with no paper advance. |
|
HP7221T |
Specifies HP Model 7221T, 8-pen plotter with paper advance. |
Note: The default horizontal and vertical axes for all Hewlett-Packard devices are as follows:
HAXIS=100, VAXIS=50.
Parameter Name |
Range of Values |
Parameter Function |
---|---|---|
High-resolution devices from IBM: |
||
|
IBM3279 |
Specifies one of the following devices: Any IBM 3270 series device that supports GDDM graphics, such as the 3279-S3G, 3179, or 3472. This includes PCs with fully compatible 3270 series hardware and software. Printers: Any IBM 3270 series printer that supports GDDM graphics, such as the 3287-2C and the 4224. |
Note: IBM's Graphical Data Display Manager (GDDM) is required for all of these devices. Entering this value automatically sets the following GRAPH parameter values: HAXIS=80, VAXIS=32, and GCOLOR=ON. For any monochrome device, you should set GCOLOR=OFF; for any Model 2 device (24x80 screen), you should set VAXIS=-24.
Parameter Name |
Range of Values |
Parameter Function |
---|---|---|
High-resolution devices from Tektronix: |
||
|
TEK4010 |
Specifies one of the following models: 4010, 4050 series and 4100 series (B/W only). Automatically sets HAXIS=74, VAXIS=35, and GCOLOR=OFF. |
|
TEK4012 |
Specifies Model 4012. Automatically sets HAXIS=74, VAXIS=35, and GCOLOR=OFF. |
|
TEK4013 |
Specifies Model 4013. Automatically sets HAXIS=74, VAXIS=35, and GCOLOR=OFF. |
|
TEK4014 |
Specifies Model 4014. Automatically sets HAXIS=133, VAXIS=64, and GCOLOR=OFF. |
|
TEK4014E |
Specifies Model 4014E. Automatically sets HAXIS=133, VAXIS=64, and GCOLOR=OFF. |
|
TEK4015 |
Specifies Model 4015. Automatically sets HAXIS=74, VAXIS=35, and GCOLOR=OFF. |
|
TEK4015E |
Specifies Model 4015E. Automatically sets HAXIS=74, VAXIS=35, and GCOLOR=OFF. |
|
TEK4025 |
Specifies Model 4025. Automatically sets HAXIS=80, VAXIS=32, and GCOLOR=OFF. |
|
TEK4027 |
Specifies Model 4027. Automatically sets HAXIS=80, VAXIS=32, and GCOLOR=ON. |
|
TEK4662 |
Specifies Model 4662. Plot address is D. It is recommended that you set GCOLOR=OFF, HAXIS=80, VAXIS=32. If the Model 4662 is connected to a Model 4025, set DEVICE=TEK4025. If the Model 4662 is connected to a Model 4027, set DEVICE=TEK4027. |
Parameter Name |
Range of Values |
Parameter Function |
---|---|---|
FRAME |
ON/OFF |
For GDDM graphics, ON (the default) indicates you want a frame around your graph. To omit the Frame, set OFF. |
GCOLOR (or GRIBBON) |
ON/OFF |
On medium- and high-resolution devices, setting this parameter OFF causes different black and white patterns to be substituted for colors. On medium-resolution devices, setting it ON causes alternation between black and red ribbons on multiline plots. Note: 3287 printers use black, red, blue, and green. |
GMISSING |
ON/OFF |
If ON, specifies that variables with the value specified in GMISSVAL are to be ignored. |
GMISSVAL |
nn |
Specifies the variable value that represents missing data. |
GPROMPT |
ON/OFF |
When ON, FOCUS prompts for all pertinent graph parameters. |
GRIBBON |
See GCOLOR. |
|
GRID |
ON/OFF |
When ON, specifies that a grid of parallel horizontal lines is to be drawn on the graph at the vertical class marks (see also VGRID). |
GTREND |
ON/OFF |
When ON, specifies that a trend line is to appear on scatter diagrams. |
HAUTO |
ON/OFF |
Specifies automatic scaling of the horizontal axis unless overridden by the user. If OFF, user must supply values for HMAX and HMIN. |
HAXIS |
20-130 |
Specifies the width in characters of the horizontal axis. This parameter can be adjusted for graphs generated OFFLINE. HAXIS is ignored for ONLINE displays, since FOCUS automatically adjusts the width of the graph to the width of the terminal. |
HCLASS |
nnn |
Specifies the horizontal class interval when AUTOTICK=OFF. |
HISTOGRAM |
ON/OFF |
When ON, FOCUS draws a histogram instead of a curve when values on the horizontal axis are not numeric. |
HMAX |
nnn |
Specifies the maximum value on the horizontal axis when automatic scaling is not used (HAUTO=OFF). |
HMIN |
nnn |
Specifies the minimum value on the horizontal axis when automatic scaling is not used (HAUTO=OFF). |
HSTACK |
ON/OFF |
Specifies that the bars on a histogram are to be stacked rather than placed side by side. |
HTICK |
nnn |
Specifies the horizontal axis tick mark interval, when AUTOTICK is OFF. |
PAUSE |
ON/OFF |
Specifies whether there is a pause for paper adjustment on the plotter after the request is executed. |
PIE |
ON/OFF |
Specifies a pie chart is desired (only available on high-resolution devices). |
PLOT |
Specifies the width and height settings for a graphic printer if DEVICE=IBM3279 or HIGHRES. Hexadecimal values must be supplied. For example: SET PLOT=0050,0018 produces a printed plot 80 by 24 decimal characters (50 hex = 80 decimal, 18 hex = 24 decimal). When used, the PLOT parameter must be the last parameter set. |
|
ONLINE/OFFLINE |
When OFFLINE is entered, the graph is printed on the system high-speed printer. |
|
TERM |
See DEVICE. |
|
VAUTO |
ON/OFF |
Specifies automatic scaling of the vertical axis unless overridden by the user. If OFF, the user must supply values for VMAX and VMIN. |
VAXIS |
20-66 |
Page length in lines. This parameter can be adjusted for graphs generated OFFLINE. VAXIS is ignored for ONLINE displays, since FOCUS automatically adjusts the height of the graph to the height of the terminal. |
VCLASS |
nnn |
Specifies the vertical class interval when AUTOTICK=OFF. |
VGRID |
ON/OFF |
When ON, specifies that a grid of parallel vertical lines is to be drawn on the graph at the horizontal class marks (see also GRID). |
VMAX |
nnn |
Specifies the maximum value on the vertical axis when automatic scaling is not used (VAUTO=OFF). |
VMIN |
nnn |
Specifies the minimum value on the vertical axis when automatic scaling is not used (VAUTO=OFF). |
VTICK |
nnn |
Specifies the vertical axis tick mark interval, when AUTOTICK is OFF. |
VZERO |
ON/OFF |
With VZERO=OFF, missing values on the vertical axis are ignored. If ON, the values are treated as zero (0). |
|
Information Builders |