I am attempting to publish an XML document and I am getting the following error:
CALL Failed. 7504: in UDF/XSP/UDM SYSXML.PUBLISH_XML_LOB: SQLSTATE U0036: Fetch result set error, cli request error!errorcode: 3706, errorstring:Syntax error: expected something between the 'SELECT' keyword and the 'ROW' keyword.
ROW is the tag for each row of data returned. Why am I getting this error? My stylesheet in the repository looks like it has nulls between all the chars. Did it get switched to Unicode somehow?
When I select my Stylesheet from sysxml.stylesheetrepository it has weird characters at the begining for the clob. I successfully registered the schema and the stylesheet and call publish_xml_log with: CALL SYSXML.PUBLISH_XML_REF('SELECT A.TYPE_EQUIP_CODE AS TEC'