AW: Insert into XML column

Hm...

It seems your XML-Document is either not well-formed or not in UTF-8 (expected default in QAQQINI)
You may try to check the XML-File (CLOB-FILE) with the XMLPARSE function before inserting.

Insert into ....
Values(XMLPARSE(Document :YourIFSFile) ;

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
„Train people well enough so they can leave, treat them well enough so they don't want to.“ (Richard Branson)


-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Justin Taylor
Gesendet: Friday, 12.8 2016 22:04
An: RPG programming on the IBM i (AS/400 and iSeries)
Betreff: RE: Insert into XML column

The get_xml_File function gives me a message saying commitment control is required.

I still get 2200M for XML_CLOB_FILE. I threw together a crude test program:

Dcl-s xmlFile sqlType(XML_CLOB_FILE);

EXEC SQL
create table QTEMP.XMLTABLE
(doc XML);
xmlFile_FO = 2;
xmlFile_NAME = IFS_CONSTANT;
xmlFile_NL = %len( %trimr(xmlFile_NAME) );
EXEC SQL
insert into QTEMP.XMLTABLE
values(:xmlFile);
Dsply SQLSTATE;

*inLR = *on;
Return;




-----Original Message-----
From: Hauser [mailto:Hauser@xxxxxxxxxxxxxxx]
Sent: Friday, August 12, 2016 2:10 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: AW: Insert into XML column



You need to define a sqltype (xml_clob_file). You May also try to directly Insert the xml File by using the get_xml_File function.Birgitta


Von meinem Samsung Gerät gesendet.