Re: JSON_OBJECT and Writing to IFS

[Bryan Dietz <bdietz400@xxxxxxxxx>]

Check the PF, DSPFD, and see what the CCSID is.

Bryan


> On Jan 9, 2020, at 12:50 PM, Art Tostaine, Jr. <atostaine@xxxxxxxxx> wrote:
>
> OH I see I need   SqlType(DBCLOB_FILE).  But I still get the CCSID Error!
>
> On Thu, Jan 9, 2020 at 12:15 PM Art Tostaine, Jr. <atostaine@xxxxxxxxx>
> wrote:
>
> > Thank you Birgitta.  I definitely am set to CCSID 37
> >
> > I declare the DBCLOB like this:
> > DCL-S  OutFile SqlType(DBCLOB:256000)  ccSid(1200) ;
> >
> > but these lines say the variables are not defined
> > Outfile_Name = %trim('/tmp/test.json');
> > Outfile_NL = %len(%trimr(Outfile_Name));
> > Outfile_FO = SQFCRT;
> >
> >
> > On Thu, Jan 9, 2020 at 12:10 PM Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
> > wrote:
> >
> > > The example returns the JSON Document as a CLOB Variable, while you
> > > defined a CLOB_FILE.
> > > You may try it with a DBCLOB_FILE.
> > >
> > > You are sure, your job environment is not CCSID 65535 or may be the data
> > > in your table are CCSID 65535.
> > >
> > > Try to explicitly cast your JSON Data to UTF-8 in SQL, but I assume it
> > > will not work either. Data without CCSID (or CCSID 65535) cannot be
> > > converted.
> > >
> > > Mit freundlichen Grüßen / Best regards
> > >
> > > Birgitta Hauser