Home > Ask the AS/400 Experts > iSeries Web Development Questions & Answers > Is DB2 extender my best option?
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

Is DB2 extender my best option?

Jim Mason EXPERT RESPONSE FROM: Jim Mason

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 28 October 2004
Is DB2 extender my best option?

I have a project to send and receive XML documents (invoice and purchase order information using the iSeries) to a vendor with a time frame of three to four months. The vision is to do this eventually for the other vendors as well. I've heard so far that DB2 extender is my best solution given the time frame I have. Do you agree? I know it's quite expensive, given that Java is free, but since I already got purchase approval my only concern is if it will be able to do even the complicated XML documents.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
Web Development
IBM i shop boosts online sales with RPG-based Web platform
Migrating from RPG to EGL on IBM i
Groovy programming on IBM i
Running PHP open source applications: NOBODY needs authority
Zend Web software teams up with IBM System i
The best technologies and tools for System i programmers in 2009
Seven IBM i project lessons learned in 2008
AS/400 lessons from the past, present, and future: A holiday tale
Application modernization strategies for System i
RPG application modernization for i5

iSeries Java programming
Groovy programming on IBM i
EGL Rich UI on IBM i: Do you Dojo?
Programming for the Web on the IBM i, what is possible
Database performance comparisons on IBM i
Database drivers on the i: MySQL vs. IBM Toolbox
How to: Output SQL script to a text file from an AS/400
Application modernization for the iSeries: Why bother?
JDBCODBC functionality -- Java to Excel for complex workbooks
Necessity leads to iSeries Watchdog development
Accessing AS/400 data using Excel ODBC drivers
iSeries Java programming Research

iSeries Web Development
JDBCODBC functionality -- Java to Excel for complex workbooks
Accessing AS/400 data using Excel ODBC drivers
IBM WebSphere Studio Application Developer error
Database pooling on iSeries
Connecting WebSphere to AS/400 for image retrieval
Retrieving the value selected by a user
Condense ILE service program procedures
WebSphere error during login process
Connecting WebSphere to a DB2 database
WebFacing error: User ID or password invalid

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
WebSphere Development Studio Client (WDSC)  (Search400.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


I would not look at any programming with a parser if I can avoid it. I also would avoid using DB2 Extender if possible. IF your application is simple enough, you can use the WDSC XML tools to generate an XML application to select data and create XML documents or store XML documents in the database. Most of the time, the RIGHT XML tools in WDSC will generate these applications for you. The WRONG XML tools in WDSC can do the same thing with more customized mapping support (requiring DB2Extender). ou may want to read a recent article I wrote on this, Create a Web application to build XML data from SQL data.

If your application doesn't fit this, it's probably smart to pay an outside consultant to quickly create a simple Java parser to meet your specific needs IF needed. We do XML development for iSeries customers all the time. MOST XML applications I've come across though DO fit the simple XML tools in WDSC very well and, done correctly, DON'T require DB2Extender.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Check out these Best Web Links on Web development.

Ask the Experts yourself: Our Web development gurus are waiting to answer your questions.

Ask your Web development & WebSphere questions -- or help out your peers by answering them--in our WebSphere & Web Development Forum.




Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts