SQL XML. XMLTABLE 7.1

Any help would be greatly appreciated.

I am trying to use SQL, XML, XMLTABLE functionality on IBM i 7.1.

Using the below example from the web which is similar to other examples I am getting the following error.

INSERT INTO erl/address(cid, name, street, city)             
SELECT x.custid, x.custname, x.str, x.place                  
FROM XMLTABLE('$i/customerinfo' PASSING CAST(? AS XML) AS "i"
COLUMNS                                                      
custid INTEGER PATH '@Cid',                                  
custname VARCHAR(30) PATH 'name',                            
str VARCHAR(40) PATH 'addr/street',                          
place VARCHAR(30) PATH 'addr/city' ) AS x ;                  


Use of parameter marker not valid.     SQL0418. This seems to refer to the '?' in the CAST section of the statement.  


 

For more info. I am trying to load a XML file into a Physical file without XML fields/columns defined. So straight XML to PF file field mapping. 

Yours Sincerely,

Mark Golden