Chapter 6 Working with XML and Databases

Generating a DB2 DAD file

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

To generate an annotated schema file:

1. Select Language→schema File 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 (see DB2 DAD file generation options).
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:
     

Copyright (C) 2008. Sybase Inc. All rights reserved.