Creating a multi-tenant sequence and loading a data definition file with sequences

As has been the case in previous releases of OpenEdge, you create a sequence by using the Data Dictionary tool. With this release of OpenEdge, you can choose to create the sequence as multi-tenant. (If you do not choose the multi-tenant option, you create a shared sequence.)

Although you cannot create sequences from the Database Administration Console, you can use the tool to view and edit them. As you have done in previous releases, you begin by using the Data Administration tool (Start > Programs (or All Programs) > Progress > OpenEdge > Data Administration) to create a data definition file that contains sequences. Using the multi-tenancy configuration tool, you can then load the data definition file that contains the sequences into the database and edit the sequence current values.

Due to the importance of establishing the required user credentials to work with multi-tenancy, many tasks that you perform related to multi-tenancy in the Data Dictionary tool or the Data Administration tool require the user ID and password of a super-tenant user.