SQL Restrictions

For security and compliance purposes, SQL capabilities in ConfigManager are limited to support product specific configuration only. Any attempt to apply SQL changes that include restricted references will return an error.

Affected SQL will need to be rewritten to remove any unsupported keywords or objects for changes to be successfully applied or saved.

What is supported

The following Variable Statements:

• DECLARE (including tables)
• SET

The following statements:

• IF
• WHILE
• BEGIN and END
• TRY and CATCH
• INSERT
• DELETE

Attempting to apply SQL statements not in the above list will likely be blocked.

Restricted object references

Any tables beginning with the following:

• INTRAMAPS_
• MAPMANAGER_
• TILEENGINE_

Queries referencing the following tables are also unsupported:

• TBGEO_BASEMAP_CFG
• TBGEO_SELECTION
• TBGEO_SPATIAL_CATLG
• TBGEO_SPATIAL_CFG
• TBGEO_SPATIAL_CFG_SNP

Additionally, objects under the following system schema are also unsupported:

• SYS
• INFORMATION_SCHEMA