Re: DB2 Native XML

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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.