SQL/MX 3.2 Report Writer Guide (H06.25+, J06.14+)

Contents
HP NonStop SQL/MX Release 3.2 Report Writer Guide—691130-001
ii
3. Selecting Data for a Report
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
Preparing a SELECT Command 3-25
Using Views 3-26