RE: [External] Field reference file record length exceeded

[Stephen Landess <steve_landess@xxxxxxxxxxx>]

Eric - 

I agree with your recommendation, but it will not necessarily solve the problem for everyone.  

To facilitate installing software upgrades, JDE (Oracle) recommends (and reserves for customers to use) the $ as the first letter for custom-defined Data Dictionary entries. 

In a JDE shop If you create a lot of new custom fields, the F98FRF$ field reference file will eventually reach the maximum record length and won't compile - usually when you're in crunch time and /really/ need to get something done quickly.  

This happened to us at Alcon Labs a couple of years ago.

https://www.ibm.com/docs/en/i/7.4?topic=concepts-database-file-sizes
https://www.ibm.com/docs/en/i/7.4?topic=capacities-miscellaneous-limits

Regards,
Steve Landess
512-289-0387

Eric wrote:
> I recommend that you create multiple field reference files, 
> just as JD Edwards WorldSoftware specifies  26 field reference files, 
> one for each of the 26 letters of the alphabet, 
> and additional field reference files for $ and @.
> When you have many fields to define, you need more field reference files.
> I have a misty vague memory that you are describing an IBM limit 
> (record length .  .  .  maximum of 32766)