Page tree
Skip to end of metadata
Go to start of metadata
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

For 8.2: 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

For 8.2: TCC - 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
 
  • No labels