A DB2 SQL Statement
SELECT *
FROM (
selecta.*, b.*, c.Record_Type, c.Record_Count from
SCHEMAE.TAB1 a , SCHEMAE.TAB2 b, XMLTABLE ('$h/BizInfoXML/Reporting/Details' passing b.biz_info_xml as "h" COLUMNS Record_Type VARCHAR(100) PATH 'Record_Type',Record_Count VARCHAR(100) PATH 'Record_Count') AS c
wherea.LOG_TIME > '2010-06-25-00.00.00.000000' AND a.LOG_TIME <= '2010-06-25-23.59.59.000000' ANDa.MSG_ID=b.MSG_ID )aa, ESHLOG.MAP_IDD_MSGFLOW bb WHEREaa.MSG_FLOW_NAME=bb.MSG_FLOW_NAME
页:
[1]