A DB2 SQL Statement
SELECT *FROM (selecta.*, b.*, c.Record_Type, c.Record_Count fromSCHEMAE.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 cwherea.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]