Frosty the Coder
Legendary Poster
List,
This is also posted on the developers' forum.
We are currently converting XE to 9.1
This includes base table layout changes, such as F4104 which has columns and indexes added after XE.
We tried to generate indexes on F4104, it failed,
due to IVCIRV not being found in TESTDTA/F4104.
Looking at table design, we see no errors, but the generate index wouldn't work.
I resorted to
Copying F4104 (data) to a saved file (using AS400 CPYF)
Removing the table from the database (table operations)
Generating the table (table ops)
Generating the indices (table ops)
Copying the SAVED 4104 data into the new generated table.
Looking at the KG, it seems that I should NOT have to do this, as there are Table Conversions that should address
altered tables.
The TC specific to F4104 isn't stated on the pages I've looked at.
Here's my question:
What table conversion jobs should CNC have run to create/populate the modified tables?
This issue is NOT limited to F4104.
Please AND Thanks!
--------------------
Frosty
This is also posted on the developers' forum.
We are currently converting XE to 9.1
This includes base table layout changes, such as F4104 which has columns and indexes added after XE.
We tried to generate indexes on F4104, it failed,
due to IVCIRV not being found in TESTDTA/F4104.
Looking at table design, we see no errors, but the generate index wouldn't work.
I resorted to
Copying F4104 (data) to a saved file (using AS400 CPYF)
Removing the table from the database (table operations)
Generating the table (table ops)
Generating the indices (table ops)
Copying the SAVED 4104 data into the new generated table.
Looking at the KG, it seems that I should NOT have to do this, as there are Table Conversions that should address
altered tables.
The TC specific to F4104 isn't stated on the pages I've looked at.
Here's my question:
What table conversion jobs should CNC have run to create/populate the modified tables?
This issue is NOT limited to F4104.
Please AND Thanks!
--------------------
Frosty