RE: AW: Re: Insert into XML column

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.