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
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  (tick)
Microsoft SQL Server  (tick)
CSS2  (tick)


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