Question & Answer
Question
How do you convert the unique identifier (GUID) in the Oracle and DB2 database so that it matches what is displayed in the IBM FileNet P8 Platform via Workplace/WorkplaceXT and FileNet Enterprise Manager?
Answer
For example, this GUID as displayed from FileNet Enterprise Manager, needs to be byte reversed so that it can be queried upon in Oracle. When querying on GUIDs, GUIDs are stored in byte-reversed form in Oracle and DB2 (not MS SQL), whereby the first three sections are pair reversed and the last two are left alone.
{A7DD199F-FF00-43C0-8453-189A202CDAAE} =
[{"Product":{"code":"SSNW2F","label":"FileNet P8 Platform"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Content Engine","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"5.1;5.0;4.5.1;4.5;4.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21587420