HP 3000 Manuals HP 3000 Manuals
At a Glance
HP ALLBASE/BRW let you access all non-relational data (IMAGE datasets,
KSAM files and MPE files) as if the data were stored in a relational
database. HP ALLBASE/SQL uses relational data that also can be accessed
by HP ALLBASE/BRW. It is possible to retrieve and combine data from
IMAGE, HP ALLBASE/SQL, KSAM and MPE within the same report. It is also
possible to retrieve and combine data from multiple SQL DBEnvironments.
HP ALLBASE/BRW has features that are not normally available through HP
ALLBASE/SQL. When you access HP ALLBASE/SQL data through HP ALLBASE/BRW,
however, these features can be used.
The following HP ALLBASE/BRW features increase the functionality of HP
ALLBASE/SQL:
* You can access multiple DBEnvironments to retrieve and combine
data in the same report.
* Joins, open joins and merges can use HP ALLBASE/SQL tables and
combinations of HP ALLBASE/SQL tables with other data sources.
* You can pass user-defined parameters to make data selections.
NOTE A dictionary file is not required for an HP ALLBASE/SQL
DBEnvironment.
This chapter covers:
* creating, compiling and executing HP ALLBASE/SQL reports
* characteristics
* HP ALLBASE/SQL and HP ALLBASE/BRW
* joining
* native language support