ubTableChange is a powerful utility designed to propagate structural modifications to a specific UNIBASE table across all customer databases. This tool automates the potentially complex process by systematically extracting the table definition using ubtabdump, updating the data dictionary with ubdict, and then applying the new structure by reloading the data with ubtabload in each customer directory. Furthermore, ubTableChange can also define and create the table structure initially in all customer environments using ubdict followed by createfiles when you invoke it with the --create option. This article details the usage and functionality of ubTableChange, highlighting its role in maintaining consistent table structures across a multi-customer UNIBASE deployment.

NAME

ubTableChange – change stored table structure for all customers

SYNOPSIS

ubTableChange {–create|<table>}

DESCRIPTION

ubTableChange will change the stored table structure of a table for all customers.

It works by first doing a ubtabdump of the table in all customer directories followed by a ubdict and then a ubtabload of the table in all customer directories.

If given the argument –create it will do a ubdict followed by createfiles in all customer directories.