Re: JSON_OBJECT and Writing to IFS

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

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com