SQL/MP Report Writer Guide

HP NonStop SQL/MP Report Writer Guide—527213-001
2-1
2
Using SQLCI and the Report Writer
You can control the environment of a report writing session by using general SQLCI
commands. To develop a report, you can do the following:
•
Start and exit an SQLCI session.
•
Set up attributes of your session environment such as default options, the default
volume, and output files.
•
Use windows to view vertical segments of a report.
•
Enter report formatting commands.
•
Execute commands repeatedly.
•
Define reports in command files.
For detailed syntax and descriptions of the SQLCI commands introduced in this
section, see the SQL/MP Reference Manual.
Starting and Ending an SQLCI Session
To start an SQLCI session, enter the following at the TACL prompt:
TACL 5> SQLCI
SQL Conversational Interface ...
>>
When waiting for a command, SQLCI displays the standard SQLCI prompt (>>). If you
have not completed a command by entering a semicolon (;), SQLCI displays the
command continuation prompt (+>) until a semicolon is entered.
When a SELECT command is in progress, SQLCI displays the select-in-progress
prompt (S>), indicating that SQLCI is waiting for report commands. To get this prompt,
you must set the LIST_COUNT session option before you enter a SELECT command.
For more information, see Listing Rows of a Report on page 2-5.
To end an SQLCI session, enter the following at the SQLCI prompt:
>> EXIT
Setting Up Your Session Environment
Any report you create is affected by the current environment of your SQLCI session,
such as the current default system, volume, and subvolume. When you specify the
name of a table or view, you can indicate the volume and subvolume that contain the
object by specifying the Guardian name of the object: for example:
\SYS1.$VOL1.SALES.ORDERS.