Re: CCSID issues with IFS files created with SQL

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Carel

This begins to sound like something that could be handled using CGIDEV2 
or similar tool - that can easily write out to any XML structure, and 
you can tell it to put the output into a file of any CCSID you need.

For the archive, CGIDEV2 can be found for free at easy400.net

Cheers
Vern

On 8/26/2020 4:13 PM, Carel wrote:
> Thanks for the reply.
>
> We do not use the XML SQL clauses, as the XML docs we have to mak are 
> more complex, with multiple layers (level of indention/segments).
> I have to fill one segment with data from 8 different PFs; very 
> difficult to do with SQL.
> At the moment it is a simple program that creates an XML template 
> (stucture stored in a PF) and for each segment calls a 
> subprocedure;each segment has its own SQL statement., that retrieves 
> the required daa values.
>
> That manual is the one I hadn't downloaded and/or searched.
>
>
> Op 26-8-2020 om 15:16 schreef Justin Barrett:
> > The first question you mentioned, rather than repeat, I'll indicate 
> > that you check out this 
> > https://www.rpgpgm.com/2018/05/creating-xml-file.html.
> >
> > Second, I do not see CCSID being used for SQLTYPE(CLOB_FILE) anywhere 
> > in the SQL embedded manual, so I'm not sure what CCSID after SQLTYPE 
> > will do, but clearly it isn't what you wanted. See the link I gave to 
> > have a bit more control over the flow of data.
> >
> > Finally, the SQLTYPE(CLOB_FILE) is talked about in the Embedded SQL 
> > Programming manual.  For 7.1 you can find that here. 
> > https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/rzajp/rzajp.pdf?view=kc
> >
> > Thank you