Welcome Guest Login SignUp

Home

Technical

Functional

CNC

AS400

DB2

    Citrix

JDE News

Live Radio

Feedback

JDE Forum Comments/Reviews/Queries
2352 day(s) ago   #133
Name: TechZone
Category: Technical
Location: India
Date: 2013-12-16 23:52:18
Replies(1)

Status:
  #133

Maximum Number of Columns in a Table in JDE

It is defined differently in different JDE Releases -

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 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:

  • 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


Note that changing the defined values in the F9300 - Database Property Values table is not recommended or supported.
Source - MOS ID 1077277.1

Cheers!
JDE E1 Technical
2348 day(s) ago   #135
Name: BigLow
Category: Technical
Location:
Date: 2013-12-20 05:17:50
Replies(1)

Status:
  #135

Maximum Number of Columns in a Table in JDE

Hi TechZone,

Really very useful details.

Cheers
Post Comments/Queries
Email:*
Name:*
Details:*
 
   
* Required Entry Field(s).  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
 
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