Exporting DDL files

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

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

 

1. Click Applications > Application Types > WebSphere enterprise apps in the admin console navigation tree to access the Enterprise applications page.

2. Place a check mark in the check box beside 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 at the top of the page. 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.

   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 to save DDL files to disk. That is, set MIME type = ddl and Extension = ddl.

 

Results

WAS ND v7.0 downloads the DDL file to the specified location.

 

Related tasks

Recreating database tables from the exported table data definition language
Deploy enterprise apps