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-2
Setting Up Your Session Environment
If an object is on the current default volume and subvolume, you can omit everything
but the table or view name. The system expands the name by using the current default
system, volume, and subvolume.
You can use the ENV command to display the current default settings, as shown in
Figure 2-1.
If you have not set the default system, the default is the system on which you started
your session. The system name appears in the environment report only if you specify
the name in a SYSTEM command or in an ALTER DEFINE command that changes the
=_DEFAULTS DEFINE. For more information about DEFINEs, see the SQL /MP
Reference Manual.
Figure 2-1. Setting Up Your Session Environment
>> ENV;
--------------------------------
Current Environment
--------------------------------
CATALOG
LANGUAGE AMERICAN ENGLISH
LOG
MESSAGEFILE \SYS.$SYSTEM.SYSTEM.SQLMSG
MESSAGE VRSN 315
OUT \SYS1.$TERM1
OUT_REPORT $S.#PRINTER
SYSTEM \SYS1
TRANSACTION ID
VOLUME $VOL5.SUBV1
WORK NOT IN PROGRESS
VST0201.vsd