Extractor¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡¼ µ¥ÀÌÅ͸¦ ÃßÃâÇÏ·Á¸é, ÃßÃâ ÇÊÅÍ ÆÄÀÏÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡¼ ÃßÃâÇÏ·Á´Â µ¥ÀÌÅ͸¦ ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù. »ç¿ëµÇ´Â ÃßÃâ ÇÊÅÍ´Â ÃßÃâÇϰíÀÚ ÇÏ´Â µ¥ÀÌÅÍ À¯Çü¿¡ µû¶ó ´Þ¶óÁý´Ï´Ù.
ÃßÃâ ÇÊÅÍ ¿¹
´ÙÀ½ ÃßÃâ ÇÊÅÍ ¿¹´Â CATGROUP, CATGRPDESC, CATGRPREL, CATENTRY, CATENTSHIP, OFFER, CATENTREL, CATGPENREL, CATENTDESC ¹× ATTRVALUE Å×ÀÌºí¿¡¼ Ä«Å×°í¸® ¹× »óǰ Á¤º¸¸¦ ÃßÃâÇÕ´Ï´Ù.
<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>
µ¥ÀÌÅÍ ÃßÃâ ¿¹
´ÙÀ½ ¿¹´Â MemberSubsystemFilter.xmlÀ» ÃßÃâ ÇÊÅÍ·Î »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡¼ ±¸¼º¿ø ¼ºê½Ã½ºÅÛ µ¥ÀÌÅ͸¦ ÃßÃâÇÕ´Ï´Ù.
![]()
![]()
![]()
![]()
![]()
java com.ibm.wca.MassExtract.Extract
-filter MemberSubsystemFilter.xml -outfile MemberSubsystemExtracted.xml
-dbname mall -dbuser myname -dbpwd mypassword -customizer MemberSubsystemCustomizer
QWEBCOMM/EXTWCSDTA FILTER(MemberSubsystemFilter.xml)
OUTFILE(MemberSubsystemExtracted.xml) DATABASE(database_name)
SCHEMA(mall) INSTROOT(/QIBM/UserData/WebCommerce/instances/mser)
PASSWD(mypassword)
![]() |