This problem also brings some inconvenience, when you are copying
environment from one installation to another using MS Access files and, for
instance, R98403 application. Tables are copied to Access, but 'long'
indexes are not created in Access file. You'll get errors such us 'can not
create indexes with more than 10 in MS Access.... ' in your log files, and
R98403 report says, that copy process was not successful for the table.
But when you actually copy data from Access to Target database (MS-SQL,
Oracle, or DB2) , proper indexes are created in normal way.
I've found about 20 such tables in Xe 'Business Data - xxxxx' datasource .
Yaroslav Mudrenko
Source: Xe Base, Ms-SQL 7.0 SP2
Target: Xe Base, Oracle 8.0.5 / NT
c_moskowitz <
[email protected]>@jdelist.com on 21.01.2001 18:30:01
Please respond to
[email protected]
Sent by:
[email protected]
To:
[email protected]
cc:
Subject: Re: XE : Problems on Table Design Aid with an index more than 10
columns ~~4338:4374
Hello Perry,
JDE has confirmed that this message is a 'warning' and
not an error and reflects the respective database (in
your case - DBII)recommended columnn limits.
According to JDE, this should not cause problems.
However if you do experience a problem, we'll need to
raise w/JDE.
Craig
--- Perry Burch <
[email protected]> wrote:
>
> If a table has an index (even vanilla tables)the
> following pop up warning
> error occurs:
>
> Index (AB,CD,EFG,XXX,etc.) has more than 10 columns
> and may not generate in
> all databases.
> Do you want to save anyway? With "Yes"/"No" response
> tabs.
>
> But the table is built on the entrprise server
> (AS/400)
>
>
> Any insight/workarounds into this issue? Possible
> pitfalls on ignoring the
> message?
>
> Platform: AS/400; OneWorld XE SP 14
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4338
>
>
*************************************************************
> This is the JDEList One World / XE Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at
http://www.JDELIST.com
>
*************************************************************
>
--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=4374
*************************************************************
This is the JDEList One World / XE Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at
http://www.JDELIST.com
*************************************************************