Importing WSDL to make a relational source model, teh response procedure's SQL misuses the namespace when it should include the name of the object. For example:
SELECT t.* FROM XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns), '/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH '/ns:') AS t
should be:
SELECT t.* FROM XMLTABLE(XMLNAMESPACES('http://www.metamatrix.com/suppInfo_Output' AS ns), '/ns:suppInfo_Output/suppInfo_Output_Instance' PASSING Supp2View.getsuppInfo_response.xml_in COLUMNS SUPPLIER_NAME string PATH '/SUPPLIER_NAME') AS t
|