Re: json_update - does it work?

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

what is weird is that on both boxes...

if you look at the functions under schema systools (or on
qsys2.sysroutines), you see 2 versions of json_update...
one that requires 5 parms and one that requires 2 parms...

So I guess my question has to be directed to anyone that has successfully
used json_update and how?

thanks

Jay

On Thu, Jul 17, 2025 at 12:05 PM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

> any reason why this simple scenario does not work?
>
> tried this simple scenario on 2 different IBM i's and both error the same.
>
>
> create or *replace* variable jvaughn.jsonObj      *clob*(*1*g);
> set jvaughn.jsonObj = '{"destAddr1":"foo"}';
> set jvaughn.jsonObj =
>   systools.bson2json(
>     systools.*json_update*(
>                          systools.json2bson(jvaughn.jsonObj)
>                         ,'{ $set: {"destAddr1":"bar"}}'
>                         )
>                     );
>
>
> I get this error (on both boxes)
>
>
>  Message ID . . . . . . :   CPF503E       Severity . . . . . . . :   30
>
>  Message type . . . . . :   Notify
>
>  Date sent  . . . . . . :   07/17/25      Time sent  . . . . . . :
> 12:01:25
>
>
>  Message . . . . :   User-defined function error on member QSQPTABL.
>
>  Cause . . . . . :   An error occurred while invoking user-defined
> function
>    JSON_UPDATE in library SYSTOOLS. The error occurred while invoking the
>
>    associated external program or service program QSQJSON in library QSYS,
>
>    program entry point or external name jsonUpdate2, specific name
> JSON_00001.
>    The error occurred on member QSQPTABL file QSQPTABL in library QSYS2.
> The
>    error code is 1. The error codes and their meanings follow:
>
>      1 -- The external program or service program returned SQLSTATE 38553.
> The
>    text message returned from the program is: JSON parsing error code: 9
> for: .
>    .set: ."destAddr1":"bar".. .
>
>      2 -- The external program failed before it completed.
>
>      3 -- The database timed out waiting for the program to return. The
> timeout
>
> More...
>
>
> thanks
>
> Jay