Re: Validating JSON Data in a Host Variable

On 2/1/2018 3:51 AM, Craig Richards wrote:

But if you just have the document in a Host Variable, is there an easy way
to validate it?

dcl-s testVar char(1024);
dcl-s isJSON char(1);

isJSON = '*'; // eyecatcher
testVar =
'{-
"message": "Hello!",-
"destination": "world"-
}';


exec sql
with test_json (json_string) as
( values(:testVar) )
select
case
when json_string is json object
then 'Y'
else 'N'
end as valid_json
into :isJSON
from test_json
;

dsply sqlstate;
dsply isJSON;

*inlr = *on;