[Google]
Online Marketing
Add blog to our directory.
EnterpriseOne, Tips

What are the maximum number of columns in a JDE table?

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

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

Published under the license.

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

1 comment to What are the maximum number of columns in a JDE table?

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

*