Example: JSONExtract with NULL Results

Teradata Vantage™ JSON Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1150-162K
The example uses the JSONExtract method to extract NULL results from a table.
The example uses the table(s) created earlier.
/* JSONExtract with some NULL results – get everyone's job. */
 
SELECT eno, edata.JSONExtract('$..job') 
FROM my_table 
ORDER BY 1;
Result: A NULL is returned for a person in the table who does not have a job.
ENO edata.JSONExtract(…)
--------------------------
1  [ "programmer" ]
2  ?
3  [ "CPA" ]
4  [ "small business owner" ]