HP 3000 Manuals HP 3000 Manuals
Table of Contents
HP ALLBASE/BRW Reference Manual
HP ALLBASE/BRW Reference Manual : COPYRIGHT NOTICE
Ch 1. About HP ALLBASE/BRW
At a Glance
Features of HP ALLBASE/BRW
Report tuning
Layout features
Calculation language
Interface to HP DeskManager
Multiple application support
Multiple pass reporting
This chapter covers
Elements of BRW
The Developer Version
The Report Writer
BRWCONV
Run-time Only Version
HP BRW-Desk
Requirements
What You Need
BRW Files
Data Sources
Created Files
Temporary Files
Logical Components of the Specification File
Sample Databases
The TOYDB Database
The EXDBE Database
The PARTSDBE Database
Limits on HP ALLBASE/BRW
Item Types
Database and File Types
Printers
Report Characteristics
What Next?
Ch 2. Understanding Relational Data and Tables
At a Glance
This chapter covers
About Tables
Source Tables
Single-source Tables
Multiple-source Tables
Access Tables
About Relations
What Next?
Ch 3. Communicating with HP ALLBASE/BRW
At a Glance
This chapter covers
Using HP ALLBASE/BRW Screens
Entering and Editing Data
Editing Fields
Using Softkeys
The other keys Softkey
Using Quick Browse
Using Quick Copy
Getting Online Help
Understanding Messages and Prompts
Prompts
What Next?
Ch 4. Getting Started With HP ALLBASE/BRW
At a Glance
This chapter covers
Logging in to MPE
Running HP ALLBASE/BRW
Leaving HP ALLBASE/BRW
What Next?
Ch 5. Report Writing with HP ALLBASE/BRW
At a Glance
This chapter covers
Planning Ahead
Creating a Report
Global Report Characteristics
Paper Characteristics
String Sorting Sequence
SQL Transaction Isolation Level
Data Access
What Next?
Ch 6. Defining Data Access
At a Glance
This chapter covers
Joins and Relations
Joining Tables
Defining Relations
Open Joins
Multiple Open Joins
Open Join on HP ALLBASE/SQL Tables
Joining a Source Table To Itself
Joining HP ALLBASE/SQL Tables With Identical Table Names
Merged Tables
Data from Different Sources
Items
Projecting Items
Precision of Numbers
Data Access Methods
Tuning Data Access
Defining Access Sequence
Access by Record Number
Relation Conditions
What Next?
Ch 7. Defining Report Layout
At a Glance
Features of Report Layout
This chapter covers
Using the Screen
Defining Linesets
Detail Linesets
Reports Without Detail Lines
Page and Report Linesets
Page Heading Lineset
Page Footing Lineset
Report Heading Lineset
Report Footing Lineset
Break Linesets
Break Heading Linesets
Break Footing Linesets
Positioning and Editing Items
Printing Array Items
Printing Parameters
Suppressing Repeating Item Values
Editing Items
String Item Edits
Numeric and Integer Item Edits
Real Item Edits
Date Item Edits
Time Item Edits
Justify And Prefill
Item Edits For Exception Cases
Layout Calculations
Column Calculations
Restrictions on Column Calculations
Row Calculations (Layout Calculated Items)
Precision of Numbers
Suppressing Lines and Linesets
Suppress Line Conditions
Suppress Lineset Conditions
Special Cases
What Next?
Ch 8. Sorts, Breaks, and Pagination
At a Glance
Using the Screen
Sorts and Breaks
Customizing Breaks
Pagination
What Next?
Ch 9. Defining Data Selection
At a Glance
This chapter covers
Selecting Data at Specification Time
Selecting Data at Execution Time
Parameters
Selection Conditions
Execution Defaults
Security Dependent on Data Value
What Next?
Ch 10. Saving and Compiling a Report
At a Glance
This chapter contains
Saving a Report
Compiling a Report
What Next?
Ch 11. Requesting Reports
At a Glance
This chapter covers
Requesting Reports Interactively
Requesting Reports Using BRWSTART
Requesting Reports with BRWEXEC
Using Job Files
Amending the Standard Job File
Which Standard Job File?
Using ReportJob Files
Parameters in ReportJob Files
Report JobFile Header
User-Defined Parameters
Standard Parameters
Default Job Schedule
Print FileCharacteristics
Comments
Report Job File Body
Logon Command
Parameters
$Printfile
$Parms
What Next?
Ch 12. Multi-Pass Reporting and Output Files
At a Glance
This chapter covers:
Multi-pass Reporting
Output Files
Types of Output Files
Defining an Intermediate Report File
Using IntermediateReport Files
Other Information About Intermediate Report Files
Dictionary OutputFiles
Creation of DictionaryOutput Files
Quoted BASIC (QB) andData Interchange Format (DIF) Files
Creating QBand DIF Files
Quoted BASIC Format
File Layout
Data Interchange Format
File Layout
DIF File Layout Example
Using Output Files
Database ExtractFiles
Bundling Reports
Integrating Reportswith Batch Processing
What Next?
Ch 13. HP BRW-Desk/XL
Ch 13. HP BRW-Desk/XL (cont.)
At a Glance
This chapter covers:
Requirements
Identify Senders
How It Works
Define HPDesk Delivery for the Report
Request the Report
Delivery Audit Report
Examples
Security
Security When You Switch Destinations
Security When You Print Reports
Error Handling
Address Errors
Ch 14. The HP ALLBASE/SQL Interface
At a Glance
This chapter covers:
Using HP ALLBASE/SQL
HP ALLBASE/SQL Characteristics
System Catalog
Table Owner
Access Authorization
Transaction Handling and Locking
Table Lock Mode
Transaction Isolation Levels
HP ALLBASE/SQL and HP ALLBASE/BRW
Modifying the DBEnvironment
Performance Considerations
Names and Datatypes
Joining
SATISFIES Operator
Combining HP ALLBASE/SQL data with IMAGE/3000 or KSAM
Native Language Support
Ch 15. Calculations
At a Glance
Aggregate/Array Operations
Arguments
Arrays and Array Items
Calculation Language
Column Calculation Results
Conditions
Conditions/Boolean Operations
Constants as Arguments
Conversion Functions
Dates
Exception Handling
Expressions
Formulas
Functions
IF THEN ELSE Operations
Items
List Operations
Literals and System Values
Naming Conventions
Numbers
Operators/ Operations
Parameters
Printing Values As Bar Graphs
Reserved Words
Standard Deviation
Standard Functions
Standard Items
Strings
Syntax Diagrams
Syntax Rules For Calculations
Time
Types
Ch 16. Using HP ALLBASE/BRW Screens
At a Glance
Compile Report Screen
Date Item Edits Screens
Define Breaks Screen
Define HPDesk Configuration Screen
Define Lines Screen
Define Relation Screen
Define Report Screen
Define Table Screen
Layout Calc Item Screen
Layout Calc Item Formula Screen
Layout Function Screen
Layout Function Formula Screen
Mail Values Screen
Numeric/Integer Item Edits Screen
Online Review Screen
Output File Screen
Parameter Screen
Project Items Screen
Real Item Edits Screen
Relation Condition Screen
Request Report Screen
Review Layout Screen
Select Report Screen
String Item Edits Screen
Suppress Line Screen
Suppress Lineset Screen
Table Calc Item Screen
Table Calc Item Formula Screen
Table Function Screen
Table Function Formula Screen
Time Item Edits Screen
Tune Access Screen
Use Items Screen
Ch 17. Configuration and Security
At a Glance
This chapter covers
Configuration Levels
System-Level Configuration
Account and Group-Level Configuration
Running BRWSETUP
Global Values Screen
Field Descriptions
Data Language
(Number )
Rounding .5 to 1 or 0
Date Format
Execution Values Screen
Field Descriptions
Default Print Device
Use new Spoolfile after...pages
If printed on Disc, max...lines
Output/Work File Size
Database Open Mode
Maximum Number of Lock Retries
Wait Interval between Lock Retries
Transaction Isolation Level for Locking
Transaction Priority in case of Deadlock
Warning Message Buffer for maximal \messages
Print Execution Statistics
Disable Automatic Recompile
Exception Output Values Screen
Field Descriptions
Char
Hex
or set to Value
Specification Values Screen
Field Descriptions
Report Width
Page Length
String Sort\Sequence
Column Spacing
Sample Fill\Characters
Function Keys
Default Item Edits Screens
Default String Edits Screen
Default Numeric Item Edits Screen
Default Real Item Edits Screen
Default Integer Item Edits screen
Default Date Item Edits screen
Default Time Item Edits Screen
Global Functions
Global Functions Screen
Field Descriptions
Function
Result Type
Arguments
Type
Soft Keys
Add Function
Delete Function
Define Formula
Prev/Next Function
Global Function Formula Screen
Mail Values Screen
Field Descriptions
Sender Name/Address
Password
Maximum Number of Deliverable Pages
Maximum Number of Records for Files
Print Delivery Audit Trail
Security Features
Password Encryption
BRWLIST
$TELLREPORT
Dictionary Passwords
Automatic Password Retrieval BRWPASSEXIT
Why use BRWPASSEXIT?
Creating BRWPASSEXIT
BRWPASSEXIT Examples
PASCAL Example
COBOL Example
Ch 18. Data Dictionaries
At a Glance
This chapter covers
HP ALLBASE/BRW Dictionary File (BRWDIC)
Removing the Data Dictionary
Rules for creating and modifying BRWDIC
Using BRWDLIST
Using Multiple Data Dictionaries or a Central Dictionary
Which BRWDIC file does HP ALLBASE/BRW use?
What about a Central Dictionary?
Multiple BRWDIC in the same account
HP Dictionary/3000
Setting up HP Dictionary/3000
Terminology
Elements/Items
Datasets
Databases
MPE Files
KSAM Files
Locations
Preparing a BRWDIC Dictionary File With HP Dictionary/3000
Warning Messages
HP System Dictionary
Extensions to HP System Dictionary
UNIQUE
ELEMENT-SUBTYPE attributes
Terminology
Items/Elements
Element Alias Names
Finding an Element's Attributes
ELEMENT-SUBTYPE attributes
Keys
Datasets
Databases
MPE Files
KSAM Files
Using Byte-offsets
Defining Overlays
Preparing a BRWDIC Dictionary File With HP System Dictionary
Description of choices
Warning Messages
HP Application Dictionary
Using HP Application Dictionary With HP ALLBASE/BRW
Terminology
Single Fields and Group Items
Formats
Array Fields (ARRAYDEF)
Building theARRAYDEF File
Synonyms (SYNDEF)
Building the SYNDEF File
Preparing a BRWDIC Dictionary File With HP Application Dictionary
HP Information Access Data Dictionary
Terminology
Supported Features
Defining Date and Time Using an ACCSDEF File
Syntax for ACCSDEF file
Comments
Sub-item Part
Edit Part
ACCSDEF Date and Time-Item Tables
Preparing a BRWDIC with HP Information Access Data Dictionary
User-Generated Dictionary Source File
Terminology
Creating the Dictionary Source-File
Statements
Syntax Rules
The TITLE or SCHEMA Statement
The FILEStatement
The ELEMENT Statement
RECORD Statement
ITEM Statement
The REDEFINED Statement
The BUILD Statement
Creating A BRWDIC Dictionary File With the User-Generated Dictionary
Changes in Dictionary Files
Modifying BRWDIC
Automatically Recompiled Reports
Automatic Upgrade of the Specification File
Manual Upgrades to Specification Files
Ch 19. Performance Considerations
At a Glance
This chapter covers
Influencing Performance
What Your System Can Do For Performance
What HP ALLBASE/BRW Can Do For Performance
Access Blocks
Compiler Optimizations
Data Access Methods
Data Access Methods For Joins
Data Access Methods For Merges
Keyed Access For Joins
Serial Access For Joins
Access Sequence For Joins
Access Sequence For HP ALLBASE/SQL Tables
Using the Compile Listing
Execution Statistics
Effective Calculations
How Calculated Items Work
How Functions Work
Rules For Effective Calculations
Table Calculated Items or Layout Calculated Items?
Optimizing TableCalculated Items
Optimizing Selections
Optimizing Layout Calculated Items
Ch 20. Intrinsics
At a Glance
This chapter covers
Refreshing the Terminal
Character Mode
Block Mode
Request Report Intrinsics
BRWINITREQUEST
REQUEST_COMAREA
BRWSTARTREQUEST
REQUEST_COMAREA
PARM_DEFAULTS
BRWSTOPREQUEST
REQUEST_COMAREA
Execution Intrinsics
BRWOPEN
BRW_COMAREA
FILENAME
BRWINFO
BRW_COMAREA
BRW_PARAMETERS
BRWSTREAM
BRWEXEC
BRWCLOSE
Error Handling
Ch 21. HP ALLBASE/BRW and HP BRW/V
At a Glance
This chapter covers
Comparing HP ALLBASE/BRW and HP BRW/V
File names in HP ALLBASE/BRW and HP BRW/V
File codes in HP ALLBASE/BRW and HP BRW/V
Modes
Transferring Reports between MPE V and MPE XL
MPE V to MPE XL (to run in Native Mode)
MPE V to MPE XL (to run in Compatibility Mode)
MPE XL to MPE V
Running HP BRW/V Reports on MPE XL
Error Messages
Transfer Reference
Data
Configuration Files
HP ALLBASE/BRW Intrinsics
Report Job Files
Standard Job Files
Ch 22. Converting Reports
At a Glance
Required Software
Location of BRWDIC, REPCOMP, and INFCNV
Using BRWCONV
Define Files, Items, and Elements
Verify Item Names
Define Date and Time Items
Create BRWDIC
Create a Group for Sets of HP ALLBASE/BRW Reports
Run BRWCONV
Verification of Report/V Reports
File Lockwords/Passwords
Error Messages (RWARN)
Inform/V Reports
On-line Help Facility
Incompatible Features
Translation Rules
Example Report Conversion
Define Data
Verify Names
Define Date and Time Items
Create BRWDIC
Convert the Report
GLOSSARY
INDEX
Index