You can enable a database for table partitioning from the Database Administration Console, by using command line utilities, and programmatically with ABL.

Database Administration Console

To enable a database for table partitioning with Database Administration Console:

  1. Select Database Administration > Database Connections. The list of database connections appears.
  2. Highlight the database connection of your choice from the list of database connections, and click View. The database home page appears.
  3. Verify the Table Partitioning status in the Database Features panel.
    Note: You can click the Sort arrow to display the features in ascending or descending order. If the status displays a check mark in a green circle and the word Enable does not appear in the Action column then, the database is already enabled for table partitioning.
  4. Click Enable. The Enable Table Partitioning page appears.
  5. Click Enable table partitioning. A message confirms that the database is enabled for table partitioning.
  6. Click OK.
    Note: You can also use the Database Features panel to know the status of the Read-only Partitions.

Command line utilities

To enable an OpenEdge database for table partitioning use the PROUTIL command with the ENABLETABLEPARTITIONING qualifier, which can be run online or offline against the OpenEdge database.
  1. Enter $ proutil dbname -C enabletablepartitioning.
  2. Verify the OpenEdge database is enabled for table partitioning.

    $ proutil dbname -C describe

Programmatically with ABL

To enable an OpenEdge database for table partitioning, use the OS-COMMAND statement.
DEFINE VARIABLE cExecutableCommand AS CHARACTER NO-UNDO.
ASSIGN
cExecutableCommand = "proutil dbname -C enabletablepartitioning"
OS-COMMAND SILENT VALUE(cExecutableCommand).
To verify whether an OpenEdge database is enabled for table partitioning or not use the _Database-Feature VST:
FIND _DataBase-Feature NO-LOCK WHERE _DBFeature-ID = 21 NO-ERROR.
DISPLAY
_DBFeature-ID FORMAT ">9" LABEL "ID"
_DBFeature_Name FORMAT "X(20)" LABEL "NAME"
_DBFeature_Active FORMAT "9" LABEL "ACTIVE"
_DBFeature_Enabled FORMAT "9" LABEL "ENABLED"
WITH FRAME ft DOWN.