Add Record To OCM – F986101
March 31, 2009 by Stewart Schatz · Leave a Comment
Filed under: EnterpriseOne - SQLs, OCM, Object Configuration Management, enterpriseone, sql
Filed under: EnterpriseOne - SQLs, OCM, Object Configuration Management, enterpriseone, sql
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 SVM811 F986101 files.
Tags: enterpriseone, EnterpriseOne - SQLs, Object Configuration Management, OCM, OCM, sql, sql
