DB2XML User Guide - XSL-FO, XML to PDF, PostScript, AFP ...

1 DB2 XML user GuideRenderX DB2 XML user GuideCopyright 2011 RenderX, Inc. All rights documentation contains proprietary information belonging to RenderX, and is provided under a license agreement containingrestrictions on use and disclosure. It is also protected by international copyright of continued product development, the information contained in this document may change without notice. The informationand intellectual property contained herein are confidential and remain the exclusive intellectual property of RenderX. If you findany problems in the documentation, please report them to us in writing. RenderX does not warrant that this document is part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means - electronic,mechanical, photocopying, recording or otherwise - without the prior written permission of : 1 (650) 328-8000 Fax: 1 (650) of Contents1.

2 Overview .. on Windows on Windows Vista and Windows DB2 XML .. 72. DB2 XML GUI Source of Stylesheet in Project 163. Data Data Provider for .NET ( ).. Framework Data Provider for Client Data Data 204. Data 21 SQL Database 21 CSV Field is a Mapping Rule?.. XML "Flat" XML XML Using Sequence Sequence Wrappers at the Root Level .. Used by 31 Page 3 user GuideRenderX DB2 XML 32 Expression Types and Data for XML Elements and and Value Converter Definition in Ticket Special Characters and Entities.

3 Mapping Examples For Element Mapping Mapping Examples For Attribute Mapping Mapping Text Mapping Rules in Ticket Instruction Mapping Processing Instruction Mapping Rules in Ticket 395. Job Ticket File File 43 RenderX DB2 XML GuidePage 4 ContentsChapter section contains introductory information about is a collection of libraries for generation of XML output from databases and anotherdata concept is to: the structure of the output XML file using placeholders for datavalues, and; XML files by filling the placeholders using values from input is a common technique applicable to variable data publishing and other template-basedconversions for data streams.

4 In other words, it maps data to certain XML nodes and , DB2 XML supports common SQL databases and CSV (Comma-Separated Values)files as data sources. The full list of supported databases, data source-specific parametersis defined in the Chapter 3, Data Sources. For XML generation, it supports XML attributes,elements, text and processing instruction nodes, conditional generation, value converters tohandle specific tasks, and data grouping to make hierarchical trees from flat input list of features is described in the Chapter 4, Data has a powerful and easy-to use graphical user interface to specify data sources,define mapping rules, and generate XML files.

5 It is described in the Chapter 2, DB2 XML , DB2 XML jobs are defined as DB2 XML tickets. DB2 XML GUI Application usesticket file format to store/load projects. The full description of ticket file format with examplesis available in the Chapter 5, Job Ticket File RequirementsDB2 XML runs on the Windows family of operating system including Windows XP, WindowsVista, Windows 7, and Windows 2008 Server. It requires .NET Framework Version FullProfile to be installed on the target computer. To run DB2 XML installer, you need WindowsInstaller or later (usually it is a part of standard windows installation).If you do not have .NET Framework Version Full Profile installed, DB2 XML installerautomatically detects it and suggests to download and install 5 user GuideRenderX DB2 XML ComponentsTo connect to an SQL database, the appropriate Data Provider should be registered in thesystem.

6 Data Providers that require installation are: To use Oracle as Data Source, one of the following Data Providers should be installed: Oracle Data Provider for .NET / (for Oracle9i Release 2 or later), which canbe downloaded from Oracle's website ..NET Framework Data Provider for Oracle (version 8i Release 3 ( ) or later), whichis included in .NET Framework or later and does not require any installation. Framework , .Net Framework Data Provider for Oracle should be installedseparately. It can be downloaded from Microsoft. To use MySQL as Data Source, MySql Connector/Net should be installed which can bedownloaded from MySQL Oracle Data Providers require Oracle Client to be installed.

7 For more informationon Oracle Data Access Components, visit Oracle Data Provider for . is distributed as a singe ZIP archive file. For proper running, the application requiresa license file, which can be obtained from StepsTo install DB2 XML on your Windows operating the Windows Explorer or another file manager, go to the directory which contains the ex-tracted files and run either by double-clicking it or by selecting it and pressingthe Enter key. It will check for prerequisites for DB2 XML and suggest to install the applic-able components, if necessary, and then run DB2 XML the wizard to install prerequisites and then DB2 XML on your file obtained from RenderX to the installation folder (%Program-Files%\RenderX\DB2 XML by default).

8 On Windows XPDB2 XML requires an administrator account to install it on Windows XP. In step 2, is run from a non-administrator account, it will open the "Install Program As OtherRenderX DB2 XML GuidePage 6 Chapter 1: OverviewUser" dialog. Choose an administrator user from the drop down list and specify password forthe selected "Install As" on Windows Vista and Windows 7To install DB2 XML to a Windows Vista or Windows 7 machine from a user account, you needto have UAC ( user Account Control) to be turned on. DB2 XML installer opens "Install As"dialog, where you need to choose an administrator user and installed froman administrator account, the DB2 XML installer may request elevation depending on DB2 XMLTo uninstall DB2 XML, go to Start -> Control Panel -> Programs and Features (Add or RemovePrograms in Windows XP).

9 RenderX DB2 XML is located in the list of programs. Right-clickit and then click "Uninstall". For Windows XP, an administrator account is needed to uninstallDB2 XML. For Windows Vista/7, the elevation dialog is prompted when uninstalling DB2 XMLfrom a user 7 user GuideRenderX DB2 XML 1: OverviewChapter GUI SourcesThe Data Source panel contains data source connection Source SectionThe first step of connection definition is the data source selection. DB2 XML supports SQLD atabases and CSV files as data sources. If the SQL Database data source type is selected,it is necessary to select the data provider. If the CSV file data source type is selected, theCSV file should be selected for further data source selection, a specific database connection options table 9 user GuideRenderX DB2 XML detailed information on supported data sources and options descriptions, see theChapter 3, Data Source ParametersFigure File ParametersFigure Database ParametersFor SQL databases, it is also possible to provide a complete connection string instead ofsetting up parameters manually.

10 To use the connection string, check the Provide ConnectionString radio DB2 XML GuidePage 10 Chapter 2: DB2 XML GUI ApplicationFigure Connection String for SQL databasesAfter successful connection to the specified database, to get database fields for furthermapping definition, the SQL Query should be defined and fields should be FieldsAfter execution of the "List Fields" command, the data fields appear in Mapping listPage 11 user GuideRenderX DB2 XML 2: DB2 XML GUI ApplicationFor the CSV files, if the Has Header option set to True, and the CSV file contains headers,the fields list shows the column headers from the CSV file; in the opposite case, the fieldslist shows ColumnNumber for each file fields list if Has header=TrueFigure file fields list for Has Header=FalseFor SQL database fields, the list shows only table field names (as shown in the "Fields List"figure above), if the SQL query selects only one table from the database, and , if the SQL query selects more than one table from the DB2 XML GuidePage 12 Chapter 2: DB2 XML GUI ApplicationFigure list for multiple tablesThe fields are draggable and can be moved to the Mapping Rules tree to be added as mappingrule RulesMapping is a set of rules to define structure of the final XML file to be generated.