Re: 32767 limit - SQL/XML and RPG resources

Nick

Thanks for the links - I'm looking at alternatives for generating XML files. I've started working on the SQL XML Programming book at version 7, and plan on looking at the XML Extenders stuff. The tutorial in the former is OK but hasn't yet addressed my questions. I want to create files from existing data in our tables. I think I'm seeing things like XMLELEMENT, etc., that might do the trick.

I do know that I can use CGIDEV2 for this - we know what the other end needs as the layout of the XML.

So I will definitely study these - anything I get here will have future benefit, as well as now.

Vern

On 4/9/2013 10:59 AM, Nicholas T Lawrence wrote:

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