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

Created by Amine Benarbia on Feb 11, 2022


Purpose of Query

 This removes the custom function point calibration on Data Functions.

Applicable CAST Version

Release

Yes/No

8.3.x  (coche)
8.2.x  (coche)
8.1.x  (coche)
8.0.x  (coche)
Applicable RDBMS

 

RDBMS

Yes/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