Re: New Article about SQL JSON Publishing Functions

you mean JSON_TABLE ? Did not know about that function. Will give it a
try.

I use XMLTABLE and it is ok. Have had to spend a lot of time
troubleshooting when it fails because one of the column values is too
long. Error message kind of just says - failed. And XMLTABLE code is
very verbose.



On Tue, Oct 9, 2018 at 5:27 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

That can already be done can't it? The JSON support in SQL is a 2-way
street as is the XML support.

As to PHP sure ... so can RPG, Python, Java, etc. But the point of the
article is to demonstrate the JSON support in SQL.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Oct 9, 2018, at 5:23 PM, Steve Richter <stephenrichter@xxxxxxxxx>

wrote:

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

--
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

--
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