Things get much simpler when using XML::XSH2. In fact, you would just need:

open 867322.xml ;
for /POWERMART/REPOSITORY/FOLDER/MAPPING/TRANSFORMATION[@TYPE="Sequenc
+e"]/TRANSFORMFIELD set @DATATYPE "integer" ;
save :b ;
[download]