Find All Checked Out Objects Using SQL
Use the SQL statement below to find all the objects that are checked out: select * from ol900/f9861 where sistce=3 ...
Archive for the ‘Object Configuration Management’ Category
How To Copy OCM Records From One Environment To Another Using SQL
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, ...
Add Record To OCM – F986101
The other day, I had a need to insert many records into the OCM (F986101). So I set out to create a quick SQL statement that would serve that purpose. Below is what I came up with: INSERT INTO SY811/F986101 VALUES('DV811',0,'OBJECTNAME','LOCAL','','*PUBLIC', '*ALL','P','','H95','AV','SQL','BSFN', 'USERNAME','','','',0,'',0,'','','','') Remember: you may have to make entries in both the SY811 and ...