HP 3000 Manuals HP 3000 Manuals
Running BRWSETUP
To run the configuration program for HP ALLBASE/BRW
1. Log on in the group and account of the configuration file you want
to change.
2. Run the configuration program, as shown here:
RUN BRWSETUP.PUB.SYS
The first configuration screen appears.
![[]](../../pic3k/M011795/FFN2163c50.gif)
3. Modify the configuration for data language, rounding, and data
format. See the details for the Global Values Screen, later in
this chapter.
4. Use the other softkeys on this menu to go to the configuration
screen or screens you want to change.
5. Modify the configuration for each screen as necessary. The
following sections of this chapter describe all the configuration
screens for this program.
To exit the configuration program
1. Choose Exit Program.
The modifications are saved in the configuration file and are active for
the BRWEXEC and BRWXL programs. (They are also active for BRWCOMP if you
use this program to compile your reports.)
Global Values Screen
Use this screen to specify the data language, rounding rule, and input
date format to be used by HP ALLBASE/BRW. This is the first screen you
see when you run BRWSETUP.
![[]](../../pic3k/M011795/FFN2173c50.gif)
To modify global values
1. Type the data language or number, the rounding rule, and the date
format to be used. See the Field Descriptions section for details
on each field.
2. Press Enter
To verify MPE VCompatibility
1. Choose Verify.
The system checks for functions with names greater in length than
16 characters.
Field Descriptions
Data Language
This field is used to specify the data language to be used. Type the
name of the language, or leave the field blank and type the language
number only.
(Number )
The language number. When you press Enter, the system provides the value
for Data Language. This entry allows you to specify sorting according to
the native language rules for the data language. (Sorting is described
on the Specification Values screen in this chapter.)
The data language specified here can be temporarily overwritten for a
session or job by specifying the JCW (job control word) NLDATALANG.
Rounding .5 to 1 or 0
Type X after .5 to 1 to configure HP ALLBASE/BRW so that 0.5 values are
rounded up. Or, enter X after 0 so values are rounded down.
For example, if you have specified the numeric precision -2R for an item,
the values are rounded as shown in these examples:
---------------------------------------------------------------
| |
| Value Round 0.5 up Round 0.5 Comment |
| down |
| |
---------------------------------------------------------------
| |
| 54.865000 54.87 54.86 different result |
| |
| 54.864999 54.86 54.86 same result |
| |
| 54.865001 54.87 54.87 same result |
| |
---------------------------------------------------------------
Precision of numbers is described in Chapter 15, "Calculations".
Date Format
Type the number of the date format to be used for all date inputs.
0 = mdy (month, day, year)
1 = dmy (day, month, year)
2 = ymd (year, month, day)
Execution Values Screen
Use this screen to specify the print file configuration and internal
configuration for BRWEXEC. Get the this screen by choosing Exec Values at
the Global Values screen.
![[]](../../pic3k/M011795/FFN2183c50.gif)
1. Type printfile and other BRWEXEC internal configuration details.
2. Press Enter.
Field Descriptions
Print File fields
Default Print Device
Type the ID for the device on which reports should usually be printed.
(The default is LP.)
Once you type the device ID in this field, it becomes the default for all
reports. However, users can override this default device by specifying
another device on the Define Selection screen or on the Request Report
screen.
Use new Spoolfile after...pages
To avoid spool file overflow, enter the maximum number of pages a spool
file can have. The default is 300. When the limit is reached, BRWEXEC
prints this message:
****************************
* reached spool limit *
* next spool file is #O173 *
****************************
and uses a new spool file. At the beginning of the new spool file
BRWEXEC prints this message:
************************************
* continuation of spool file #O172 *
************************************
You can estimate the number of pages which fit into a spool file with the
following formula:
sectors per spool file extent * 7500
# pages = _____________________________
report width * non-blank lines per page
The spool file size is configured for your system as the number of
sectors per spool file extent. A spool file can have up to 32 extents.
Other limiting factors are the overall number of sectors for spool files
configured for the system and the size of the free space portions on the
discs. For each spool file extent, there must be continuous free space
on the disc.
If printed on Disc, max...lines
Type the maximum number of lines for reports printed to disk. The
default is 80,000.
Output/Work File Size
Type the maximum number of records in temporary execution files which are
used to store the resulting data of the report's table. The default is
100000.
IMAGE Database fields
The fields described here are for IMAGE data only.
Database Open Mode
Type the mode to be used by HP ALLBASE/BRW when opening an IMAGE
database. HP ALLBASE/BRW will use DBOPEN with this mode when opening an
IMAGE database. (However, you can alter the DBOPEN mode for an
individual database by using the Tune Access screen when you define the
tables for a report.) The possible modes are:
Access Mode Capabilities
5 Read, allow concurrent modify
6 Read, allow concurrent modify
7 Read, exclusive
8 Read, allow concurrent read
Consult the IMAGE Data Base Management Reference manual for a full
description of the DBOPEN modes and capabilities.
Maximum Number of Lock Retries
Type the number of times BRWEXEC should retry if a report locks a dataset
or a file with lock mode "retry." BRWEXEC tries the lock until it is
granted or until the configured number of retries is exceeded.
Wait Interval between Lock Retries
Type the number of seconds to elapse between retries. The default is 10
seconds. See Chapter 6, Defining Data Access, for details about data
retrieval methods.
HP ALLBASE/SQL Database fields
The fields described here are for HP ALLBASE/SQL data only.
Transaction Isolation Level for Locking
Use this field to specify the locking strategy.
* RU = no locks while reading the data.
* RC, CS = locks the data currently being accessed by BRW while
reading; locks are not kept until the end of the query.
* RR = locks the data accessed by BRW for the duration of the query.
The default is RC. This field may be overwritten for a single
report on the Define Report screen. Refer to Chapter 14, "The HP
ALLBASE/SQL Interface" for more information on locking.
Transaction Priority in case of Deadlock
Use this field to specify a priority value . If a deadlock occurs, HP
ALLBASE/SQL will roll back a transaction, based on the priority value, to
free the lock, and if HP ALLBASE/BRW is the transaction chosen to roll
back, it aborts, displaying as error message. The SQL default value of
127 is recommended. Values range from 0 to 255 with smaller numbers
having a higher transaction priority. Should your report have precedence
over other DBE applications, adjust the Transaction Priority on the
configuration screen and run the report again. It is not necessary to
recompile the report.
NOTE HP ALLBASE/BRW opens the HP ALLBASE/SQL DBEnvironment with the
CONNECT command. The DBEnvironment parameters Autostart Mode and
User Mode must be set by the DB Administrator to ON and MULTI,
respectively.
Warning Message Buffer for maximal \messages
Type the maximum number of warning messages to be held in the buffer. If
error values occur when a report is executed, the BRWEXEC program prints
appropriate warning messages at the end of a report. During execution,
warning messages are collected in a buffer in memory.
Print Execution Statistics
Optional. Type an X in this field if you want to print the full
execution statistics. If this field is blank, only the Report Summary
(one line) is printed.
Disable Automatic Recompile
Optional. If this is field blank, HP ALLBASE/BRW compares the time-stamp
on the report with the time-stamp on the BRWDIC file and automatically
recompiles the report, when the report is executed, if the BRWDIC file
was created since the report was last run. The use of this feature is
also discussed in Chapter 18, "Preparing a Data Dictionary".
Remember that if the automatic recompile is disabled, which is the
default, HP ALLBASE/BRW cannot catch a BRWDIC change that affects the
report.
NOTE The defaults set in this section are held in the configuration file
and so affect all reports that use the configuration file.
Exception Output Values Screen
Use this screen to define values written to a dictionary output file if
an item results in NO_VALUE or an error value. To get to this screen,
choose Except'n Output on the Global Values screen.
![[]](../../pic3k/M011795/FFN2193c50.gif)
To define exception output values
1. Type an exception value for each of the data types displayed on
the screen.
For each data type, specify a Char or Hex value, or type a set to
Value. The value you specify is used if the item results in
NO_VALUE or an error value. Each data type can have an entry in
only one of the three fields.
2. Press Enter.
Field Descriptions
The left column of the screen lists the data types for HP ALLBASE/BRW.
Type a Char or Hex fill value (as shown below) for each data type, or
type a specific value.
Char
Type the character. The field will be filled with the specified
character.
Hex
Type a Hex digit between 00 and FF. This can be used to fill a field with
non-printable ASCII characters.
or set to Value
Type a value. The table below explains how different data types are
converted in HP ALLBASE/BRW.
Data Type HP ALLBASE/BRW Data Type
---------------------------------------------------------------------------------------
String String in HP ALLBASE/BRW
Display Numeric Fixed Numeric numbers in HP ALLBASE/BRW
Display Numeric Float Real numbers in HP ALLBASE/BRW
Zoned Decimal Numeric numbers in HP ALLBASE/BRW
Packed Decimal Numeric numbers in HP ALLBASE/BRW
16 Bit Integer Integer numbers in HP ALLBASE/BRW
32 Bit Integer Integer numbers in HP ALLBASE/BRW
32 Bit Float Real numbers in HP ALLBASE/BRW
64 Bit Float Real numbers in HP ALLBASE/BRW
Date Date in HP ALLBASE/BRW
Julian Date Date in HP ALLBASE/BRW
Time Time in HP ALLBASE/BRW
Specification Values Screen
Use this screen to define default report specifications. Use the
function keys to specify default item edits. To get to this screen,
choose Spec Values at the Global Values screen.
![[]](../../pic3k/M011795/FFN2203c50.gif)
This screen shows the HP ALLBASE/BRW defaults. Print width, page length,
and sort method can be changed for individual reports on the Define
Report screen for that report. Defaults for item edits can be changed
for individual reports on the Define Lines screen for each type of item
edit in the report.
NOTE If you change the HP ALLBASE/BRW defaults here, they become the
defaults for all new reports.
Changing the defaults for report width, page length, sort method,
or item edits does not affect the settings already stored in the
specification files for existing reports.
To change the default specifications
1. Type the desired value in the appropriate fields.
2. Press Enter.
Field Descriptions
Report Width
Defines the default report width. The default is 132 characters.
Page Length
Defines the default number of lines per page. The default is 60 lines.
String Sort\Sequence
Use this field to specify the default sort-character-set for strings.
The possible entries are:
A Sort according to the ASCII character set.
E Sort according to the EBCDIC character set.
N Sort according to the Native Language Rules for the Data Language
specified on the Global Values screen.
The ASCII sort is faster than the National Language sort, but it sorts
characters according to their ASCII values rather than by their
alphabetic values. The Data Language can be temporarily overwritten for
a session or job by specifying the JCW (job control word) NLDATALANG.
Column Spacing
Defines the number of blank spaces inserted between items when the
specified line position is given as >. The default is 2.
Sample Fill\Characters
Used on Define Lines to reserve space in a report for printing lengths
greater than the defined Edit mask. You can enter a blank. The default
is a point (.).
Function Keys
Use function keys to access the configuration screens for each type of
item edit. The HP ALLBASE/BRW defaults are shown for each of these
screens later in this chapter.
Default Item Edits Screens
There are six Item Edits screens you can configure in BRWSETUP, one for
each item type. These configuration screens correspond closely to the
Item Edit screens in HP ALLBASE/BRW. If you need additional help in
filling out these screens, press f8 to get help, or see the section for
that screen in Chapter 16.
The next subsections show and describe the default configuation for each
item edit screen.
To change these defaults
1. Type the new default in the field and press Enter.
Default String Edits Screen
This is the screen for string item edits. To get this screen, choose
String Edits on the Specification Values screen.
![[]](../../pic3k/M011795/FFN2213c50.gif)
The default for the edit mask is blank. The Shift String field is also
blank, but the default is that character strings are accepted as they
are, that is, no shifting occurs. Justification is to the left. No
character is prefilled.
See the "String Item Edits Screen" section in Chapter 16 for more details
about these fields.
Default Numeric Item Edits Screen
This is the screen for numeric item edits. To get this screen, choose
NumFixed Edits on the Specification Values screen.
![[]](../../pic3k/M011795/FFN2223c50.gif)
The default for the edit mask is that it has 6 decimal places, a point
(period), a 9 in the first place left of the decimal point, and twelve
Z's.
ZZZZZZZZZZZZ9.999999
Keep in mind that the actual item edit-mask for a numeric item is taken,
as far as possible, from the data dictionary definition. The rules for
building a numeric item edit-mask are:
* If the BRWCONF default (the default on this screen) is blank, the
item size and number of decimal place is taken from the
dictionary.
* If the BRWCONF default has a value (like the default value shown),
the number of decimals is taken from the dictionary as long as the
dictionary definition does not exceed the BRWCONF default.
For example, if the default on this screen has six decimal places,
but the dictionary definition of the item has three decimal
places, then the actual item edit-mask will have three decimal
places. But, if the dictionary definition has eight places, the
actual edit-mask will have only 6 places (conforming to the
maximum number shown here).
Default Real Item Edits Screen
This screen shows the defaults for the Real Item Edits (floating-point
real number items). To get this screen, choose NumFloat Edits on the
Specification Values screen.
![[]](../../pic3k/M011795/FFN2233c50.gif)
The default is E 22.16. For a full description of what this format
means, and for a description of the other fields on this screen, see the
"Real Item Edits Screen" section in Chapter 16.
Default Integer Item Edits screen
This screen shows the defaults for the Integer Item Edits. To get to
this screen, choose Integer Edits on the Specification Values screen.
![[]](../../pic3k/M011795/FFN2243c50.gif)
For integer item edits, the default is that the mask has no decimals, a 9
in the rightmost place, and Z's fill the remaining places in the field.
The 9 indicates one digit. The Z's indicate digits without leading or
trailing zeros.
ZZZZZZZZ9
[REV BEG]
NOTE The maximum number of digits for an integer is 10.
[REV END]
For a description of the other fields on this screen, see the "Integer
Item Edits Screen" section in Chapter 16.
Default Date Item Edits screen
This screen shows the defaults for the Date Item Edits. To get to this
screen, choose Date Edits on the Specification Values screen.
![[]](../../pic3k/M011795/FFN2253c50.gif)
The default for date items is 0m/0d/yy. For details on the edit mask
format or for other fields on this screen, see the "Date Item Edits
Screen" section of Chapter 16.
Default Time Item Edits Screen
This screen shows the defaults for the Time Item Edits. To get to this
screen, choose Time Edits on the Specification Values screen.
![[]](../../pic3k/M011795/FFN2263c50.gif)
For time items, the default if HH:0M. For details on the edit mask format
or for other fields on this screen, see the "Time Item Edits Screen"
section of Chapter 16.