Purpose of Query
The SQL query in this page lists the Transactions that are considered as Data Functions. This corruption is due to configuration.
Applicable CAST Version
Release | Yes/No |
---|---|
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
SELECT * FROM efp_tran_info WHERE object_id IN (SELECT object_id FROM efp_df_info);
Query result example
-- 5;2523;0;1;"ADDED";30;0
Query result interpretation
The above result return the list of transactions that are configured as Datafunctions
In order to fix this corruption do the following:
- Install the following Stored procedure SYSTEMX_EFP_Correct.sql
Execute the Stored procedure on the central base as follows:
Remediationselect SYSTEMX_EFP_Correct()
Query for Oracle
Enter the SQL query
Query result example
Query result interpretation
Query for SQL server
Enter the SQL query
Query result example
Query result interpretation
Notes/comments
Related Pages