JavaScript Object Notation, or JSON, is a widely used technology for information interchange on the web. This session provides an overview of JSON and describe how the JSON abilities integrated into Db2 for i allow for the easy use of JSON. In particular, the session will describe the use of the JSON_TABLE function to convert a JSON object to relational table, including several examples of using JSON_TABLE to utilize data available on the web. In the other conversion direction, the session will describe the JSON publishing functions, which create JSON objects using SQL statements. Using this knowledge, you can easily use the power of JSON within your own IBM i applications.
