Analytics Software

Hello,

I need to rename my EUL Folders & Items following a naming convention, i thought about updating the EUL5 tables as the following :


- Step1 : Create a copy of eul5_objs :

create table eul5_objs_cpy as select * from eul5_objs ;

- Step2 : Update eul5_objs:

update eul5_objs set obj_name = initcap (obj_name);

- Step3 : Create a copy of eul5_expressions :

create table eul5_expressions_cpy as select * from eul5_ expressions ;

- Step4 : Update eul5_ expressions:

UPDATE eul5_expressions e
   SET e.exp_name =
       (SELECT TRIM(DECODE(INSTR(m.exp_name, ':'),
                      0,
                      LOWER(t.obj_name) || ' : ' || INITCAP(m.exp_name),
                      SUBSTR(m.exp_name, 1, INSTR(m.exp_name, ':', 1, 1) - 1) ||
                      INITCAP(SUBSTR(m.exp_name, INSTR(m.exp_name, ':', 1, 1)))))
          FROM eul5_expressions m, EUL5_OBJS t
         WHERE m.it_obj_id = t.obj_id
           AND e.exp_id = m.exp_id)
 WHERE e.it_obj_id is not null

but i heard that updating EUL5 tables could corrupt the EUL and it would end up in the impossibility to export/import it via the command line, so i was asked to update the EUL manually via Administrator.

For my information , could someone explein me whats the difference and how could it corrupt the EUL?

Thanks.

mcha