Examples of Modifying the CMN_PROFILE_ENTERPRISE Table

This section provides sample SQL for how to update and insert values in the CMN_PROFILE_ENTERPRISE 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_ENTERPRISE table:

UPDATE CMN_PROFILE_ENTERPRISE set value = '10'
WHERE section = 'DATABASE' AND key = 'ABC' AND ENTERPRISE_ID = 2;
commit;

Inserting a New Row of Values

To insert a new row of values into the CMN_PROFILE_ENTERPRISE table:

INSERT into CMN_PROFILE_ENTERPRISE (section, key, company_defined, name, value, description, enterprise_id)
values ('DATABASE', 'ABC', '0', 'ABC', '10', 'ABC_DEF_XYZ', 2);
commit;