»óǰ ¾îµå¹ÙÀÌÀú °Ë»ö °ø°£À» ¼öµ¿À¸·Î ÀÛ¼ºÇÏ·Á¸é īŻ·Î±× ¼ºê½Ã½ºÅÛ ¹× °ü·Ã µ¥ÀÌÅͺ£À̽º ½ºÅ°¸¶¸¦
¿ÏÀüÈ÷ ÀÌÇØÇϰí ÀÖ¾î¾ß ÇÕ´Ï´Ù. °Ë»ö °ø°£Àº ´ÙÀ½ÀÇ Ç¥ÁØ WebSphere Commerce Å×ÀÌºí¿¡¼
ÃßÃâÇÑ Á¤º¸°¡ µé¾î ÀÖ´Â Ãß°¡ µ¥ÀÌÅͺ£À̽º Å×À̺í·Î ±¸¼ºµË´Ï´Ù.
ÁÖ: ÀÌ Á¤º¸´Â
iSeries »ç¿ëÀÚ¸¦ Àû¿ëÇÏÁö ¾Ê½À´Ï´Ù. ´ë½Å
XML ÆÄÀÏÀ» »ç¿ëÇÏ¿© »óǰ ¾îµå¹ÙÀÌÀú °Ë»ö °ø°£ ÀÛ¼ºÀ» ÂüÁ¶ÇϽʽÿÀ.
»óǰ ¾îµå¹ÙÀÌÀú °Ë»ö ±â´ÉÀ» Áö¿øÇϱâ À§ÇØ ÇÊ¿äÇÑ µ¥ÀÌÅͺ£À̽º Å×À̺íÀ» ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½ ´Ü°è°¡ ÇÊ¿äÇÕ´Ï´Ù. ´ÙÀ½ ´Ü°è¿¡¼´Â Å×À̺í, º¸±â ¹× ÇØ´ç »öÀÎÀ¸·Î ±¸¼ºµÈ °£´ÜÇÑ °Ë»ö °ø°£À» ÀÛ¼ºÇϱâ À§ÇÑ °ßº» SQL¹®ÀÌ Á¦°øµË´Ï´Ù. ¸í·É¹®¿¡´Â »óǰ ¹× Ä«Å×°í¸® ID¿Í °°ÀÌ »ç¿ëÀÚ ÀÚ½ÅÀÇ µ¥ÀÌÅÍ·Î ¹Ù²Ù¾î¾ß ÇÏ´Â µ¥ÀÌÅͰ¡ Æ÷ÇԵ˴ϴÙ. ¼³¸íÀ» À§ÇØ µ¥ÀÌÅͰ¡ ¿©±â¿¡ Ç¥½ÃµË´Ï´Ù. SQL¹®¿¡¼ µ¥ÀÌÅ͸¦ ¸®ÅÏÇÏ´Â °æ¿ì, ƯÈ÷, ÀÌ µ¥ÀÌÅͰ¡ ³ªÁß ´Ü°è¿¡¼ ÀÔ·ÂÀ¸·Î »ç¿ëµÇ´Â °æ¿ì, ¸®ÅÏµÈ µ¥ÀÌÅÍ´Â SQL¹® ´ÙÀ½¿¡ ´ë°ýÈ£ ¾È¿¡ ±½ÀºÃ¼·Î Ç¥½ÃµË´Ï´Ù.
ÁÖ: ÀÌ ÆÄÀÏÀÇ ¿¹´Â DB2¿¡¸¸ ÇØ´çµË´Ï´Ù. Oracle »ç¿ëÀÚ´Â Oracle ƯÁ¤ SQL¹®¿¡ ´ëÇÑ ÀûÇÕÇÑ °ßº» À¯Æ¿¸®Æ¼¸¦ ÂüÁ¶ÇØ¾ß ÇÕ´Ï´Ù.
db2 "select distinct(attribute_id),language_id,attrtype_id,name
from attribute
where
catentry_id in(select catentry_id from catgpenrel where
catgroup_id=1)
order by attribute_id"
db2 create table ICT1
( PRRFNBR int not null,
PRNBR varchar(64) );
db2 create table ICTDESC1
( PRRFNBR int not null,
PRSDESC varchar(254),
AVAILABLE int not null,
PRTHMB varchar(254),
XMLDETAIL long varchar,
LANGUAGE_ID int not null,
F_COLOR char(254),
F_SIZE int,
Constraint ictd1_pk
primary key (prrfnbr,language_id) );
db2 create view ICV1_NULL as select ic.prrfnbr,
ic.prnbr,
icd.PRSDESC,
icd.AVAILABLE,
icd.PRTHMB,
icd.XMLDETAIL,
icd.LANGUAGE_ID,
icd.F_COLOR,
icd.F_SIZE,
p.ipsgnbr,
p.storeid,
p.ppprc,
p.setccurr
from ICTPRICES p, ICT1 ic, ICTDESC1 icd
where ic.PRRFNBR=p.CATENTRY_ID and
ic.PRRFNBR=icd.PRRFNBR and
p.IPSGNBR is NULL;
db2 "insert into icrootcat
(rootcategoryid,catgroup_id,pfpasync,pfreq,tablename,
lastmodified)
values
(1,1,0,1,'ICV1_','2000-06-15-14.48.25.686000')"
db2 "insert into icexplfeat
(featureid,catgroup_id,columnname,length,datatype,keysequence,
nullable,location,included,relevance)
values
(1, 1,'F_COLOR',254,'com.ibm.commerce.datatype.DsString',
0,1,1,1,0);
db2 "insert into icexplfeat
(featureid,catgroup_id,columnname,length,datatype,keysequence,
nullable,location,included,relevance)
values
(2, 1,'F_SIZE',4,'com.ibm.commerce.datatype.DsInteger',
0,1,1,1,0);
db2 "insert into icexplfeat
(featureid,catgroup_id,columnname,length,datatype,keysequence,
nullable,location,included,relevance)
values
(3, 1,'PRRFNBR',4,'com.ibm.commerce.datatype.DsInteger',
1,0,0,1,0);
db2 "insert into icexplfeat
(featureid,catgroup_id,columnname,length,datatype,keysequence,
nullable,location,included,relevance)
values
(4,1,'PRNBR',254,'com.ibm.commerce.datatype.DsString',
0,0,0,1,0);
db2 "insert into icexplfeat
(featureid,catgroup_id,columnname,length,datatype,keysequence,
nullable,location,included,relevance)
values
(5, 1,'PRSDESC',254,'com.ibm.commerce.datatype.DsString',
0,1,3,1,0);
db2 "insert into icexplfeat
(featureid,catgroup_id,columnname,length,datatype,keysequence,
nullable,location,included,relevance)
values
(6, 1,'PRTHMB',254,'com.ibm.commerce.datatype.DsImage',
0,1,3,1,0);
db2 "insert into icexplfeat
(featureid,catgroup_id,columnname,length,datatype,keysequence,
nullable,location,included,relevance)
values
(7, 1,'XMLDETAIL',32700,'com.ibm.commerce.datatype.DsURLLink',
0,1,3,1,0);
db2 "insert into icexplfeat
(featureid,catgroup_id,columnname,length,datatype,keysequence,
nullable,location,included,relevance)
values
(8, 1,'PPPRC',16,'com.ibm.commerce.datatype.DsCurrency',
0,0,2,1,0);
db2 "insert into icexplfeat
(featureid,catgroup_id,columnname,length,datatype,keysequence,
nullable,location,included,relevance)
values
(9, 1,'AVAILABLE',4,'com.ibm.commerce.datatype.DsInteger',
0,0,3,1,0);
db2 "insert into icexpldesc (featureid,language_id,name,
unitofmeasure,description,elaboration,scale,precision)
values
(1, 1,'»ö»ó','','»ö»ó',NULL,0,0);
db2 "insert into icexpldesc (featureid,language_id,name,
unitofmeasure,description,elaboration,scale,precision)
values
(2, 1,'Å©±â','','Å©±â',NULL,0,0);
db2 "insert into icexpldesc (featureid,language_id,name,
unitofmeasure,description,elaboration,scale,precision)
values
(3, 1,'CATENTRY_ID','','»óǰ ÂüÁ¶ ¹øÈ£',NULL,0,0);
db2 "insert into icexpldesc (featureid,language_id,name,
unitofmeasure,description,elaboration,scale,precision)
values
(4, 1,'PARTNUMBER','','»óǰ ¹øÈ£/SKU',NULL,0,0);
db2 "insert into icexpldesc (featureid,language_id,name,
unitofmeasure,description,elaboration,scale,precision)
values
(5, 1,'SHORTDESCRIPTION','','°£´ÜÇÑ ¼³¸í',NULL,0,0);
db2 "insert into icexpldesc (featureid,language_id,name,
unitofmeasure,description,elaboration,scale,precision)
values
(6, 1,'THUMBNAIL','','½æ³×´× À̹ÌÁö ÆÄÀÏ',NULL,0,0);
db2 "insert into icexpldesc (featureid,language_id,name,
unitofmeasure,description,elaboration,scale,precision)
values
(7, 1,'XMLDETAIL','','XML ÀÚ¼¼ÇÑ Á¤º¸',NULL,0,0);
db2 "insert into icexpldesc (featureid,language_id,name,
unitofmeasure,description,elaboration,scale,precision)
values
(8, 1,'STANDARDPRICE','','MSRP',NULL,2,15);
db2 "insert into icexpldesc (featureid,language_id,name,
unitofmeasure,description,elaboration,scale,precision)
values
(9, 1,'AVAILABLE','','ÆÇ¸Å °¡´É ¿©ºÎ',NULL,0,0);
db2 "insert into ict1 (select catentry_id,partnumber
from catentry where catentry_id in (select catentry_id
from catgpenrel where catgroup_id=1))"
db2 "import from catentry.del of del insert into ict1"
db2 "insert into ictdesc1 (PRRFNBR,PRSDESC,AVAILABLE,
PRTHMB,XMLDETAIL,LANGUAGE_ID)
(select c2.catentry_id,c2.shortdescription,c2.available,
c2.thumbnail, c2.xmldetail, c2.language_id
from catentry c1, catentdesc c2
where c1.catentry_id=c2.catentry_id
and c2.language_id=-9
and c2.published=1
and (c2.catentry_id in (select catentry_id from catgpenrel
where catgroup_id=1)))"
db2 "update ictdesc1 set F_Color =
(select stringvalue from attrvalue
where ictdesc1.prrfnbr=attrvalue.catentry_id
and ictdesc1.language_id=attrvalue.language_id
and attrvalue.attribute_id in
(select attribute_id from attribute
where name = '»ö»ó')
and attrvalue.language_id=-9
and attrvalue.catentry_id in
(select catentry_id from catgpenrel
where catgroup_id=1))
where language_id=-9"
db2 "update ictdesc1 set F_Size =
(select integervalue from attrvalue
where ictdesc1.prrfnbr=attrvalue.catentry_id
and ictdesc1.language_id=attrvalue.language_id
and attrvalue.attribute_id in
(select attribute_id from attribute
where name = 'Å©±â')
and attrvalue.language_id=-9
and attrvalue.catentry_id in
(select catentry_id from catgpenrel
where catgroup_id=1))
where language_id=-9"
db2 "insert into ictprices(storeid, catentry_id,setccurr,ppprc)
select storeent_id, catentry_id, currency, price
from storeent, offer, offerprice,tradeposcn
where storeent_id=0
and tradeposcn_id=offer.tradeposcn_id
and offer.offer_id=offerprice.offer_id
and tradeposcn.type='S'"
![]() |