SQL/MP Report Writer Guide
Table Of Contents
- What’s New in This Manual
- About This Manual
- 1 Introduction to the NonStop SQL/MP Report Writer
- 2 Using SQLCI and the Report Writer
- 3 Selecting Data for a Report
- 4 Customizing a Report
- Defining the Layout
- Specifying the Items in a Detail Line
- Naming Select List and Detail Line Items
- Organizing Rows Into Break Groups
- Labeling Information
- Formatting Data Values
- Formatting Dates and Times
- Using TACL to Pass Parameters
- Conditional Printing of Items or Line Entries
- Redefining Special Characters
- Calculating Totals
- Calculating Subtotals
- Printing Double-Byte Characters
- A Comparison of the Report Writer and the Enform Language
- Index
Using SQLCI and the Report Writer
HP NonStop SQL/MP Report Writer Guide—527213-001
2-3
Setting Up Your Session Environment
Other elements of your session environment are:
Setting the Default Volume and Subvolume
To set the default volume and subvolume, enter the VOLUME command:
>> VOLUME $VOL1.PERSNL;
The system you are using to run SQLCI is the default system unless you enter a
SYSTEM or VOLUME command to specify some other default system.
Setting and Displaying Options
There are three basic commands for working with options: SET, RESET, and SHOW.
Layout options, such as line spacing and margin settings, control the appearance of a
report on the screen or printed page.
Style options, such as the decimal character and underline character, control the
appearance of items in a report.
Session options primarily affect the way SQLCI communicates with you: for example,
how many lines of SELECT output appear before a pause, how SQLCI responds to the
BREAK key, whether output lines that exceed the output device width are wrapped or
CATALOG The current default catalog; this catalog does not affect your report
writing activity.
LANGUAGE The language of the text in the message file.
LOG The file to which SQLCI logs your session activity. SQLCI writes the
commands you enter and the output produced by the commands to
the log file. For example, a SELECT command and the rows
selected by the command are written to the log file. You specify the
log file in a LOG command. You can request that only commands be
logged.
MESSAGEFILE The name of the current SQL message file.
MESSAGE VRSN The version of the NonStop SQL/MP software in use.
OUT The file to which SQLCI writes output from commands, prompts, and
messages. By default, the OUT file is usually your terminal. You can
enter the OUT command to specify another OUT file.
OUT_REPORT The file to which SQLCI writes the output from SELECT commands.
If you have not entered an OUT_REPORT command to specify an
OUT_REPORT file, the output from SELECT commands is written to
the OUT file.
TRANSACTION ID The transaction identifier of the current TMF transaction, if one is in
progress.
WORK The current state of TMF transactions. IN PROGRESS indicates a
TMF transaction has been initiated. NOT IN PROGRESS indicates
that no transaction has been initiated since any previous transaction
was committed or aborted.