SQL Queries - CAST Knowledge Base - Queries on Installation - How to check if a TCC tool kit is installed

Purpose of Query

The query checks if there is an installed TCC tool kit and returns the version of the tool

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT version 
FROM   sys_package_version 
WHERE  package_name = 'TCK_LOCAL';

Query result example

1.7.1.0".

Query result interpretation

The query returns the version of the installed TCC tool kit

Query for Oracle

SELECT version  
FROM   sys_package_version 
WHERE  package_name = 'TCK_LOCAL';

Query result example

"1.7.1.0".

Query result interpretation

The query returns the version of the installed TCC tool kit

Query for SQL server

SELECT version 
FROM   sys_package_version 
WHERE  package_name = 'TCK_LOCAL';

Query result example

"1.7.1.0".

Query result interpretation

The query returns the version of the installed TCC tool kit

Notes/comments

Related Pages