HCL Opportunity Detect - GDPR – General Technical Aspect of The Right of Erasure

HCL Opportunity Detect provides a utility to help administrators delete records under GDPR - Right of Erasure . The utility generates SQL scripts with delete statements for the provided configuration. These SQL scripts are generated for the DB2 and Oracle databases. These scripts contain separate queries for the DB2 and Oracle databases as follows; and so you should comment out the Oracle specific queries with a -- preceding the Oracle script while using DB2 and vice versa:

--DB2 
CREATE TABLE Temp_3405384762866779136 AS (SELECT audienceId 
FROM   test10.outcome 
   WHERE  0 = 1) 
WITH NO DATA;

--Oracle 
CREATE TABLE Temp_6594238626096596992 AS (SELECT audienceId 
 FROM   test10.outcome 
   WHERE  0 = 1);

--DB2
TRUNCATE TABLE test10.Temp_3405384762866779136 IMMEDIATE ;

-- ORACLE 
TRUNCATE TABLE test10.Temp_6594238626096596992;

Please review all the scripts with your DBA before executing them.