 category proc descripciu8c3b3n descripciu8c3b3n descripciu8c3b3n copia deu800 mu8c3b3dulo enu800 proceso deu800 generaciu8c3b3n deu800 mu8c3b3dulos biblioteca biblioteca biblioteca composiciu8c3b3n tabla moduloscab tabla modulosdet cu8c3b3digo cu8c3b3digo cu8c3b3digo delimiter create definer sas_admin procedure copiamodulomodulo inu800 pmoduloold char 8u800 inu800 pmodulonew char 8u800 inu800 pmodulodsc varchar 50u800 begin -- ------------------------------------------------------ -- insert from moduloscab into bocetoscab -- ------------------------------------------------------ call debugcheckpoint concat proc copiamoduloboceto varu800 pmoduloold - pmodulonew - pmodulodsc ; delete from moduloscab where moduloid pmodulonew; delete from modulosdet where moduloid pmodulonew; insert into moduloscab moduloid modulodsc modulovw modulovh moduloimg moduloath modulofec select pmodulonew pmodulodsc moduloscab . modulovw moduloscab . modulovh moduloscab . moduloimg moduloscab . moduloath curdate from fzggestion . moduloscab where moduloscab . moduloid pmoduloold; -- ------------------------------------------------------ -- insert from modulosdet into bocetosdet -- ------------------------------------------------------ insert into modulosdet moduloid productoid composicid cantidadpr anchopredef altopredef dimensionchg cantidadchg productochg subsetancho subsetalto productovsb posx posy select pmodulonew modulosdet . productoid modulosdet . composicid modulosdet . cantidadpr modulosdet . anchopredef modulosdet . altopredef modulosdet . dimensionchg modulosdet . cantidadchg modulosdet . productochg modulosdet . subsetancho modulosdet . subsetalto modulosdet . productovsb modulosdet . posx modulosdet . posy from fzggestion . modulosdet where modulosdet . moduloid pmoduloold; endu800 bitu8c3a1cora bitu8c3a1cora bitu8c3a1cora usou800 