SQL Queries - CAST Knowledge Base - Queries on Data Function - How to remove custom function point on Data Functions

Purpose of Query

This removes the custom function point calibration on Data Functions.

Applicable CAST Version

ReleaseYes/No
8.3.x(coche)
8.2.x(coche)
8.1.x(coche)
8.0.x(coche)

Applicable RDBMS

RDBMSYes/No
Oracle Server(coche)
Microsoft SQL Server(coche)
CSS2(coche)

Query for CSS

UPDATE dss_datafunction
SET    user_fp_value = NULL,
       user_isinput  = NULL

Query result example

None

Query result interpretation

This removes the custom function point calibration on Data Functions

Query for Oracle

UPDATE dss_datafunction=
SET    user_fp_value = NULL,
       user_isinput  = NULL

Query result example

None

Query result interpretation

This removes the custom function point calibration on Data Functions

Query for SQL server

UPDATE dss_datafunction=
SET    user_fp_value = NULL,
       user_isinput  = NULL

Query result example

None

Query result interpretation

This removes the custom function point calibration on Data Functions

Notes/comments

Related Pages