Purpose of Query
This page list the analyzed links eligible to be part of Transactions
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
| 8.2.x | |
| 8.1.x | |
| 8.0.x | |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server | |
| Microsoft SQL Server | |
| CSS2 | |
Query for CSS
SELECT acc.idacc AS link_id, acc.idclr AS caller_id, acc.idcle AS called_id,
acc.acctyplo AS link_type_lo, acc.acctyphi AS link_type_hi,
0 AS link_type_lo2, 0 AS link_type_hi2
FROM db_optimizer_local.acc
WHERE (acc.accknd = ANY (ARRAY[0, 4096, 262144, 1048576])) AND (acc.prop & 65536) = 0;
Query result example
3954;3951;"[C:\CASTMS\Deploy\CPP\Common\Util.h].[readconnectionprofiles(std::vector<std::string>&)]";1521;"[C:\CASTMS\Deploy\CPP\Common\Util.cpp].[Log_file(std::string, std::string)]"
Query result interpretation
The query returns link id, caller id, caller full name, called id, called full name
Query for Oracle
SELECT acc.idacc AS link_id, acc.idclr AS caller_id, acc.idcle AS called_id,
acc.acctyplo AS link_type_lo, acc.acctyphi AS link_type_hi,
0 AS link_type_lo2, 0 AS link_type_hi2
FROM db_optimizer_local.acc
WHERE (acc.accknd = ANY (ARRAY[0, 4096, 262144, 1048576])) AND (acc.prop & 65536) = 0;
Query result example
3954;3951;"[C:\CASTMS\Deploy\CPP\Common\Util.h].[readconnectionprofiles(std::vector<std::string>&)]";1521;"[C:\CASTMS\Deploy\CPP\Common\Util.cpp].[Log_file(std::string, std::string)]"
Query result interpretation
The query returns link id, caller id, caller full name, called id, called full name
Query for SQL server
SELECT acc.idacc AS link_id, acc.idclr AS caller_id, acc.idcle AS called_id,
acc.acctyplo AS link_type_lo, acc.acctyphi AS link_type_hi,
0 AS link_type_lo2, 0 AS link_type_hi2
FROM db_optimizer_local.acc
WHERE (acc.accknd = ANY (ARRAY[0, 4096, 262144, 1048576])) AND (acc.prop & 65536) = 0;
Query result example
3954;3951;"[C:\CASTMS\Deploy\CPP\Common\Util.h].[readconnectionprofiles(std::vector<std::string>&)]";1521;"[C:\CASTMS\Deploy\CPP\Common\Util.cpp].[Log_file(std::string, std::string)]"
Query result interpretation
The query returns link id, caller id, caller full name, called id, called full name
Notes/comments
Related Pages
