Progress
DataServer
for ODBC Guide
Updating a Schema Holder
The Update/Add Table Definitions utility allows you to update a schema holder to reflect changes that you make to the data definitions in your ODBC data source.
NOTE: Using this utility to update the schema holder is the only way to make sure that your applications can access modifications or additions to an ODBC data source.The Update/Add utility allows you to:
- Add object definitions from the ODBC data source to a schema holder. Use this option if you add a new table or view to the data-source data definitions and want the schema holder to reflect the change.
- Update existing object definitions in a schema holder to reflect a change in the supporting data-source object definitions.
To update a schema holder, follow these steps:
- Access the Progress Data Administration tool, if you are not already there, and select DataServer
ODBC Utilities
Update/Add Table Definitions. The following dialog box appears:
![]()
- Type preselection criteria values into the fields as required. These values preselect the data-source objects that the utility uses to update the schema holder. By default, the wildcard symbol (*) appears; it specifies that the utility uses all of the objects in the data source.
Note that for DB2 data sources, you must type the name of the DB2 database in the Object Owner field. If the DB2 database name is different from the authorization ID for the tables being selected, type the authorization ID in the Object Owner field.
NOTE: For each of the three entry fields in the dialog box, if you enter a value that consists only of wild cards, you might degrade the performance of the database when you perform a schema pull. (It will include system catalog files that are not typically included in user databases.)- Choose OK. A dialog box lists the objects and table information that you have preselected, for example:
![]()
- Select the objects that you want to update, then choose OK. When the update completes, Progress returns to the Data Administration main window.
When the update completes, Progress reminds you to check the
ds_upd.e
file. This file contains information about the tables that did not support record IDs as well as other warnings.When you update a definition, Progress overwrites the old definition with the new one based on the current data-source object. It also preserves the Progress-specific table information. As a result, if you want to add a new column to a table in your ODBC data source and then update the definition, you do not have to re-enter all of the Progress-specific information for the previously existing columns (fields) in the definition.
NOTE: When you update a table in the schema holder with the Update/Add Table Definitions utility, the information for the user-defined ROWID is lost. You must reselect an index to support the ROWID.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |