Generating a DB2 DAD File

You generate the DAD file by selecting it as an additional target for standard schema generation.

1. Select Language > Generate schemaFile to open the Generation dialog box.
2. Specify the directory in which to generate the file and select the XML in Database target on the Targets tab.
   
   
   
3. [optional] Click the Options tab, and set any appropriate generation options:

   Option	Description
   Character ending an instruction	Character ending instructions in the SQL file for stored procedures
   Generates procedures deployment	Generation of a SQL script for stored procedures enabling XML data storage and facilitating XML data retrieval
   Path of DAD.dtd	Path of the DTD file installed with IBM DB2 Extender and describing the specific syntax of DAD files
   Schema validation	Validation tag in the DAD files to check the conformity of DAD files with the DAD syntax

4. Click OK to begin the generation.

   The Result dialog box is displayed with the path of the generated DAD, DTD and SQL files.

5. Click Edit to open the generated DAD file in your associated editor:

   • Extract of a DAD file defined with Xcollection as StorageType, and RDB as MappingType:

     
     
     

   • DAD file defined with Xcolumn as StorageType: