Inserting comments to database tables

Use this procedure to insert predefined comments to database tables in order to additional information. An example is the term ItmNo which is English would be commented as Item Number and in Swedish as Artikelnummer.

  1. Right-click your environment and select Database > Comment Database Tables.
    Note:  You can also open the task by clicking Database > Comment Database Tables on the dashboard.
  2. Perform either of these options depending on the status of the environment:

    • If the environment is running, the message "Set M3 BE in maintenance mode" is displayed. Click Next.

    • If the environment is stopped, the environment will be started in maintenance mode.

      Note: The environment is in maintenance mode until the application is stopped, started, or set online.
  3. Specify the user ID and password of the database administrator.
  4. Click Next. The Language window is displayed.
  5. Specify this information:
    Component

    Select the component to be used to create comments for the database.

    Language

    Select the language to be used to create comments for the database.

    Table Filter

    Specify the table name. If this field is left blank, all indexes are recreated for the selected component. A comma separated list of tables can also be specified.

  6. Click Next. The Summary window is displayed.
  7. Verify the values provided and click Finish.
  8. When the task is finished, a window is displayed. Click OK or click View log. You can also go to the Logs tab to view the log file.