SQL Queries - CAST Knowledge Base - Queries on Data Function - How to check if there is custom function point on Data Functions

Purpose of Query

This query returns the custom function point calibration on Data Functions

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT count (1)
from dss_datafunction
where  user_fp_value is  not null
or  user_isinput is not null

Query result example

2

Query result interpretation

The query returns the number of customized Data Functions

Query for Oracle

SELECT count (1)
from dss_datafunction
where  user_fp_value is  not null
or  user_isinput is not null

Query result example

2

Query result interpretation

The query returns the number of customized Data Functions

Query for SQL server

SELECT count (1)
from dss_datafunction
where  user_fp_value is  not null
or  user_isinput is not null

Query result example

2

Query result interpretation

The query returns the number of customized Data Functions

Notes/comments

Related Pages