DATASOURCEDISTRIBUTIONKEYCOLUMNS
The system table SYSINFO.DATASOURCEDISTRIBUTIONKEYCOLUMNS describes the distribution keys in the data source.
This information is only relevant for SAP MaxDB bridge functionality.
|
DATASOURCENAME |
CHAR(32) |
Name of the data source |
|
SCHEMANAME |
CHAR(32) |
Name of the schema |
|
TABLENAME |
CHAR(32) |
Name of the table |
|
DISTRIBUTIONKEYNAME |
CHAR(32) |
Name of the distribution key in the data source |
|
UNIQUE |
CHAR(3) |
YES for an unique distribution key, otherwise NO |
|
COLUMNNAME |
CHAR(32) |
Name of the column |
|
COLUMNNUMBER |
FIXED(4) |
Column number in distribution key |