• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Table I/O to update indexed record

I am writing an UBE to update records in jde 9.0. The column that I would like to update is one of the last indexed columns in the table. This doesnt let me update the record. My question is if this can be handled in Table I/O? If yes what would be the process? If not how can this be handled?


Active Member
Primary keys should be immutable While there is nothing that will prevent you from updating :

1. You can have another index excluding the column you want to update.
2.You can try with select and update IO but it might have performance issues.


Active Member
Hi Jeremy - I dont think we can do this through table I/O. The only way I could think of is to create a new index on the table which does not have any columns which you want to update. Hope it helps.