Root (__SUPER_CHANNEL__ table)

The __SUPER_CHANNEL__ table is the root registry table. It tells SuperCHANNEL which tables are registry tables.

This table is required in order to use registry tables in your source data. You must have a row in the root table for every registry table you want to use.

Table Definition

Column Name

Data Type

Size

Primary Key

Specifies...

reg_key

string

128

YES

What type of registry table this row relates to. It can have one of the following values (must match exactly):

BINS
CLASSIFICATIONS
CLEANSING_RULES
COLUMN_LABEL
COUNT_DEFAULT
DATABASE_LABEL
FACTS
GROUP
MEASURES
MULTIRESPONSES
TABLE_LABEL

reg_value

string

128

The name of a table in the source data to use as a registry table.

Example

Change the Name of the Root Registry Table

By default, SuperCHANNEL expects the root table to be called __SUPER_CHANNEL__, but you can change this.

You will need to change the name of the root registry table if you want to implement multiple registry table sets in a source database.

To change the name of the root registry table, you need to modify a value in SuperCHANNEL's config.txt configuration file. In a default installation, this file is located in C:\ProgramData\STR\SuperCHANNEL\bin

Open config.txt in a text editor.

Make a backup copy of this file before making any changes.

Locate the following section of the file:

NONE

# Sets the name of the SuperCHANNEL root registry table
# Default name is __SUPER_CHANNEL__
# str.root.table=__SUPER_CHANNEL__

Remove the # to uncomment the final line and change the value to your preferred table name:

CODE

# Sets the name of the SuperCHANNEL root registry table
# Default name is __SUPER_CHANNEL__
str.root.table=R_Root