Well I don't think VBScript runs natively nor does it do XML that I know of very well.

There is however VB.Net and C# and they now run natively on IBM i.

On the PC side PowerShell can also shred that XML I believe.

Send over a sample XML with an overview of desired result and I'll have a look.

I would also be remiss in not telling you about out Automate and GoAnywhere software product which could this work easily as well.

Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com


-----Original Message-----
From: Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>
Sent: Saturday, February 23, 2019 6:57 AM
To: 'RPG programming on the IBM i (AS/400 and iSeries)' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: Richard Schoen <Richard.Schoen@xxxxxxxxxxxxxxx>
Subject: RE: Large XML file processing via XMLTABLE

Running VBScript on the I?


Paul


-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jose Perez
Sent: Friday, February 22, 2019 6:27 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: Richard Schoen <Richard.Schoen@xxxxxxxxxxxxxxx>
Subject: Re: Large XML file processing via XMLTABLE

Ok let's think out of the box maybe this work for you. Since you said that converting your data into csv would be better for you then why not calling a vbscript from the IBM I that convert your ifs file into CSV and then you read your CSV in any way you want. FYI Vbscript is able to convert XML data into CSV.

On Fri, Feb 22, 2019, 6:24 PM Jose Perez <joseenocperez.jp@xxxxxxxxx wrote:

Ok let's think out of the box maybe this work for you. Since you said
that converting your data into csv would be better for you then why
not calling a vbscript from the IBM I that convert your ifs file into
CSV and then you read your CSV in any way you want. FYI Vbscript is
able to convert XML data into CSV.

On Fri, Feb 22, 2019, 4:57 PM John Yeung <gallium.arsenide@xxxxxxxxx
wrote:

On Fri, Feb 22, 2019 at 4:28 PM Richard Schoen via RPG400-L
<rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

I would imagine that Python, PHP or Java on IBMi would handle this
OK
as well.

Java's certainly worth a try. My personal experience has been that
Python on the PC is significantly faster than Python on the i. I
suppose part of that could be that our i is on the wimpy side by
today's standards.

In any case, regardless of speed, I believe all of those languages
support SAX parsing fairly easily, and can talk directly to the
database. Especially if this is going to be a recurring thing, where
huge XML files are automatically deposited on the i, these are worth
looking at. Also, there is the PASE port of Mono, so .NET languages
are a possibility as well.

But, being as this is the RPG list, I suppose XML-SAX is probably
going to be tried before exploring whole other languages. I will say
that I would expect XML-SAX in RPG to be faster executing than SAX in
other languages. But if you don't already know how to do it in RPG,
it would probably be easier to implement in almost any other language.
And who knows, maybe Java would actually perform competitively.

John Y.
--
This is the RPG programming on the IBM i (AS/400 and iSeries)
(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@xxxxxxxxxxxx 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 the IBM i (AS/400 and iSeries) (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@xxxxxxxxxxxx for any subscription related questions.

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






This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].