Json_Table that return an array

Hi all

I would need to write a porgram that with Json_Table invoke a web service
and return an array

In other program i have this situation; now "err" is an array . How can
manage this situation

Thanks



dcl-ds jsonData qualified;

status varchar(30);

err varchar(1024);

end-ds;



Select * from

Json_Table(Systools.HttpPostClob(:WebServiceUrl,
:WebServiceHeader,

:WebServiceBody

),

'$'

Columns( "status" VarChar(30) Path 'lax $.status' default ''
on empty,

"err" VarChar(1024) Path 'lax $.err' default '' on
empty

)) As x ;



--
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus