Re: Run SQL Scripts to write JSON to IFS

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Couple of things...

QSYS2.IFS_WRITE_UTF8() is probably a better choice for JSON.

Also realize that the IFS_WRITE routines are stored procs, and must be
CALLed...

Lastly, it always helps to show your code...

Charles


On Tue, Feb 7, 2023 at 2:48 PM Greg Wilburn <
gwilburn@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

> I'm working with the json_object and related in Run Sql Scripts.  I'm able
> to create the JSON string, and now I'd like to write that to the IFS from
> withing ACS.
>
> I've been looking at the QSYS2.IFS_WRITE() function.  But I haven't been
> able to apply the examples I've found to my "Select json_object()"
> statement.
> Is this possible?
>
> This would allow me to more easily change my JSON output before placing
> the code into a program.
>
> Thanks,
> Greg
> [Logo]<https://www.totalbizfulfillment.com/>    Greg Wilburn
> Director of IT
> 301.895.3792 ext. 1231
> 301.895.3895 direct
> gwilburn@xxxxxxxxxxxxxxxxxxxxxxx<mailto:gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>
> 1 Corporate Dr
> Grantsville, MD 21536
> www.totalbizfulfillment.com<http://www.totalbizfulfillment.com>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.