COVID-19 Update — We are available to assist you during these trying times. Please contact us for assistance.

HPE Shadowbase Data Definition Language Utility (SBDDLUTL)

Systematically Transform Enscribe Records into Their SQL Equivalent

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.

Essentials Solution Brief: HPE Shadowbase Data Definition Language (SBDDLUTL)

Key SBDDLUTL Features

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 can:

For the commands with extensive output, SBDDLUTL can redirect output to an edit file with the default file write access. 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. To specify unique data type conversions, the user can use the command: “SET TYPE <type> for <fully qualified field name>,” which allows the user to set the data type for the specific field. Additionally, “REPLACE <source type> with <target type>” allows broad, global datatype changes with some intelligent wildcarding. Please refer to the SBDDLUTL manual for additional details.