HP 3000 Manuals HP 3000 Manuals
Limits on HP ALLBASE/BRW
Item Types
HP ALLBASE/BRW supports the following item types:
Strings Strings with up to 255 characters. Items greater
than 255 characters are truncated.
Numeric Packed decimals, zoned decimals, and display
numerics in the range +/-9,999,999,999,999.999999.
HP ALLBASE/BRW internally converts them into
binary-coded decimal numbers with a total of 19
digits, including 6 decimals. Zoned decimals (type
Z) must be Trailing Overpunch or No Sign. See
Chapter 18.
HP Business BASIC floating-point decimal numbers.
HP ALLBASE/BRW converts these to packed decimal
numbers with a total of 19 digits, including 6
decimals. An overflow is set to the OVERFLOW
exception value, an underflow to zero.
64-bit integers are supported, and are converted to
numeric. An overflow is set to the OVERFLOW
exception value.
Integer 16-bit and 32-bit integers. HP ALLBASE/BRW
internally converts 16-bit integers into 32-bit
integers.
Real 32-bit and 64-bit real numbers of either HP Real or
IEEE Real format. HP ALLBASE/BRW converts 32- bit
real numbers internally to IEEE-type 64-bit real
numbers.
Date Date types, as described in Chapter 18. HP
ALLBASE/BRW internally converts them into strings
of the form YYYYMMDD.
Time Time types, as described in Chapter 18. HP
ALLBASE/BRW internally converts them into
binary-coded decimal numbers with a total of 19
digits including 6 decimals. These numbers contain
time values expressed as seconds.
Database and File Types
HP ALLBASE/BRW supports the following types of databases and files:
IMAGE Database IMAGE and TurboIMAGE databases. The database
passwords supplied with the datasets specified in
HP ALLBASE/BRW reports must allow access to all
items from these datasets, unless Item Level
Security is specified in the Tune Access screen.
HP ALLBASE/SQL HP SQL database. Access authorization is checked
Database by HP ALLBASE/SQL for MPE logon user. Users
developing or executing a report must have CONNECT
authority to the DBEnvironment and SELECT authority
on all tables or views specified.
KSAM Files KSAM files with fixed length records. All types of
KSAM keys (no duplicate; duplicate; random, etc.)
are supported.
MPE Files Standard sequential MPE files with fixed length
records. If a file has the CCTL attribute, the
carriage control character must be reflected in the
format of that file (first byte in the format).
RIO, CIR and MSG files are not supported.
Printers
HP ALLBASE/BRW supports the following printers:
* Spooled printers which support the following carriage control
codes:
%40 single space
%53 no space, return
%61 page eject
%101 set pre-space option
%103 set single space option without automatic
page eject
%202 - %277 skip 2 - 63 lines
%320 no space, no return
You can avoid using carriage-control codes by specifying NOCCTL for
printfiles.
Environment files can be used if the printer supports it.
NOTE Printers connected to terminals (non-spooled printers) are not
supported.
Report Characteristics
HP ALLBASE/BRW reports have the following characteristics:
* up to 300 characters in the report width
* up to 999 lines in the page length
* up to 9 sort levels
* up to 50 parameters and MATCHES statements in formulas (that is,
both numbers together cannot exceed 50)
[REV END]