We are working on an interface from a Web application to our iSeries. We're in the investigation phase and are new to some of the 'newer tools' on the iSeries. Our plan is to receive an XML file on the iSeries or into a stored procedure on the iSeries, and parse it into our DB2 database. We are on V5R2 and have the Websphere Development Studio Client.
In reading some of the documentation on the Internet, it sounds as though we have almost everything we need to start working on this interface with the exception of something called 'DB2 XML Extender'. It sounds as though we will need DB2 XML Extender if we want to write to the DB2 database, do you know if this is true? Do you know if there is any additional cost associated with this product?
Yes, DB2 XML Extender can be used in the manner you describe. This function is part of the DB2 UDB Extenders for iSeries licensed program product (supposed to cost a little less than the Query/400 product). This LPP is included in the iSeries Enterprise Edition package.You can find more information on this product and function here.
MORE INFORMATION ON THIS TOPIC
Search400.com's targeted search engine: Get relevant information on DB2/400.
The Best Web Links: tips, tutorials and more.
Check out this Search400.com Featured Topic: Database issues resolved
Dig Deeper on DB2 UDB (universal databases)
Related Q&A from Kent Milligan
To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor ... Continue Reading
When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC ... Continue Reading
When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to ... Continue Reading