To extract data from a database using the massextract utility,
you must specify the data that you want to extract from the database
using an extraction-filter file. The extraction filter that you use
depends on the type of data that you want to extract.
Procedure
- Create an extraction
filter. For more information see example of an extraction
filter.
- Run the massextract
utility. Specify the name of the properties file created in
step 1 as the value of the customizer parameter of the massextract
utility.
The data extracted from the
database is in an XML file. The XML file contains a DTD that defines
the data in the file and includes the data extracted.
Each database
table row is extracted into its own XML tag. Each element of the tag
contains the column values for the row. The following example tag
is an extracted row from the CATGRPDESC database table:
<catgrpdesc
language_id="-1"
catgroup_id="51201059000"
name="Fancy"
shortdescription="short description for Fancy"
longdescription="long description for Fancy"
published="1"
/>