F00165 Change Media Object Location

Media Object Change Location

1. Change New Location in P98MOQUE
2. Copy Media Object File to new Location
3. Update F00165 Table


UPDATE PRODDTA.F00165 SET GDGTFILENM = REPLACE(RTRIM(GDGTFILENM),'\\OldMachine\E900\MEDIAOBJ\HTMLUpload\','\\OldMachine\E900\MEDIAOBJ\HTMLUpload\') WHERE GDGTFILENM LIKE '%\\OldMachine\E900\MEDIAOBJ\HTMLUpload\%';