Exporting DDL files

You can export data definition language (DDL) files in the enterprise bean (EJB) modules of an application.

About this task

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

Procedure

  1. Click Applications > Application Types > WebSphere enterprise applications in the administrative console navigation tree to access the Enterprise applications page.
  2. 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.
  3. Click on a file in the list and specify the location to which to download the file.

    [IBM i] 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.

    Tip: 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 that you want 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.