SQL Queries - CAST Central Base - Corruptions on Data Function - How to list Datafunctions that are considered as Transactions

The SQL query in this page lists the Data Functions that are considered as Transactions. This corruption is due to configuration

SELECT * 
FROM   efp_df_info 
WHERE  object_id IN (SELECT object_id 
                     FROM   efp_tran_info); 

In order to fix this corruption do the following:

1. Install the following Stored procedure SYSTEMX_EFP_Correct.sql

2. Execute the Stored procedure on the central base as follow:

   Remediation

   select SYSTEMX_EFP_Correct()