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;