As the ad hoc index definition does not define any meta data, the data is not included when the schema is extracted. The Ad Hoc Index menu in the Ad Hoc Index Browser provides the Save Ad Hoc Definitions command, which enables you to save ad hoc index definitions to an XML file; for example, so that you can load your ad hoc definitions into a new version of JADE when you have upgraded to a new JADE version and loaded your schema dat instead of having to redefine each ad hoc index. For details about loading ad hoc index definitions into a schema, see "Loading Ad Hoc Definitions".
To save ad hoc index definitions to an XML file
In the Ad Hoc Index Browser, select the Save Ad Hoc Definitions command from the Ad Hoc Index menu.
The common Save As dialog is then displayed.
Select the source location and specify the name of the XML file prefix to which you want to save the ad hoc index definitions.
Click the Save button.
All ad hoc index definitions in the file are then saved to the specified XML file. (All ad hoc definitions in your schema are saved to the file; that is, you cannot save one definition only.)
An example of an ad hoc index definitions XML file is shown in the following example.
<?xml version="1.0" ?>
<AdHocIndexDocument>
<AdHocIndex Name="A1a2ByAmount" Schema="OdbcTestSchema" MembershipClass="A1A2">
<Key Name="amount" Descending="false" CaseInsensitive="false" SortOrder="0" />
</AdHocIndex>
<AdHocIndex Name="BigDataByDate" Schema="OdbcTestSchema" MembershipClass="BigData">
<Key Name="tranDate" Descending="false" CaseInsensitive="false" SortOrder="0" />
<Key Name="amount" Descending="false" CaseInsensitive="false" SortOrder="0" />
</AdHocIndex>
</AdHocIndexDocument>