Xe / ERP8
In releases XE and ERP 8, the maximum number of columns a table can have is 254. This is a predefined constant value.
8.9 and newer
Starting with the EnterpriseOne 8.9 release and later, Table Design Aid (TDA) was enhanced to call the JDB_GetTableProperties API, which retrieves table definition related constants from the table F9300 – Database Property Values. This API can be called either for a particular database or for E1 supported values, but when used by TDA, it always returns the ONEWORLD database type corresponding parameters values. Therefore, it is irrelevant what database type the system actually has; the tables created via TDA will respect the ONEWORLD constraints, not the specific database ones.
As an example, for EnterpriseOne releases 8.12 and 9.0, the maximum number of columns in a table (property MaxNumberColumnsInTable) is 500.
Beside the Maximum Number Of Columns In Table, the following table properties can also be found in the F9300:
- Maximum Column Name Length
- Maximum Index Name Length
- Maximum Number Of Blobs In Table
- Maximum Number Of Columns In Index
- Maximum Number Of Indexes In Table
- Maximum Table Name Length
- Maximum Total Index Length
- Maximum Total Row Length
- Minimum Column Name Length
- Minimum Index Name Length
- Minimum Number Of Blobs In Table
- Minimum Number Of Columns In Index
- Minimum Number Of Columns In Table
- Minimum Number Of Indexes In Table
- Minimum Table Name Length
- Minimum Total Index Length
- Minimum Total Row Length
Changing the defined values in the F9300 – Database Property Values table is not recommended or supported.
Source – MOS: ID 1077277.1