Reading JSON with SQL on IBM i
A field holding JSON can be read with SQL. Four levels, from the first JSON_VALUE query to the cases where a value quietly comes out NULL.
Articles tagged #ifs — 3 results
A field holding JSON can be read with SQL. Four levels, from the first JSON_VALUE query to the cases where a value quietly comes out NULL.
Where things live on an IBM i: one level of libraries, no folders inside folders, and alongside it a file system that behaves the way you expect.
With the right delimiter and the right encoding, so Excel does not show odd characters.