×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
