Is there a maximum key length for a JDE Database table?

[jimjung27]

Running on E900 Tools Release 8.98.42. This company is using MS-SQL Server 2008 R2 on Windows 7 Pro SP1 64 bit.

I am wondering if there is a maximum size to a key field defined in E1 in Table Design Aid (TBA).
I know that there is a maximum in SQL Server of 900 bytes for the total key length.

 

[vgsharma]

Hi Jimjung,

Table property limits have been stored in the F9300 (Database Property Values) table.
You can find Maximum key length for E1 Table in to F9300.

Also you can reffer My Oracle Support Doc 1077277.1.

 

[jimjung27]

Thank you vgsharma. The maximum in F9300 for SQL Server 2000 is the same 900 bytes.