在当前页:
介绍
一旦建立了事务配置 (它提供了在应用边界中构建事务的方法)并执行了计算,就必须对所有生成的事务进行审查。文档的这一部分提供了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;
结果应如下所示: