IBM Support

How to convert a DB2 DDL to XML (XSD) format with IBM InfoSphere Data Architect

Question & Answer


Question

How do I convert, save, or export a DB2 DDL to XML (XSD) format with IBM InfoSphere Data Architect?

Answer

Please use the following method to convert DB2 DDL to XML (XSD) format. These steps assume that IBM InfoSphere Data Architect version 7.5.x is installed on the system:

1.- Install the Model Import/Export feature if it is not already installed. See Planning what features to install in the Related URL section to learn more about this and other available features.

      To confirm if the feature is already installed, use the View Installed Packages for the IBM Installation Manager. This is available from the Start menu in the following location:

      Start -> Programs -> IBM Installation Manager -> View Installed Packages

      If installed, the feature will be listed in the Features section for the IBM InfoSphere Data Architect package.



      If the feature is not installed, the Installation Manager can be used to install the feature:

      1.1.- Open IBM Installation Manager
      1.2.- Select option "Modify"
      1.3.- Highlight the IBM InfoSphere Data Architect product and click Next
      1.4.- From the "Features", under "Model Exchange", select "Model Import/Export" and follow the prompts to add this feature

2.- Perform the export. Suggested steps:


      2.1.- Open the IBM InfoSphere Data Architect product, then open or create your Data Design Project.

      2.2.- If the DB2 DDL file is not yet in the Data Design Project (usually in the SQL Scripts folder), use the File / Import... option from the IBM InfoSphere Data Architect product menu to import the file. Select the File System option under the General category as the import source in the Import wizard and follow the prompts to import the DB2 DDL file into your project.

      2.3.- Click on File / Export... option from the IBM InfoSphere Data Architect menu.

      2.4.- Select Data Model Export Wizard under the Data section as the export destination and click Next

      2.5.- Select W3C XML Schema x.y (XSD) as the Model format, where x.y identifies the version (ie. 1.0)

      2.6.- Click the Browse... button to the side of label Model: and select the script corresponding to the DB2 DDL file you want to export

      2.7.- Click the Browse... button to the side of the Export to: label and specify a filename for the resulting file

      2.8.- Click Next

      2.9.- Follow the remaining prompts to complete the export

Related Information

Planning what features to install

[{"Product":{"code":"SS9UM9","label":"IBM InfoSphere Data Architect"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.5.1;7.5.1.1;7.5.2;7.5.2.1;7.5.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21441731

Page Feedback