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

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

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