Recreating database tables from the exported table data definition language

Why and when to perform this task

When an EAR file deploys the target database is selected. Then an appropriate Table.ddl file is created that contains the SQL statements to create the table for the bean. To create your table, using the Table.ddl file for DB2:

Steps for this task

  1. The container-managed bean (CMP) enterprise bean JAR file has a Table.ddl file that the Assembly Toolkit (ATK) generates. Extract the Table.ddl file to a working directory such as C:\temp.
  2. To create your tables using SPUFI, extract the Table.ddl file located in your EJB JAR, to a temporary directory on your work station.
  3. Transfer this Table.ddl file to a data set on your z/OS system.
  4. Specify the data set as the input data set to SPUFI.



Searchable topic ID:   recdbddl
Last updated: Jun 21, 2007 9:56:50 PM CDT    WebSphere Application Server for z/OS, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.websphere.zseries.doc/info/zseries/ae/tdat_recdbddl.html

Library | Support | Terms of Use | Feedback