SQL Queries - CAST Knowledge Base - Queries on Transactions - How to get the status of a data function

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(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS2(tick)
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