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 SVM811 F986101 files.

Related posts

• You’re Fired! …But You’re Still Here? – Cleaning EnterpriseOne (E1) Orphaned Records After Deleting a User Profile (0)
• Who’s In That EnterpriseOne (E1) Role? (0)
• Who Has Access To That In EnterpriseOne (E1)? (0)
• Web Only Version Pain (2)
• Time To Change Your Password (0)