DBEXPORT - Direct DB2 Data Export into XML

Management and specialist departments require up-to-date and consistent data to make trend-setting decisions. Most reliable business data is provided by the data base itself. On the one hand queries should provide homogeneous information in standardised format and regular time intervals. On the other hand, the processing of data base queries must be possible for different departments at any time on short notice. Mostly, inhouse data base specialists are in charge of data provision but because of lack of time they cannot process it as flexible as favoured by the specialist departments.


i-effect^® *DBEXPORT is a native iSeries application for direct DB2 data export into spreadsheet formats (XML, XLS, CSV, HTML, TXT und PDF) on IBM System i5 ( iSeries, AS/400 ). It offers your associates any report at any time and for every defined event - per push technology straightforward into their inboxes. The PC output files consist of the full range of formatting and functional features.

Conventional software converts DB2 files into spooled files before passing them on to the output queue for further format conversion or for printing. Due to the flat text format of the spooled file, the tabular structure of DB2 files is getting lost through conversion and has to be re-built afterwards in order to allow further processing. Therefore, it is necessary that a license program for database queries be already installed on the system (e.g. IBM Query für i5/OS).

What makes i-effect^® *DBEXPORT special is the direct conversion from DB2 into XML, Excel XLS, CSV, HTML, TXT and PDF per push-technology. A data base query can be processed in equal measure through a defined file name, query or SQL statement. You can select every *DBEXPORT call from the i-effect^® logbook and re-process every pre-defined or saved query and SQL query statements.

Optimal added value for your reporting workflow is achieved by automation with i-effect^® module *SERVER which automates all i-effect^® functions. DB2 files are converted event-driven or according to a schedule and distributed to the recipient. Regular, one-time or rather time-critical exports are guaranteed even in case of sudden or longer shortfall of staff. The conversion process runs in the background ( submit job ) with ideal performance and velocity.

To distribute your reports to their recipients, you may combine *DBEXPORT with all of i-effect^®'s communication modules: *EMAIL, *FAX, *FTP, *AS2, *TELEBOX, *OFTP.