+

Search Tips   |   Advanced Search

Export DDL files

We can export DDL files in the enterprise bean (EJB) modules of an application.

Export DDL (Table.ddl) files in the EJB modules of an application downloads the DDL files to a location of the choice.

  1. To access the Enterprise applications page...

      Applications | Application Types | WebSphere enterprise applications

    • Place a check mark in the check box for the application and click Export DDL. If the application has no DDL files in any of its EJB modules, then the message No DDL files were found is displayed. If the application has DDL files in its EJB modules, then a page listing DDL files in the format application_name.ear/_module.jar_Table.ddl is displayed.

    • Click on a file in the list and specify the location to which to download the file.

      (iseries) User profile QEJBSVR must have *WX authority to the directory and at least *X authority to all directories in the path specified for the location.

      For Firefox browsers, right-click the file name, select Save Link As, and specify the location to which to download the file.

      Mozilla browsers might display the contents of the Table.ddl file instead of saving the file to disk. To save the file, edit the Helper Application preference settings of the Mozilla browser by adding a new type for DDL and specifying to save DDL files to disk. That is, set MIME type = ddl and Extension = ddl.


Results

The product downloads the DDL file to the specified location.


Related tasks

  • Recreating database tables from the exported table data definition language

  • Enterprise application collection