|2352 day(s) ago||#133|
Date: 2013-12-16 23:52:18
Maximum Number of Columns in a Table in JDEIt is defined differently in different JDE Releases -
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 higher Releases
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 are also available in the F9300:
Note that changing the defined values in the F9300 - Database Property Values table is not recommended or supported.
Source - MOS ID 1077277.1
JDE E1 Technical
|2348 day(s) ago||#135|
Date: 2013-12-20 05:17:50
Maximum Number of Columns in a Table in JDEHi TechZone,
Really very useful details.
|Disclaimer:||Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).|
Copyright © 2010 - 2020 JDEthread.in