We are trying to execute
TRANSLATE on a couple hundred rows of data. We have a temporary table containing ID's to rows that need to be updated using
TRANSLATE. The odd part is if we attempt to select say two rows, the command is executed properly and the information is updated. However, when we try to run it against 200 rows, it says that 200 rows were updated, but in inspecting the data, they have not been updated. Is there a limitation to the number of rows that can be updated using
TRANSLATE in a single query?
We're doing something like:
UPDATE TABLE_A SET COLUMN_TO_UPDATE = TRANSLATE(COLUMN_TO_UPDATE,'ñ','n') WHERE ID IN (SELECT ID FROM TEMP_TABLE);