How To Copy OCM Records From One Environment To Another Using SQL
Read Time:54 Sec
This method can be used to copy any records in a database but the issue that I was trying to resolve was to copy 8 records in the Object Configuration Management (OCM) file, F986101, of one object to another object.
INSERT INTO SY900/F986101( OMENHV, OMOBNM, OMDATP, OMUGRP,OMOAPP, OMDATM, OMSY, OMSTSO, OMPID, OMFUNO, OMUSER, OMJOBN, OMOCM2, OMUPMJ, OMUPMT) (SELECT OMENHV, '', OMDATP, OMUGRP, OMOAPP, OMDATM, OMSY, OMSTSO, 'SQL', OMFUNO, ' ', ' ', OMOCM2, , FROM SY900/F986101 WHERE OMOBNM=' ')
When using this SQL you will need to replace the following:
- <NEW_OBJECT> – The target object to which you would like to copy the records.
- <USERID> – (optional) The UserID that you would like to credit making this change.
- <6DIGITDATE> & <6DIGITTIME> – (optional) The JDE Date and Time that you are making the change.
- <ORIGINAL_OBJECTID> – The ObjectID of the OCM record that you wish to copy.
This method can also be used to copy OCM records from one environment to another by setting the environment in the select statement and where clause.
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Average Rating