VAX DATATRIEVE Guide to Using Graphics

*HyperReader

  CONTENTS

  Title Page

  Copyright Page

  Preface

  1      Getting Started with DATATRIEVE Plots

  1.1     Required and Optional Equipment
    1.1.1      Video Terminals
    1.1.2      Hardcopy Output Devices

  1.2     Steps to Take Before Using DATATRIEVE Plots

  1.3     Changing from a PRINT Statement to a Plot Statement
    1.3.1      Plot Statement Using Data from a Collection
    1.3.2      Plot Statement Using Data from RSE
    1.3.3      Same Plot Produced by FIND Statement and RSE

  2      Basic Types of DATATRIEVE Plots

  2.1     Bar Charts

  2.2     Scattergraphs and Line Graphs

  2.3     Pie Charts

  2.4     Utility Plots

  3      Choosing, Designing, and Improving Your Plot

  3.1     Determining the Purpose of Your Plot

  3.2     Five Types of Relationships
    3.2.1      Time Comparisons (Line Graphs, Scattergraphs, Bar Charts)
      3.2.1.1      Line Graphs and Scattergraphs for Time Comparisons
      3.2.1.2      Bar Charts for Time Comparisons
    3.2.2      Parts of the Whole (Pie Chart, Bar Chart)
    3.2.3      Comparing Several Items (Bar Chart, Pie Chart)
    3.2.4      Comparing Multiple Values (Line Graph, Scattergraph, Bar Chart)
    3.2.5      Frequency Distribution (Histogram)

  3.3     Designing and Improving Plots
    3.3.1      Guidelines for Designing Plots
    3.3.2      Improving Plots

  Reference Section

  4      DATATRIEVE Plot Statements

  4.1     Syntax Common to All Plot Statements

  4.2     Labels with DATATRIEVE Plots
    4.2.1      Default Labels
    4.2.2      Specifying Label Strings
    4.2.3      Eliminating Scientific Notation

  4.3     PLOT BAR Statement

  4.4     PLOT BAR_ASCENDING Statement

  4.5     PLOT BAR_AVERAGE Statement

  4.6     PLOT BIG Statement

  4.7     PLOT CONNECT Statement

  4.8     PLOT CROSS_HATCH Statement

  4.9     PLOT DATE_LOGY Statement

  4.10    PLOT DATE_Y Statement

  4.11    PLOT HARDCOPY Statement

  4.12    PLOT HISTO Statement

  4.13    PLOT LEGEND Statement

  4.14    PLOT LIMITS_X Statement

  4.15    PLOT LIMITS_Y Statement

  4.16    PLOT LOGX_LOGY Statement

  4.17    PLOT LOGX_Y Statement

  4.18    PLOT LR Statement

  4.19    PLOT MONITOR Statement

  4.20    PLOT MULTI_BAR Statement

  4.21    PLOT MULTI_BAR_GROUP Statement

  4.22    PLOT MULTI_LINE Statement

  4.23    PLOT MULTI_LR Statement

  4.24    PLOT MULTI_SHADE Statement

  4.25    PLOT NEXT_BAR Statement

  4.26    PLOT PAUSE Statement

  4.27    PLOT PIE Statement

  4.28    PLOT RAW_BAR Statement

  4.29    PLOT RAW_PIE Statement

  4.30    PLOT REFERENCE_X Statement

  4.31    PLOT REFERENCE_Y Statement

  4.32    PLOT RE_PAINT Statement

  4.33    PLOT SHADE Statement

  4.34    PLOT SORT_BAR Statement

  4.35    PLOT STACKED_BAR Statement

  4.36    PLOT TITLE Statement

  4.37    PLOT VALUE_PIE Statement

  4.38    PLOT WOMBAT Statement

  4.39    PLOT X_LOGY Statement

  4.40    PLOT X_Y Statement

  5      Using DATATRIEVE Plots with Other Database Products

  5.1     Using DATATRIEVE Plots with VAX DBMS

  5.2     Using DATATRIEVE with Relational Databases

  A   Record Definitions Used in This Manual

  A.1     ANNUAL_REC Record Definition

  A.2     PERSONNEL_REC Record Definition

  A.3     YACHT Record Definition

  A.4     SALES_REC Record Definition

  A.5     PAYABLES_REC Record Definition

  FIGURES

  1-1        The PLOT MONITOR Screen for Color Terminals

  1-2        Plot Produced by FIND Statement or RSE

  2-1        A Simple Bar Chart

  2-2        Reading a Line Graph

  2-3        A Sample Pie Chart

  3-1        Frequency Distribution

  3-2        Multiple Bar Chart Before Improvement

  3-3        Multiple Bar Chart After Improvement

  3-4        Sorting Bars in a PLOT MULTI_BAR Statement

  3-5        Bar Chart with a Title

  5-1        Plotting VAX DBMS Data

  5-2        VAX DBMS Many-to-Many Relationship

  5-3        Plot Created with VAX DBMS Data

  5-4        Using VAX DBMS Data in a Plot

  5-5        Plotting Data from a Single Relation

  5-6        Plotting Data from More than One Relation

  TABLES

  3-1        Five Types of Relationships

  3-2        Bar Charts for Time Comparisons

  4-1        Summary of Plot Statements