AnsweredAssumed Answered

SQL-Trace-  PMD statement - .map

Question asked by Rajini on Mar 19, 2013
Latest reply on Apr 2, 2013 by Rajini
Hi All,

When we trace a certain action in clarity, in 12.1.1... we know that when we have a sql statement, it is generally preceded by "PMD-STATEMENT" which says where the sql is obtained from..

example :PMD:STATEMENT: projmgr.getShowTasksWhenHdBkd_stmt in planningPMD.xml woudl say the following statement was defined in "planningPMD.xml "..

but what does it mean when it says ".map"?

example:-


PMD:STATEMENT-SET: odf-pmd.assignment.select-list-conditional.map
NDE:PSTM@19005e6b: Non-SQL Time: 13
select * from (select row_number() over ( order by prfinish asc) odf_row_num, count(*) over (partition by pmd_analytical_partition_by) odf_num_rows, q.* from ( select 'x' pmd_analytical_partition_by, prassignment.prid odf_pk , odf_ca_assignment.partition_code COLLATE Latin1_General_CI_AS_KS partition_code, (select b.name from cmn_partitions a,cmn_captions_nls b where a.id = b.pk_id and b.table_name = 'CMN_PARTITIONS' and b.language_code = ? and a.code = odf_ca_assignment.partition_code union select name from cmn_captions_nls where pk_id = -1 and table_name = 'CMN_P...............................

where can i find "select-list-conditional.map"?

Thanks and Regards,
Rajini

Outcomes