Examples of Modifying the CMN_PROFILE_GLOBAL Table
This section provides sample SQL for how to update and insert values in the CMN_PROFILE_GLOBAL table in the database.
Note that values, as specified, are case sensitive.
- Updating an Existing Value
- To update an existing value in the CMN_PROFILE_GLOBAL
table:
UPDATE CMN_PROFILE_GLOBAL set value = '10' WHERE section = 'DATABASE' AND key = 'ABC'; commit;
- Inserting a New Row of Values
- To insert a new row of values into the CMN_PROFILE_GLOBAL
table:
INSERT into CMN_PROFILE_GLOBAL (section, key, company_defined, name, value, description) values ('DATABASE', 'ABC', '0', 'ABC', 'ABC_DEF_XYZ'); commit;
Parent topic: Introduction