Sure
massextract -dbname eglobal01 -dbuser eglobaluser -dbpwd password -filter
PromoFilter.xml -outfile Output.xml
use the following filter file
<sqlx>
<functionDef id="Promogroup" description="Extract Promo groups"
schemaentity="px_group">
<paramDef name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
<body>
select * from px_group where px_group_id > :lastRecord
</body>
</functionDef>
<execute id="Promogroup" description="Extract Promo groups"
schemaentity="px_group">
<param name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
</execute>
<functionDef id="Promopolicy" description="Extract Promo policies"
schemaentity="px_policy">
<paramDef name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
<body>
select * from px_policy where px_policy_id > :lastRecord
</body>
</functionDef>
<execute id="Promopolicy" description="Extract Promo policies"
schemaentity="px_policy">
<param name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
</execute>
<functionDef id="Promogrouppolicy" description="Extract Promo groups policy"
schemaentity="px_grppolicy">
<paramDef name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
<body>
select * from px_grppolicy
</body>
</functionDef>
<execute id="Promogrouppolicy" description="Extract Promo groups policy"
schemaentity="px_grppolicy">
<param name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
</execute>
<functionDef id="Collateral" description="Extract Categories"
schemaentity="collateral">
<paramDef name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
<body>
select * from collateral where collateral_id > :lastRecord
</body>
</functionDef>
<execute id="Collateral" description="Extract Collateral"
schemaentity="collateral">
<param name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
</execute>
<functionDef id="Emspot" description="Extract spots" schemaentity="emspot">
<paramDef name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
<body>
select * from emspot where emspot_id > :lastRecord
</body>
</functionDef>
<execute id="Emspot" description="Extract spots" schemaentity="emspot">
<param name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
</execute>
<functionDef id="Intvsched" description="Extract schedule"
schemaentity="intvsched">
<paramDef name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
<body>
select * from intvsched where intvsched_id > :lastRecord
</body>
</functionDef>
<execute id="Intvsched" description="Extract schedule"
schemaentity="intvsched">
<param name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
</execute>
<functionDef id="Copy" description="Extract copy" schemaentity="colldesc">
<paramDef name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
<body>
select * from colldesc where collateral_id > :lastRecord
</body>
</functionDef>
<execute id="Copy" description="Extract copy" schemaentity="colldesc">
<param name=":lastRecord" type="string" value="1" description="Last
record
before loading new data" />
</execute>
</sqlx>
Post by Mark SheffieldHello Everyone,
Does anyone know how to do a massextract on promotions, espots and adcopy?
Thanks,
mark