Purpose of Query
This page provides information on how to check the status of a given data function to see if it is Deleted, Ignored, Splitted, Merged as a main object, Merged as a Detail object
More on function points can be found here:
For 8.3: CAST OMG-compliant Automated Function Points
Information on the status of data functions can be found here:
For 8.3: TCC - Enhancement - Data Functions/Transactional Functions sub-nodes - Right hand panel
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
Provide a Data Function Name in the query below and run
SELECT CASE WHEN cal_flags = 0 THEN 'data function is not a Merged, not Deleted, not ignored' WHEN cal_flags = 2 THEN 'data function is a main object of Data Function Merge' WHEN cal_flags = 4 THEN 'data function is a detail object of Data Function Merge' WHEN cal_flags = 8 THEN 'data function is deleted' WHEN cal_flags = 10 THEN 'the parent of this datafunction is deleted' WHEN cal_flags =256 THEN 'data function is ignored' END FROM dss_datafunction WHERE maintable_id = (SELECT object_id FROM cdt_objects WHERE object_name = '<Data Function Name>' )
Query result example
"datafunction is ignored"
Query result interpretation
The data function will be examined based on the cal_flags field to determine if it is Deleted, Ignored, Splitted, Merged as a main object, Merged as a Detail object
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