Table of Contents:
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.
...