Recreating database tables from the exported table data definition language

When the WebSphere Application Server deployment tooling deploys an EJB jar file containing container-managed persistence (CMP) enterprise beans, it selects the target database and creates a corresponding Table.ddl file. This file contains the SQL statement necessary to generate the database table for your CMP beans.

About this task

The following steps demonstrate the process for creating tables in DB2.

Procedure

  1. Extract the Table.ddl file from your CMP enterprise bean JAR file and save it on your database server.
    • Save the file to a temporary directory on your work station. Transfer the file to a data set on your DB2 for z/OS system.
  2. Run the Table.ddl file.
    • Specify the data set as the input data set to SPUFI, and run the program.

Results

The database tables are created.
Task topic Task topic    

Terms and conditions for information centers | Feedback

Last updatedLast updated: Aug 31, 2013 12:02:36 AM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=pix&product=was-nd-zos&topic=recdbddl
File name: tdat_recdbddl.html