Modifying SQL Dates

Note: This task applies only to an Enterprise Database Server database that is mapped to SQL.

Perform the following steps to modify an SQL date:

  1. From the tree view, expand the server containing the database you want to modify.

  2. Expand the database and the data set that contains the date you want to modify.

  3. Click the Dates node.

  4. Select the date you want to modify.

    The data definition appears in the properties view.

  5. Make the necessary changes to the date definition, and click Store.

    The date is updated.

    You can later upload your modifications to the database on the ClearPath MCP server. For more information, refer to Loading a Schema.