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