SQL/MX Report Writer Guide

Contents
HP NonStop SQL/MX Report Writer Guide—527194-002
ii
2. Using MXCI and the Report Writer
2. Using MXCI and the Report Writer
Setting the Default Directory 2-1
Starting and Ending an MXCI Session 2-2
The Select-in-Progress Prompt 2-2
Setting Up Your Session Environment 2-2
The Elements of Your Session Environment 2-3
Invoking Report Writer Mode 2-4
Setting and Displaying Options 2-5
Listing Rows of a Report 2-6
Canceling a SELECT Command 2-7
Defining Options for Line Folding 2-7
Defining a Window for Report Output 2-8
Entering Report Formatting Commands 2-10
Specifying Log Files 2-13
Executing a Command Repeatedly 2-13
Repeating Stored Commands 2-14
Defining Reports in Command Files 2-15
Creating a Command File With a Text Editor 2-16
Creating a Command File From a Log File 2-16
3. Selecting Data for a Report
Data Selection 3-1
Developing a Query 3-2
Locating the Data 3-2
Joining Tables 3-4
Using the WHERE Clause 3-4
Selecting Columns of Source Data 3-5
Setting Criteria for Selecting Data 3-6
Comparing a Set of Columns to a Set of Values 3-10
Comparing Character Values 3-11
Specifying More Than One Condition 3-14
Sorting the Data 3-15
Grouping Data for Calculations 3-16
Counting Rows 3-18
Determining Minimum and Maximum Values 3-19
Determining Which Columns to Group 3-20
Selecting Distinct Rows 3-21
Using Expressions to Calculate Report Values 3-22
Using Parameters With SELECT Commands 3-24