XML : Import XML in to Netezza

I was trying to import XML into Neteeza via Aginity using following stored procedure.

  CREATE OR REPLACE PROCEDURE testXML()   RETURNS VARCHAR(10)   LANGUAGE NZPLSQL AS  BEGIN_PROC    DECLARE @XML XML = '<EventSchedule>      <Event Uid="2" Type="Main Event">          <IsFixed>True</IsFixed>          <EventKind>MainEvent</EventKind>          <Fields>              <Parameter Name="Type" Value="TV_Show"/>              <Parameter Name="Name" Value="The Muppets"/>              <Parameter Name="Duration" Value="00:30:00"/>          </Fields>      </Event>      <Event Uid="3" Type="Secondary Event">          <IsFixed>True</IsFixed>          <EventKind>SecondaryEvent</EventKind>          <Fields>              <Parameter Name="Type" Value="TV_Show"/>              <Parameter Name="Name" Value="The Muppets II"/>              <Parameter Name="Duration" Value="00:30:00"/>          </Fields>      </Event>  </EventSchedule>';  BEGIN   EXECUTE 'SELECT      EventUID = Events.value(''@Uid'', ''int''),      EventType = Events.value(''@Type'', ''varchar(20)''),      EventIsFixed =Events.value(''(IsFixed)[1]'', ''varchar(20)''),      EventKind =Events.value(''(EventKind)[1]'', ''varchar(20)'')  FROM'||   @XML.nodes||'(''/EventSchedule/Event'') AS XTbl(Events)'    RETURN "SUCCESS" ;   END;   END_PROC;    

I followed the below solution

XML Import

Looks like I am doing wrong somewhere.