CALL sp_xml_preparedocument (v_DocHandle INOUT, v_XmlDocument);
select * from OPENXML (v_DocHandle ,"/ArrayOfPair/Pair",2)
with("Key" VARCHAR(255),"Value" VARCHAR(255));
I have two unsolved issues in my code- mentioned by red. Does anybody know what wrong with it?
And what is your actual issue, syntax errors?
You try to run SQL Server syntax in Teradata, of course this fails, there are no functions named sp_xml_preparedocument or OPENXML.
Additionally the calling convention is wrong, there's no INOUT parameter in a CALL and strings are single quoted.