Table I/O to update indexed record

[jeremy1010]

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?

 

[saikiran]

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.

 

[craig_welton]

or 3. Delete the existing record and insert the new one.

 

[sonal_m]

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.