SQL/MX Report Writer Guide

HP NonStop SQL/MX Report Writer Guide—527194-002

1-1

Introduction to the NonStop

SQL/MX Report Writer

NonStop SQL/MX is a relational database management system that uses the industry

standard SQL language to define and manipulate data. The SQL/MX conversational

interface (MXCI) includes a report writer that enables you to format data retrieved with

a SELECT command and to display or print the formatted data in a report. The report

writer consists of formatting commands and a set of options that you can set to control

the layout and style of reports.

When you are preparing a report, you can also use general MXCI commands to control

your session environment.

Examples and database references in this guide refer to the SQL/MX sample

database. See the SQL/MX Reference Manual for details.

Accessing Data From SQL/MP Tables

SQL/MX Report Writer supports SQL/MP tables. You can access data from SQL/MP

tables by creating an alias using the CREATE SQLMP ALIAS statement. Also,

SQL/MP tables, views, indexes, and catalogs can be accessed by using SQL/MX DML

statements. For details, see the SQL/MX Reference Manual.

Accessing Data From SQL/MP Tables 1-1

Database Organization 1-2

Report Development Steps 1-4

Default Report Format 1-6

Customized Reports 1-8

Report Formatting Commands 1-14

Report Formatting Command Clauses 1-15

Style Options 1-15

Layout Options 1-16

Report Functions 1-17

MXCI Commands 1-17

Note. The SELECT command referred to in this manual is a SELECT statement you enter by

using MXCI in report writer mode.