Re: Insert into XML column

[Niels Liisberg <NLI@xxxxxxxxxxxxxxxxx>]

You need to exec sql set option commit=nc .... 

Commit none will not work for clob / blob ...

Sendt fra min iPad

> Den Aug 12, 2016 kl. 23:05 skrev Justin Taylor <JUSTIN@xxxxxxxxxxxxx>:
>
> 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 is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.