| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Table management
| Note |
|---|
Both create and alter table procedures should only be called from SNP GlueTM. Drop table procedure may be called on tables not created by SNP GlueTM. |
...
| Code Block | ||
|---|---|---|
| ||
call core.drop_glue_table(<Source>, <Table>); |
Merge
Start the merge on a specific source using its settings.
...
| Code Block | ||
|---|---|---|
| ||
call core.suspend_control(<Source>); |
Settings
Get settings of specified scope → 'APP' for application settings, 'DEFAULT' for default (template) source settings, <Source> for specific source settings.
...
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Do not set 'control_status' manually! |
control_status → Flag if the 'START_CONTROL' task exists, is running, or is suspended. Not present in 'DEFAULT’ settings.
...
app_name → Name of the application.
Source management
Register a new source. It creates a new schema if it does not already exists and set default source settings.
...
| Code Block | ||
|---|---|---|
| ||
call core.remove_source(<Source>); |
Cleanup
Remove control drops 'START_CONTROL' task, thus preventing from starting merges on newly replicated tables.
...