VM-WIP SAP Migration Procedure

ORACLE

INSERT INTO "VMCLASSROOTGUID"
("BOLD_ID"

,"BOLD_TYPE"

,"CREATEDATE"

,"CREATEUSER"

,"MODIFDATE"

,"MODIFUSER"

,"OBJSTATUS"

,"STOREDGUID")

select "BOLD_ID"

,"BOLD_TYPE"

,SYSDATE

,' '

,SYSDATE

,' '

,'1'

,' '

--SELECT *

from "ABSECUREITEM"

where BOLD_ID NOT IN (SELECT DISTINCT BOLD_ID FROM "VMCLASSROOTGUID")

Commit;

-- Update VmPackage

UPDATE VMPACKAGE SET PACKAGEKIND = 5 WHERE PACKAGEKIND = 4;

Commit;