Re: JSON_OBJECT and Writing to IFS

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