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





Hi,

With regards to questions on XML, RPG, and DB2 for i, and specifically the
question about the 32767 limit.

There are several SQL/XML and RPG resources that might help:

I published an article in developerWorks last year on RPG and SQL/XML
http://www.ibm.com/developerworks/ibmi/library/i-using-rpg/index.html

The DB2 for i development team collaborated with IBM Lab Services to
publish a white paper on XML
The paper focuses on the differences between the previous DB2 for i XML
solution (DB2 Extenders) and the built-in XML support available in DB2 for
i 7.1. But I think it will also be useful to customers that have never
used the previous product, because the paper covers topics such as RPG, XML
Locators, XML File References, and the XML data model. We tried very hard
to include lots of examples for typical problems, and to explain the
rational behind how the XML support is designed.
http://www.ibm.com/partnerworld/page/stg_ast_sys_wp_db2_xml_extender_capablities


The previously mentioned paper is lengthy, and the material is deep - it
will take a while to read. There much shorter "sales pitch" for SQL/XML
that I published on Mike Cain's Blog. (Although this only talks about SQL
and does not mention RPG)
http://db2fori.blogspot.com/2013/02/integrating-xml-past-present-and-future.html


There are also a number of XML related posts on Dawn May's blog (These
also are focused on SQL and do not cover RPG specific topics)
The most recent of these posts talks about integrating DB2 for i with a web
service. The referenced white paper includes a number of SQL/XML examples.

http://ibmsystemsmag.blogs.com/i_can/xml/

For the specific question about the length of an XML value, the DB2 for i
XML data type does not have a maximum length that is defined by the SQL
language. In other words there is no concept of a declaration such as XML
(32767) or XML(2G).
However, there is a 2 GB limit on the length of an XML value. (Think of it
as a system or platform limitation, rather than a defined length in the SQL
language)

XML Locators are supported, as are XML file references.

I recommend looking at the previously mentioned references for more
information on this topic.


Nick Lawrence
DB2 for IBM i

Success is not final, failure is not fatal: it is the courage to continue
that counts.
- Winston Churchill

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.