Finally got the install to work with help from the documents on here. When I try to generate a canonical schema using the SYSXML.GEN_QUERY_CANONICAL_SCHEMA procedure, i get the following error:
*** Failure 7504 in UDF/XSP/UDM SYSXML.GEN_QUERY_CANONICAL_SCHEMA: SQLSTATE
U0027: Failed to create a CLI connector.
Statement# 1, Info =0
*** Total elapsed time was 1 second.
Here is the DB Version Info:
*** Logon successfully completed.
*** Teradata Database Release is 13.10.06.03
*** Teradata Database Version is 13.10.06.03
*** Transaction Semantics are BTET.
*** Session Character Set Name is 'ASCII'.
My CLIv2 version is 22.214.171.124.
my BTEQ version is 126.96.36.199
SYSXML.GEN_QUERY_CANONICAL_SCHEMA is an xsp that needs to execute some queries to gather metadata so it can generate the XML schema. To execute this query it creates a CLI connection. This could fail for a few reasons: