×
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.
I couldn't get your SET OPTION to compile, so I just specified COMMIT(*UR) when I created the module.
Here's the code:
ifsPath = IFS_CONSTANT;
EXEC SQL
insert into QTEMP.XMLTABLE
(doc)
values( get_xml_File(:ifsPath) );
Dsply SQLSTATE;
Running it gives SQLSTATE 55019 (The object is in an invalid state for the operation). The joblog had CPF4328 & SQL7008 citing XMLTABLE not being journaled.
-----Original Message-----
From: Niels Liisberg [mailto:NLI@xxxxxxxxxxxxxxxxx]
Sent: Monday, August 15, 2016 2:56 AM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: Re: AW: Re: Insert into XML column
Actually it was :
Exec sql set option commit=ur
That did the trick for me...
And for no obvious reason: as Begitta says - it i only required for locators..
Btw. You don't need journaling to use the above...
Sendt fra min iPad
estions.
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
