HPE SBMAP gives the user the capability of defining and applying data mappings in replication without the need to write C, C++, or COBOL code to implement custom Shadowbase User Exits. With the SBMAP scripting syntax, the user can intuitively define data transformations and filters. The syntax and statements used in SBMAP are based on existing SQL/MP features.
Before SBMAP, all User Exits had to be programmed by hand. Now, use SBMAP to automatically transform data mappings from one database to another.
SBMAP flexibly allows the user to choose from multiple commands and operations to ensure that data is transformed and delivered in just the right format.
An “external table” is a table that is not a part of the Database Specification (DBS) where the current mapping event belongs. The external table is like a “third-party” table: one that is neither the source nor the target in the replication architecture.
This capability enables event- and streaming-types of operations to occur based on values in tables on other platforms, environments, and systems.