Page tree

在当前页:

介绍

一旦建立了事务配置 (它提供了在应用边界中构建事务的方法并执行了计算,就必须对所有生成的事务进行审查。文档的这一部分提供了SQL查询,以自动收集与事务相关联的规则和对象。这些列表应发送给SME进行验证。

应用边界中的对象

必须将事务范围与应用边界进行比较。下面的第一个SQL查询统计应用边界中的对象数。第二个提供已计数对象的详细列表。这将允许对事务中涉及的对象和应用中可用的对象总数进行比较。

set search_path=<Prefix>_local;
 
select count (1) as NumberOfFile from (
select distinct object_name,
object_fullname, 
object_type_str 
from cdt_objects cob, ctt_object_applications coa
where object_type_str like '%File%'
and cob.object_id = coa.object_id
and coa.properties = 0
order by 3 ASC, 2 ASC) as result;

结果应如下所示:

 

第二个SQL查询是:

set search_path=<Prefix>_local;
 
select distinct object_name,
object_fullname, 
object_type_str 
from cdt_objects cob, ctt_object_applications coa
where object_type_str like '%File%'
and cob.object_id = coa.object_id
and coa.properties = 0
order by 3 ASC, 2 ASC;

结果应如下所示:

点击放大


检查事务配置

入口点规则

用于选择入口点的通用集合列表

下面显示的SQL查询提取为实现搜索入口点的规则而创建的通用对象集合:

set search_path=<prefix>_mngt;
 
select osd.settype, osd.setname, osd.setdefinition
from cal_objsetdef osd, cal_setassociation sa
where sa.set_id = osd.set_id
and osd.settype = 'Transaction entry points'
and sa.attributenumvalue = 0
order by 1,2;

结果应如下所示:

点击放大:


用于选择事务入口点的自由定义规则列表

以下SQL查询提取用户创建的对象集合,以收集具体到应用的事务入口点。这些规则必须由SME验证。

set search_path=<prefix>_mngt;
 
select osd.settype, osd.setname, osd.setdefinition, sa.attributename, sa.attributenumvalue, sa.attributecharvalue 
from cal_objsetdef osd, cal_setassociation sa
where sa.set_id = osd.set_id
and osd.settype = 'Transaction entry points'
and sa.attributenumvalue > 0;

结果应如下所示:

点击放大:


它对应于在CAST事务配置中心中创建的规则:

点击放大:


 

数据函数规则

 以下SQL查询提取为收集数据实体而创建的对象集合。这些规则必须由SME验证。

set search_path=<prefix>_mngt;
 
select osd.settype, osd.setname, osd.setdefinition, sa.attributenumvalue as defaultFPValue
from cal_objsetdef osd, cal_setassociation sa
where sa.set_id = osd.set_id
and osd.settype = 'Data functions'
and sa.attributenumvalue > 0
and sa.attributename != 'application ID'
order by 1,2;

结果应如下所示:

点击放大:


它对应于在CAST事务配置中心中创建的规则:

点击放大



终点规则

以下SQL查询提取为收集终点而创建的对象集合。

set search_path=<prefix>_mngt;
 
select osd.settype, osd.setname, osd.setdefinition, sa.attributename, sa.attributenumvalue, sa.attributecharvalue 
from cal_objsetdef osd, cal_setassociation sa
where sa.set_id = osd.set_id
and osd.settype = 'Transaction end points'
and sa.attributenumvalue > 0
order by 1;

"attributenumvalue"列包含终点的默认值。配置的定义在"setdefinition"列中。如果需要,可以放大列的大小以查看XML。结果应如下所示:


通用集合列表

通用集合用于实现复杂的自由定义规则,并且可以在多个规则之间共享(例如:入口点、终点、数据实体和排除项)以下SQL查询提取已创建的通用集合,以便使用SME验证它们。


set search_path=<prefix>_mngt;
 
select osd.settype, osd.setname, osd.setdefinition, sa.attributename, sa.attributenumvalue, sa.attributecharvalue 
from cal_objsetdef osd, cal_setassociation sa
where sa.set_id = osd.set_id
and osd.settype = 'Generic sets'
and sa.attributenumvalue > 0
order by 1;

结果应如下所示:


排除项目规则

有些对象与事务无关,因此必须从计算中排除。必须用SME验证这些对象列表或它们被标识方式。以下SQL查询提取为收集已排除的项而创建的对象集合:


set search_path=<prefix>_mngt;
 
select osd.settype, osd.setname, osd.setdefinition
from cal_objsetdef osd, cal_setassociation sa
where sa.set_id = osd.set_id
and osd.settype = 'Excluded items'
and sa.attributenumvalue > 0
order by 1;

结果应如下所示:


它对应于在CAST事务配置中心中创建的规则:

入口点列表

以下SQL查询根据配置规则统计应用中标识的入口点数量:

set search_path=<Prefix>_local;
 
select count (1) as NumberOfPotentialEntry from (
select cob.object_name as transaction, cob.object_fullname as transactionfullname, cob.object_mangling, cob.object_type_str
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
order by 3 ASC, 2 ASC) as result;

结果应如下所示:


提供相应详细信息的SQL查询如下:

set search_path=<Prefix>_local;
 
select cob.object_name as transaction, cob.object_fullname as transactionfullname, cob.object_mangling, cob.object_type_str
from dss_transaction dtr, cdt_objects cob
where dtr.form_id = cob.object_id
order by 3 ASC, 2 ASC;

结果应如下所示:


  • No labels