Anyone have any luck writing the encoded JSON out to the IFS like we have done with XML using sqltype(xml_clob_File) and Select-ing into that variable? Do I need to convert / cast the JSON_OBJECT into a CLOB in the SQL? Thanks!

Quick Test...
dcl-s Outfile sqltype(xml_clob_File) ;
exec sql Set Option COMMIT=*NONE,CLOSQLCSR=*ENDMOD,DATFMT=*ISO;

// Prep JSON File
Outfile_Name = %trim('/temp/test.json');
Outfile_NL = %len(%trimr(Outfile_Name));
Outfile_FO = SQFCRT;

exec sql Select json_object ('upc' value fldupc, 'price' value price) Into :Outfile From PRICING;




This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].