Re: DB2 Native XML

To add to Charles' advice and hammer the idea down a little harder--

Be aware that when you say DB2, that you are talking about 3 related (somewhat) yet different versions of it.

If you just look up DB2 online, you are likely to run into stuff that applies only to the LUW (Linux/Unix/Windows) version. You canNOT rely on that information to be relevant to the IBM i. You'll end up going down endless yellow brick roads!! And your name is NOT Dorothy!

So stick with the links Charles has given you - or in your Google seraches, include hints like "AS/400", "iSeries", "IBM i" - the latter with quotes can help.

I push on this because your question have had an understandable and undeniable feel of coming from looking at non-IBM i information.

Having said that, there are documents that give cross-product DB2 information - probably in the .../software/i/db2 site - look for white papers and articles and the like.

So keep on having fun, man!! You seem to be getting a lot out of this platform, it's great to hear what you're up to.

Vern

On 11/23/2015 11:37 AM, Charles Wilt wrote:

DB2 Viper was the code name for DB2 for LUW v9

For DB2 for i, Look at the "What's new" in the SQL Reference
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/db2/rbafzwhatsnew.htm
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_71/db2/rbafzwhatsnew.htm
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_61/db2/rbafzwhatsnew.htm

Addition info here
http://www-03.ibm.com/systems/power/software/i/db2/

Lastly, the developerworks wiki for the IBM TR levels
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM+i+Technology+Updates/page/DB2+for+i+-+Technology+Updates

For XML, I'm guessing you'll need at least v7r1 TR6
http://db2fori.blogspot.com/2013/02/integrating-xml-past-present-and-future.html

Charles

On Mon, Nov 23, 2015 at 12:03 PM, Rob <rob.couch@xxxxxxxxxxxxxx> wrote:

Hello everyone,

I now have a full application online that is able to navigate through all
of the libraries on the server, all of the tables in a library, and all of
the fields of a table. I will be adding query support soon... I love the
speed of the IBM i and php. My scripts pop on the screen and I am running
right along side our production environment, which gets hammered.

I am reading about the Native XML support in DB2 code named Viper and how
there is mention of an article to Fire Up The Hybrid Engine.

Is Native XML support a default part of v6r1... how does one check to see
if it is installed... via green screen or php?

I am building an API that is sent an xml file... so I want to stuff its
values into a Table... then process the information...

It seems that every time I read about a feature in DB2 I should be
using... there is no mention of how to check to see if that feature is
already available. About the only thing I find is a complicated method of
installing said feature, which is out of my abilities at the moment.

If I can check to see if Native XML is support in my DB2, then I can march
on, otherwise this gives me a grand excuse to demand I have ssh access to
the server, so that I can get the xml support turned on.

Thank You,
Rob

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.