Deprecated feature: Example: Extraction filter
The following example of an extraction filter extracts category and product information from the CATGROUP, CATGRPDESC, CATGRPREL, CATENTRY, CATENTSHIP, OFFER, CATENTREL, CATGPENREL, CATENTDESC, and ATTRVALUE tables.
For information about the tag structure of this example, see Extraction filter format.
<sqlx>
<!-- **************************** -->
<!-- extract Category information -->
<!-- **************************** -->
<functionDef id="Category" description="Extract Categories"
schemaentity="catgroup">
<paramDef name=":lastRecord" type="string" value="10301"
description="Last record
before loading new data" />
<body>
select * from catgroup where catgroup_id > :lastRecord
</body>
</functionDef>
<execute id="Category" description="Extract Categories"
schemaentity="catgroup">
<param name=":lastRecord" type="string" value="10300"
description="Last record
before loading new data" />
</execute>
<functionDef id="Category Description" description="Extract
Category Descriptions
for a Locale" schemaentity="catgrpdesc">
<paramDef name=":lastRecord" type="string" value="10300"
description="Last record
before loading new data" />
<body>
select * from catgrpdesc where catgroup_id > :lastRecord
</body>
</functionDef>
<execute id="Category Description" description="Extract
Category Descriptions
for a Locale" schemaentity="catgrpdesc">
<param name=":lastRecord" type="string" value="10300"
description="Last record
before loading new data" />
</execute>
<functionDef id="Category Relationship" description="Extract
Category-Relations
for a Locale" schemaentity="catgrprel">
<paramDef name=":lastRecord" type="string" value="10300"
description="Last record
before loading new data" />
<body>
select * from catgrprel where catgroup_id_child >
:lastRecord
</body>
</functionDef>
<execute id="Category Relationship" description="Extract
Category-Relations for
a Locale" schemaentity="catgrprel">
<param name=":lastRecord" type="string" value="10300"
description="Last record
before loading new data" />
</execute>
<!-- *************************** -->
<!-- extract Product information -->
<!-- *************************** -->
<functionDef id="Product" description="Extract Product"
schemaentity="catentry">
<paramDef name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
<body>
select * from catentry where catentry_id > :lastrecord
</body>
</functionDef>
<execute id="Product" description="Extract Product"
schemaentity="catentry">
<param name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
</execute>
<functionDef id="Product Relationship" description="Extract
Product Ship
information" schemaentity="catentrel">
<paramDef name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
<body>
select * from catentrel where catentry_id_child >
:lastrecord
</body>
</functionDef>
<execute id="Product Relationship" description="Extract
Product Ship information"
schemaentity="catentrel">
<param name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
</execute>
<functionDef id="Product Description" description="Extract
Product Description"
schemaentity="catentdesc">
<paramDef name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
<body>
select * from catentdesc where catentry_id > :lastrecord
</body>
</functionDef>
<execute id="Product Description" description="Extract
Product Description"
schemaentity="catentdesc">
<param name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
</execute>
<functionDef id="Product Ship" description="Extract Product
Ship information"
schemaentity="catentship">
<paramDef name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
<body>
select * from catentship where catentry_id > :lastrecord
</body>
</functionDef>
<execute id="Product Ship" description="Extract Product Ship
information"
schemaentity="catentship">
<param name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
</execute>
<functionDef id="Category Product Relationship"
description="Extract Category
Product Relations" schemaentity="catgpenrel">
<paramDef name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
<body>
select * from catgpenrel where catgroup_id > :lastrecord
</body>
</functionDef>
<execute id="Category Product Relationship"
description="Extract Category Product
Relations" schemaentity="catgpenrel">
<param name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
</execute>
<!-- **************************************** -->
<!-- Extract Product Attribute Information -->
<!-- **************************************** -->
<functionDef id="Product Attribute Values"
description="Extract Product Attribute
values for a Locale" schemaentity="attrvalue">
<paramDef name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
<body>
select * from attrvalue where catentry_id > :lastrecord
</body>
</functionDef>
<execute id="Product Attribute Values" description="Extract
Product Attribute values
for a Locale" schemaentity="attrvalue">
<param name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
</execute>
<!-- *************************************************
-->
<!-- Extract Product Price Information
-->
<!-- *************************************************
-->
<functionDef id="Offer" description="Extract Offer"
schemaentity="offer">
<paramDef name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
<body>
select * from offer where catentry_id > :lastrecord
</body>
</functionDef>
<execute id="Offer" description="Extract Offer"
schemaentity="offer">
<param name=":lastrecord" type="string" value="10300"
description="Last record
before loading new data" />
</execute>
</sqlx>