Register as Link with Refresh Restrictions
Register as link with refresh refreshes all the information about a table or view in the Ingres Star catalogs with information from the local database.
Views built on top of the table or view are unaffected. The table or view retains the same table_id or view_id.
The register with refresh statement is not allowed in the following circumstances (an error message is generated):
• If the local database table has fewer columns than when initially registered
• If the local database table columns have different data types from when initially registered
• If column name mapping was used when the table was initially registered and the local database table now has a different number of columns from when it was initially registered
• If either the distributed database or the local database (but not both) supports mixed-case delimited identifiers, Ingres Star internally maps column names. In this case, register with refresh is not allowed if the local database table now has a different number of columns from when it was initially registered
Register with refresh can be used on objects registered by the register statement or implicitly registered by Ingres Star. A table or view refreshed in this way retains the same table_subtype value in the iitables catalog, that is, it remains registered native if originally registered native. (A native object means the object was created through Ingres Star rather than merely registered through Ingres Star.)