× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. July 2021

Re: RPG and XML or JSON

Hello;

noxDb works fine on 7.1 - both producing and consuming JSON ( and XML and
SQL)

However the client RPG code can not use the DATA-GEN until 7.2 where it was
introduced in RPG ( don't know if a TR will enable it in 7.1) - so noxDb
do not have the limitation - it is only the level of RPG.

The current version restores directly on 7.1
https://github.com/sitemule/noxDB/blob/master/release/release.savf

Read more here:
https://github.com/sitemule/noxDB

On Tue, Jul 20, 2021 at 3:37 PM Dave <dfx1@xxxxxxxxxxxxxx> wrote:

In case anyone else comes this way, just thought I'd say that the YAJL
solution works fine with V7R1





date: Thu, 20 May 2021 19:22:32 +0000 (UTC)
from: Mark Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>
subject: Re: RPG and XML or JSON

Jon,
The OP is on IBMi 7.1, so although DATA-GEN existed in 7.1, I do not
thing
DATA-INTO was introduced until IBMi 7.2 ...?? :-o
Hence, the need for other tooling like NOXDB ...?
Just saying ...
Mark S. Waterbury
On Thursday, May 20, 2021, 03:13:14 PM EDT, Jon Paris <
jon.paris@xxxxxxxxxxxxxx> wrote:

YAJLINTO for DATA-INTO and YAJLGEN for DATA-GEN both shipped with
Scott's
YAJL library.

Both work beautifully and are very fast.


Jon Paris

On May 20, 2021, at 2:22 PM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

Jon,
Then please show me a handler that is already written for consuming any
JSON data.
I haven't found any.

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)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon
Paris
Sent: Donnerstag, 20. Mai 2021 17:40
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: RPG and XML or JSON

You don't have to "write any programs" Birgitta - they are already
written.


Jon Paris

On May 20, 2021, at 1:39 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

I'd have a look at the SQL Functions that are available (for
generating and consuming XML and JSON).
IMHO it is much easier to use this functions in composition with
embeeded SQL than writing any handler programs in composition with
DATA-GEN and DATA-INTO and/or using YAJL.

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)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Dave
Sent: Mittwoch, 19. Mai 2021 22:52
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: RPG and XML or JSON

Hi,

I need help to decide if? the YAJL Open Source JSON Tool is the right
choice for us.

I'm working on a new application that will accept and return data in
JSON format.
The company that will be sending the data already receives it in XML
format from their client and converts it to JSON that it sends to us.
Then, on receiving our JSON response, it will convert it back to XML
for the client.
We are currently only used to dealing with XML formatted data only and
have no JSON experience. We have a couple of possibilities that would
enable us to convert the data from JSON to XML and back which would be
a shame to have to do.

We need to weigh up the cost between implementing a solution that we
know how to do and one that we don't but looks better.
How can I go about estimating the time to install and deploy the YAJL
solution? Is it an easy solution to implement?
Is there any way of estimating the effect on the response times if we
were to convert the JSON to XML? That would mean 4 conversions of the
data from XML to JSON and back.

Thanks!
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link:
https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com


------------------------------

message: 2
date: Thu, 20 May 2021 15:05:41 -0500
from: Scott Klement <sk@xxxxxxxxxxxxxxxx>
subject: Re: RPG and XML or JSON

YAJLINTO and YAJLDTAGEN are the data-into and data-gen programs,
respectively.

YAJLGEN is a bit older and serves a different purpose -- it generates
RPG data structure definitions that match a JSON file.

--
Scott Klement
sk@xxxxxxxxxxxxxxxx

On 5/20/2021 2:13 PM, Jon Paris wrote:
YAJLINTO for DATA-INTO and YAJLGEN for DATA-GEN both shipped with
Scott's YAJL library.

Both work beautifully and are very fast.


Jon Paris




------------------------------

message: 3
date: Thu, 20 May 2021 17:11:41 -0400
from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
subject: Re: RPG and XML or JSON

Yes - I noticed - but I was responding to Birgitta - her SQL solution is
not available on 7.1 either.


Jon

On May 20, 2021, at 3:22 PM, Mark Waterbury <
mark.s.waterbury@xxxxxxxxxxxxx> wrote:

Jon,
The OP is on IBMi 7.1, so although DATA-GEN existed in 7.1, I do not
thing DATA-INTO was introduced until IBMi 7.2 ...? :-o
Hence, the need for other tooling like NOXDB ...
Just saying ...
Mark S. Waterbury
On Thursday, May 20, 2021, 03:13:14 PM EDT, Jon Paris <
jon.paris@xxxxxxxxxxxxxx> wrote:

YAJLINTO for DATA-INTO and YAJLGEN for DATA-GEN both shipped with
Scott's YAJL library.

Both work beautifully and are very fast.


Jon Paris

On May 20, 2021, at 2:22 PM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

Jon,
Then please show me a handler that is already written for consuming
any
JSON data.
I haven't found any.

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)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon
Paris
Sent: Donnerstag, 20. Mai 2021 17:40
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: RPG and XML or JSON

You don't have to "write any programs" Birgitta - they are already
written.


Jon Paris

On May 20, 2021, at 1:39 AM, Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx

wrote:

I'd have a look at the SQL Functions that are available (for
generating and consuming XML and JSON).
IMHO it is much easier to use this functions in composition with
embeeded SQL than writing any handler programs in composition with
DATA-GEN and DATA-INTO and/or using YAJL.

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)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Dave
Sent: Mittwoch, 19. Mai 2021 22:52
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: RPG and XML or JSON

Hi,

I need help to decide if the YAJL Open Source JSON Tool is the right
choice for us.

I'm working on a new application that will accept and return data in
JSON format.
The company that will be sending the data already receives it in XML
format from their client and converts it to JSON that it sends to us.
Then, on receiving our JSON response, it will convert it back to XML
for the client.
We are currently only used to dealing with XML formatted data only
and
have no JSON experience. We have a couple of possibilities that would
enable us to convert the data from JSON to XML and back which would
be
a shame to have to do.

We need to weigh up the cost between implementing a solution that we
know how to do and one that we don't but looks better.
How can I go about estimating the time to install and deploy the YAJL
solution? Is it an easy solution to implement?
Is there any way of estimating the effect on the response times if we
were to convert the JSON to XML? That would mean 4 conversions of the
data from XML to JSON and back.

Thanks!
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post
a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate link:
https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post
a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our
affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com



------------------------------

message: 4
date: Thu, 20 May 2021 17:12:33 -0400
from: Jon Paris <jon.paris@xxxxxxxxxxxxxx>
subject: Re: RPG and XML or JSON

Thanks for the correction Scott - I always gert the two names mixed up.


Jon Paris

On May 20, 2021, at 4:05 PM, Scott Klement <sk@xxxxxxxxxxxxxxxx>
wrote:

YAJLINTO and YAJLDTAGEN are the data-into and data-gen programs,
respectively.

YAJLGEN is a bit older and serves a different purpose -- it generates
RPG data structure definitions that match a JSON file.

--
Scott Klement
sk@xxxxxxxxxxxxxxxx

On 5/20/2021 2:13 PM, Jon Paris wrote:
YAJLINTO for DATA-INTO and YAJLGEN for DATA-GEN both shipped with
Scott's YAJL library.

Both work beautifully and are very fast.


Jon Paris


--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com



------------------------------

Subject: Digest Footer

--
This is the RPG programming on IBM i (RPG400-L) digest list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com


------------------------------

End of RPG400-L Digest, Vol 20, Issue 214
*****************************************


--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.