Data Express – Method still exists after deletion

Problem

 Sometimes  after deleting a method in the Data Subset Extraction module  and trying to recreate it again with the same name the  following message appears:   "The method already exists for the selected MachineID  and Company".

Resolution

 To be able to delete completely the problematic method  execute the queries below:

 DELETE FROM  <owner name>.HSENVEXT     WHERE  (MCRECID = <MCRECID number>)   AND  (METHOD = <METHOD name>);

DELETE FROM  < owner name>.HSENVMTH   WHERE  (METHOD = <METHOD name>)        AND  (MCRECID = <MCRECID number>);

DELETE FROM  < owner name>.HSENVSTP    WHERE  (MCRECID = <MCRECID number>)   AND  (METHOD = <METHOD name>);

DELETE FROM  < owner name>.HSENVELB    WHERE   (MCRECID = <MCRECID number>)  AND  (METHOD = <METHOD name>);

DELETE FROM  < owner name>.HSENVFLT    WHERE   (METHOD = <METHOD name>)        AND  (MCRECID = <MCRECID number>);

DELETE FROM  < owner name>.HSDCHFIL    WHERE   (METHOD = <METHOD name>)        AND  (MCRECID = <MCRECID number>);

DELETE FROM  < owner name>.ANDCHFLF   WHERE   (METHOD = <METHOD name>)         AND  (MCRECID = <MCRECID number>);

where:

<owner name> is the name of the Data Express knowledge base. 

<METHOD name>  is the name of the problematic method.

<MCRECID number> is the number of the MachneID used in the method.    

To  retrieve the MCRECID  number execute the query:

SELECT * from <owner name>.HSURDCOM where machineid  like 'MACHINEID NAME%';

Note:  This  solution is valid for Data Express for z/OS  and  Distributed Systems.