Many Enscribe users need to replicate their Enscribe data into external systems and environments, for example, to feed a data warehouse. This process is usually accomplished by converting the Enscribe information into standard SQL data structures and schemas.
The HPE Shadowbase Data Definition Language Utility (SBDDLUTL) is a command line interface (CLI) database schema conversion tool which converts an Enscribe record definition (which is naturally hierarchical) into a SQL schema definition (which is naturally a ‘flattened’ structure). The SBDDLUTL feature is available as part of the HPE Shadowbase Essentials product bundle.
SBDDLUTL allows the user to view Enscribe DDL schemas, and includes a variety of useful formatting commands to read, store, and manipulate Enscribe DDL file definitions.
SBDDLUTL automatically renames fields when flattening to ensure that there are no target column name collisions and the Enscribe record is properly converted to an SQL table.
If necessary, the utility can change the default file write access for an input/output operation by adding a modifying character at the end of the specified file name.
The user has full control over the flattened Enscribe DDL definition field names and target table column-naming conventions.
SBDDLUTL can redirect a command’s output to an edit file with the default file write access.
Please refer to the SBDDLUTL manual for additional details.