SQL Queries - CAST Knowledge Base - Queries on Transactions - How to remove custom function point on Transactions

Purpose of Query

This query removes the custom function point calibration on Transactions.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS2✅

Query for CSS

UPDATE dss_transaction
SET    user_fp_value = NULL,
       user_isinput  = NULL

Query result example

–None

Query result interpretation

This query removes the custom function point calibration on Transactions.

Query for Oracle

UPDATE dss_transaction
SET    user_fp_value = NULL,
       user_isinput  = NULL

Query result example

None

Query result interpretation

This query removes the custom function point calibration on Transactions.

Query for SQL server

UPDATE dss_transaction
SET    user_fp_value = NULL,
       user_isinput  = NULL

Query result example

None

Query result interpretation

This query removes the custom function point calibration on Transactions.

Notes/comments

Related Pages