Re: New Article about SQL JSON Publishing Functions

[Steve Richter <stephenrichter@xxxxxxxxx>]

it this really needed?   PHP can easily convert an SQL result set to JSON.

Would be terrific to apply JSON data to an SQL table.

UPDATE   CUSTOMER a
SET           * =  json  JSON_variable
where        a.csno = inCsno ;

JSON_variable contains an object in json form. Columns and values:
{CSCL:'AB', CSSC:'01'}
SQL would translate the statement to:

UPDATE CUSTOMER a
set  ( CSCL, CSSC ) =  ('AB', '01')
where     a.csno = inCsno ;

or insert the contents of a JSON array into an SQL table.

insert  json_array json_variable
into     customer ;

The same concept.   The JSON array already contains the column names and
values. SQL could match the column names and apply the values.


On Tue, Oct 9, 2018 at 10:42 AM Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

> JSON is a lightweight data-interchange format that is used for asynchronous
> browser–server communication in web applications and web services. JSON is
> a
> human readable text format, based on the JavaScript notation. Compared with
> XML is JSON more compact, less verbose and easier to generate. In this way
> JSON supersedes more and more XML for data exchange. Since Release 7.3 TR 3
> SQL includes all kinds of functions for generating JSON Data. Using these
> functions even complex JSON data can be generated with a single SQL SELECT
> Statement.
>
> ... a new article is published! More detals under the following Link:
> https://developer.ibm.com/articles/sql-json-publishing-functions/
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> "Train people well enough so they can leave, treat them well enough so they
> don't want to.“ (Richard Branson)
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD