Command and SET Parameter Summary

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.).


Top of page

x
GRAPH Command

How to:

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.



x
Syntax: How to Enter the Environment

To enter the GRAPH environment, enter the following:

GRAPH FILE filename


x
Syntax: How to Specify Annotating Text

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


x
Syntax: How to Name the Subject and Graph Type

The following syntax is used to specify the subject and graph type:

command object1 [[AND|OVER] object2...object5]

where:

command

Is one of the following: PRINT, WRITE, SUM, ADD or COUNT.



x
Syntax: How to Specify Display Fields

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']


x
Syntax: How to Specify Horizontal Sorting of Data Points

The following syntax is used for horizontal sorting of data:

ACROSS fieldname  [IN-GROUPS-OF n [TOP]][AS 'string']
ACROSS fieldname  [IN position]


x
Syntax: How to Specify Separate Graphs or Vertical Sorting of Plot Points

The following syntax is used:

BY fieldname [IN-GROUPS-OF n [TOP]][AS 'string']


x
Syntax: How to Save the Formatted Graph Data in a File

The following syntax is used:

ON [GRAPH] SAVE [AS filename] FORMAT GRAPH


x
Syntax: How to Complete the GRAPH Request

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:



x
Syntax: How to Concatenate Unlike Data Sources

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.


Top of page

x
SET Parameters

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.

PRINT
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