XMLRelation Example: ErrorHandler - Teradata Vantage

This example handles a malformed input document.

Input

The second XML document is malformed.

SQL Call

SELECT * FROM XMLRelation (
  ON xmlrelation_error
  USING
  TextColumn ('xmldocument')
  DocIDColumns ('xid')
  MaxDepth (1)
  ErrorHandler ('true;xmldocument')
) AS dt ;

Output

 xid out_nodeid element attributes value_col d0id d1id errorhandler                  
 --- ---------- ------- ---------- --------- ---- ---- ----------------------------- 
   1          2 Dept    name=EE                 1    2 NULL                         
   1          1 School  name=UCLA               1 NULL NULL                         
   2       NULL NULL    NULL       NULL      NULL NULL <School /School> name="UTA">;

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.