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.
Author
Stewart Schatz
Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it.
Side Hustle: Owner/Operator of E1Tips.com
Location: Lancaster, PA USA
What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
More Stories
How to Use the CMDKEY Command to Manage Stored Credentials on Windows
The cmdkey command is a Windows utility that lets you create, delete, and manage stored credentials for network authentication. This is particularly useful…
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
Average Rating