Purpose of Query
Thus query will help you to check which Metrics computation option has been calculated.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
Query for CSS
SELECT CASE WHEN infval = 0 THEN 'SPA Metrics computation: no metrics computation' WHEN infval = 1 THEN 'SPA Metrics computation: all metrics' WHEN infval = 2 THEN 'SPA Metrics computation: all metrics except copy/paste and commented code' ELSE 'N/A' END FROM anainf ai JOIN anajob aj ON aj.idjob = ai.idjob AND aj.jobtyp = 3001 WHERE ai.inftyp = 1 AND ai.infsubtyp = 31;
Query result example
--SPA Metrics computation: all metrics
Query result interpretation
The SQL query will return:
"Metrics computation: All metrics" if all Metrics computation option has been calculated
"Metrics computation: all metrics except copy/paste and commented code" if all Metrics computation option has been calculated except copy/paste and commented code
"Metrics computation: No metric computation" if all Metrics computation option has been not calculated
Query for Oracle
Query result example
Query result interpretation
Query for SQL server
Query result example
Query result interpretation
Notes/comments
Related Pages