Data source upgrades and customization

When data sources are upgraded or customized, you need to update global catalog information.

The SQL compiler relies on information that is stored in the global catalog to provide it with the SQL capabilities of the data sources. This information periodically needs to be updated. The SQL capabilities of the data sources might change in new versions of the data sources. When data sources are upgraded or customized, update the global catalog information so that the SQL compiler is using the most current information.

Use SQL DDL statements, such as CREATE FUNCTION MAPPING and ALTER SERVER, to update the catalog.