HP 3000 Manuals HP 3000 Manuals
Chapter 5 TECHNICAL ARTICLES
HP Business Report Writer/XL (HP BRW/XL)
by Peter Lucey--Commercial Systems Boeblingen
This article gives you the steps for transferring reports, as well as
detailed information concerning reports, filenames, filecodes, the BRW/XL
tutorial and BRW/XL intrinsics.
TRANSFERRING REPORTS BETWEEN BRW/V AND BRW/XL
These instructions summarize the steps needed to transfer reports to and
from MPE XL and MPE V systems. Each method is fully described in
Appendix F of the HP BRW/XL Reference Manual (P/N 35360-60002).
MPE V to MPE XL in Native Mode
* Store the data from the MPE V system and restore it on the MPE XL
system.
* Store the data dictionary from the MPE V system and restore it on the
MPE XL system.
Run the appropriate BRWDIC generating program (BRWD3000, BRWAPPD, or
BRWSD) to create a BRWDIC from the data dictionary.
* Store the report specification files from the MPE V system and
restore them on the MPE XL system.
* Store any report job files from the MPE V system and restore them on
the MPE XL system.
Edit the report job file so that the program filenames are those of
HP BRW/XL.
* Store any amended configuration files and standard job files from the
MPE V system and restore them on the MPE XL system.
Edit the amended standard job files so that any program filenames are
those of HP BRW/XL.
Rename the standard job file from RJOB to BRWJOB.
Rename the configuration files from RCONF to BRWCONF.
* Using the programs BRWXL.PUB.SYS or BRWCOMP.PUB.SYS, compile the
report specification files to create HP BRW/XL report execution
files.
The reports are now ready to run in MPE XL Native Mode.
MPE V to MPE XL in Compatibility Mode
* Store the data from the MPE V system and restore it on the MPE XL
system.
* Store the report execution files from the MPE V system and restore
them on the MPE XL system.
* Store any report job files from the MPE V system and restore them on
the MPE XL system.
* Store any amended configuration files and standard job files from the
MPE V system and restore them on the MPE XL system.
The reports are now ready to run in MPE XL Compatibility Mode.
MPE XL to MPE V
* Store the data from the MPE XL system and restore it on the MPE V
system.
* Store any report job files from the MPE XL system and restore them on
the MPE V system.
Edit the report job file so that the program filenames are those of
HP BRW/V.
* Store any amended configuration files and standard job files from the
MPE XL system and restore them on the MPE V system.
Edit the amended standard job files so that any program filenames are
those of HP BRW/V.
Rename the standard job files from BRWJOB to RJOB.
Rename the configuration files from BRWCONF to RCONF.
* Run the appropriate RDIC generating program (RDIC3000, RAPPDIC, or
RSYDIC) to create an RDIC file from the data dictionary.
* Using BRW.PUB.SYS or RCOMP.PUB.SYS, compile the report specification
files to create HP BRW/V report execution files.
* Store the HP BRW/V report execution files from the MPE XL system and
restore them on the MPE V system.
The reports are now ready to run on the MPE V system.
FILENAMES IN HP BRW/XL AND HP BRW/V
To allow the operation of both HP BRW/V and HP BRW/XL on MPE XL systems,
the names of all Business Report Writer program and data files for HP
BRW/V are different from the names of the files for HP BRW/XL, (except
for the program REMPTY.PUB.SYS). Report specification files, dictionary
output files, intermediate report files, and print files are
interchangeable between HP BRW/V and HP BRW/XL. The following list shows
the equivalent files and their function; the files are supplied with HP
BRW/XL and are held in PUB.SYS.
HP BRW/V | HP BRW/XL | Description
Compatibility | Native Mode |
Mode | |
BRW | BRWXL | Report Specification Program
RAPPDIC | BRWAPPD | Application Dictionary Interface
| | Program
RCOMP | BRWCOMP | Report Compile Program
RCONVERT | BRWCONV | REPORT/V and INFORM/V Conversion
| | Program
RDIC3000 | BRWD3000 | Dictionary/V Interface Program
RDICLIST | BRWDLIST | RDIC and BRWDIC List Program
RLIST | BRWLIST | Report Specification List Program
RSDEXT | BRWSDEXT | Command File to add SYSDIC
| | Extensions
RSYSDIC | BRWSD | System Dictionary Interface Program
RCONF000 | BRWC000 | Standard Configuration File
REMPTY | REMPTY | Program to Empty Intermediate
| | Report Files
REXEC | BRWEXEC | Report Execution Program
RJOB000 | BRWJ000 | Standard Job File
RSETUP | BRWSETUP | BRW Configuration Program
RSORT | - | no longer needed in MPE XL
RSTART | BRWSTART | Report Request Program
RSTREAM | BRWSTRM | (internal program only)
RLIT000 | BRWL000 | BRW Literals File
RDLIT000 | BRWDL000 | Dictionary Interface Literals File
RFORM000 | BRWF000 | BRW Forms file
RMSG000 | BRWM000 | BRW Message file
The above files are supplied with HP BRW/XL and reside in PUB.SYS.
However, you can define dictionary extract files, customized
configuration files and customized standard job files. These files can
be held in any group on your system. The following list shows such files
and their function.
HP BRW/V | HP BRW/XL | Description
Compatibility | Native Mode |
Mode | |
RDIC | BRWDIC | Dictionary Extract File
RCONF | BRWCONF | Customized Configuration File
RJOB | BRWJOB | Customized Standard Job File
FILECODES
The filecodes and file mnemonics for HP BRW/XL files are the same as
those for HP BRW/V files, except for:
1. native mode execution files, which have a filecode of 1438 and a
file mnemonic of REXNM, and,
2. the BRWDIC file, which has a filecode of 1437 and a file mnemonic
of RDICN.
HP BRW/XL TUTORIAL
A tutorial for HP BRW/XL is now available. This tutorial will be
supplied in book form, however, it uses files which are shipped with HP
BRW/XL version A.00.00. The tutorial files comprise a database, BRWDIC
file, and example solutions. The files are as listed below; they are all
held in account ITF3000.
Database Files
TOYDB.PUB.ITF3000: Root file
TOYDB01.PUB.ITF3000: Dataset
TOYDB02.PUB.ITF3000: Dataset
TOYDB03.PUB.ITF3000: Dataset
TOYDB04.PUB.ITF3000: Dataset
TOYDB05.PUB.ITF3000: Dataset
TOYDB06.PUB.ITF3000: Dataset
BRWDIC File
BRWDIC.PUB.ITF3000
Note that the BRWDIC file will describe the TOYDB. You do NOT require a
data dictionary to run the tutorial.
Example Solutions
Solution specification files:
SOLUTN1.BRWSPEC.ITF3000: Solution to first lesson
SOLUTN2.BRWSPEC.ITF3000: Solution to second lesson
SOLUTN3.BRWSPEC.ITF3000: Solution to third lesson
Solution execution files (in native mode):
SOLUTN1.BRWEXEC.ITF3000: Solution to first lesson
SOLUTN2.BRWEXEC.ITF3000: Solution to second lesson
SOL3SMN.BRWEXEC.ITF3000: Solution to third lesson
SOL3DIR.BRWEXEC.ITF3000: Solution to third lesson
Solution printfiles (report printed to disc):
SOLUTN1.BRWONLNE.ITF3000: Solution to first lesson
SOLUTN2.BRWONLNE.ITF3000: Solution to second lesson
SOL3SMN1.BRWONLNE.ITF3000: Solution to third lesson
SOL3SMN2.BRWONLNE.ITF3000: Solution to third lesson
SOL3SMN3.BRWONLNE.ITF3000: Solution to third lesson
SOL3DIR1.BRWONLNE.ITF3000: Solution to third lesson
SOL3DIR2.BRWONLNE.ITF3000: Solution to third lesson
HP BRW/XL INTRINSICS
HP BRW/XL intrinsics have the same characteristics as HP BRW/V intrinsics
except that the BRW_COMAREA parameter (used by the execution intrinsics
BRWOPEN, BRWINFO, BRWSTREAM, BRWEXEC, and BRWCLOSE) is 332 bytes. (The
BRW_COMAREA parameter used with HP BRW/V intrinsics is 300 bytes). See
the HP BRW/XL Reference Manual (P/N 35360-60002), appendix D, for a full
description of the HP BRW/XL intrinsics.