Windows¿ë(301¹ÙÀÌÆ®)AIX¿ë(307¹ÙÀÌÆ®)Solaris¿ë(388¹ÙÀÌÆ®)Linux¿ë(282¹ÙÀÌÆ®) °³º° °Ë»ö °ø°£¿ë »óǰ ¾îµå¹ÙÀÌÀú °Ë»ö °ø°£À» ¼öµ¿À¸·Î ÀÛ¼º

»óǰ ¾îµå¹ÙÀÌÀú °Ë»ö °ø°£À» ¼öµ¿À¸·Î ÀÛ¼ºÇÏ·Á¸é īŻ·Î±× ¼­ºê½Ã½ºÅÛ ¹× °ü·Ã µ¥ÀÌÅͺ£À̽º ½ºÅ°¸¶¸¦ ¿ÏÀüÈ÷ ÀÌÇØÇϰí ÀÖ¾î¾ß ÇÕ´Ï´Ù. °Ë»ö °ø°£Àº ´ÙÀ½ÀÇ Ç¥ÁØ WebSphere Commerce Å×ÀÌºí¿¡¼­ ÃßÃâÇÑ Á¤º¸°¡ µé¾î ÀÖ´Â Ãß°¡ µ¥ÀÌÅͺ£À̽º Å×À̺í·Î ±¸¼ºµË´Ï´Ù.
iSeries 400¿ë(278¹ÙÀÌÆ®) ÁÖ: ÀÌ Á¤º¸´Â iSeries »ç¿ëÀÚ¸¦ Àû¿ëÇÏÁö ¾Ê½À´Ï´Ù. ´ë½Å XML ÆÄÀÏÀ» »ç¿ëÇÏ¿© »óǰ ¾îµå¹ÙÀÌÀú °Ë»ö °ø°£ ÀÛ¼ºÀ» ÂüÁ¶ÇϽʽÿÀ.

»óǰ ¾îµå¹ÙÀÌÀú °Ë»ö ±â´ÉÀ» Áö¿øÇϱâ À§ÇØ ÇÊ¿äÇÑ µ¥ÀÌÅͺ£À̽º Å×À̺íÀ» ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½ ´Ü°è°¡ ÇÊ¿äÇÕ´Ï´Ù. ´ÙÀ½ ´Ü°è¿¡¼­´Â Å×À̺í, º¸±â ¹× ÇØ´ç »öÀÎÀ¸·Î ±¸¼ºµÈ °£´ÜÇÑ °Ë»ö °ø°£À» ÀÛ¼ºÇϱâ À§ÇÑ °ßº» SQL¹®ÀÌ Á¦°øµË´Ï´Ù. ¸í·É¹®¿¡´Â »óǰ ¹× Ä«Å×°í¸® ID¿Í °°ÀÌ »ç¿ëÀÚ ÀÚ½ÅÀÇ µ¥ÀÌÅÍ·Î ¹Ù²Ù¾î¾ß ÇÏ´Â µ¥ÀÌÅͰ¡ Æ÷ÇԵ˴ϴÙ. ¼³¸íÀ» À§ÇØ µ¥ÀÌÅͰ¡ ¿©±â¿¡ Ç¥½ÃµË´Ï´Ù. SQL¹®¿¡¼­ µ¥ÀÌÅ͸¦ ¸®ÅÏÇÏ´Â °æ¿ì, ƯÈ÷, ÀÌ µ¥ÀÌÅͰ¡ ³ªÁß ´Ü°è¿¡¼­ ÀÔ·ÂÀ¸·Î »ç¿ëµÇ´Â °æ¿ì, ¸®ÅÏµÈ µ¥ÀÌÅÍ´Â SQL¹® ´ÙÀ½¿¡ ´ë°ýÈ£ ¾È¿¡ ±½ÀºÃ¼·Î Ç¥½ÃµË´Ï´Ù.

ÁÖ: ÀÌ ÆÄÀÏÀÇ ¿¹´Â DB2¿¡¸¸ ÇØ´çµË´Ï´Ù. Oracle »ç¿ëÀÚ´Â Oracle ƯÁ¤ SQL¹®¿¡ ´ëÇÑ ÀûÇÕÇÑ °ßº» À¯Æ¿¸®Æ¼¸¦ ÂüÁ¶ÇØ¾ß ÇÕ´Ï´Ù.

  1. »óǰ ¾îµå¹ÙÀÌÀú °Ë»ö ±â´ÉÀ» Àû¿ë½Ãų Ä«Å×°í¸®¸¦ °áÁ¤ÇϽʽÿÀ. ÀÌ ¿¹¿¡¼­´Â Ä«Å×°í¸® "1"À» »ç¿ëÇÕ´Ï´Ù.
  2. Ä«Å×°í¸®¿¡ ´ëÇÑ ¸ðµç »óǰ ¼Ó¼º ¹× À¯ÇüÀ» ³ª¿­ÇϽʽÿÀ. ´ÙÀ½ SQL¹®À» ½ÇÇàÇÏ¿© Ä«Å×°í¸®ÀÇ °íÀ¯ÇÑ ID ¹øÈ£¸¦ ¾Ë¾Æ³»½Ê½Ã¿À.

    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"

  3. Ä«Å×°í¸®¿¡¼­ ¸ðµç »óǰ¿¡ °øÅëµÇ´Â ¼Ó¼ºÀ» Çϳª ÀÌ»ó ¼±ÅÃÇϽʽÿÀ. ¿¹¸¦ µé¸é, ¹®ÀÚ¿­ À¯ÇüÀÇ '»ö»ó'°ú Á¤¼ö À¯ÇüÀÇ 'Å©±â'°¡ ÀÖ½À´Ï´Ù.
  4. »óǰ ID, »óǰ ¼³¸í ¹× 3´Ü°è¿¡¼­ ÁöÁ¤ÇÑ »ç¿ëÀÚ Á¤ÀÇ »óǰ ¼Ó¼º(»ö»ó, Å©±â)°ú °°Àº Ç¥ÁØ »óǰ ¼Ó¼ºÀ¸·Î °Ë»ö °ø°£À» ÀÛ¼ºÇϽʽÿÀ.
    [Ä«Å×°í¸® 1ÀÇ °Ë»ö °ø°£Àº ICT1, ICTDESC1, ICV1_NULL·Î ±¸¼ºµÊ]
    ´ÙÀ½ SQL¹®À» ½ÇÇàÇϽʽÿÀ.

    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;

  5. Ä«Å×°í¸®ÀÇ ICROOTCAT Å×ÀÌºí¿¡ ÇàÀÌ ÀÖÀ¸¸é Ä«Å×°í¸®¿¡ ´ëÇØ °Ë»ö °ø°£ÀÌ Á¸ÀçÇÕ´Ï´Ù. ÀÛ¼ºÇÑ °¢ °Ë»ö °ø°£¿¡ ´ëÇØ ¸ÞŸ µ¥ÀÌÅ͸¦ »ðÀÔÇϽʽÿÀ. ´ÙÀ½ SQL¹®À» ½ÇÇàÇϽʽÿÀ.

    db2 "insert into icrootcat
         (rootcategoryid,catgroup_id,pfpasync,pfreq,tablename,
          lastmodified)
         values
         (1,1,0,1,'ICV1_','2000-06-15-14.48.25.686000')"

  6. °Ë»ö °¡´ÉÇÑ ¸ðµç ¼Ó¼º¿¡ ´ëÇØ ICEXPLFEAT Å×ÀÌºí¿¡ ÇàÀÌ Çϳª ÀÖ½À´Ï´Ù. FEATUREID °ªÀº KEYS Å×ÀÌºí¿¡¼­ °¡Á®¿Ã ¼ö ÀÖ½À´Ï´Ù.
    ´ÙÀ½ SQL¹®À» ½ÇÇàÇÏ¿© °¢ »ç¿ëÀÚ Á¤ÀÇ »óǰ ¼Ó¼º¿¡ ´ëÇØ ¸ÞŸ µ¥ÀÌÅ͸¦ »ðÀÔÇϽʽÿÀ.

    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);

  7. °¢ Ç¥ÁØ »óǰ ¼Ó¼º¿¡ ´ëÇØ ¸ÞŸ µ¥ÀÌÅ͸¦ »ðÀÔÇϽʽÿÀ. ´ÙÀ½ SQL¹®À» ½ÇÇàÇϽʽÿÀ. ¸í·É¹®Àº º¯°æÇÒ Çʿ䰡 ¾ø½À´Ï´Ù.

    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);

  8. ICEXPLDESC Å×ÀÌºí¿¡´Â °Ë»ö °¡´ÉÇÑ ¸ðµç ¼Ó¼º¿¡ ´ëÇØ Áö¿øµÇ´Â °¢ ¾ð¾î·Î µÈ ÇϳªÀÇ ÇàÀÌ ÀÖ½À´Ï´Ù. ´ÙÀ½ SQL¹®À» ½ÇÇàÇÏ¿© °¢ »ç¿ëÀÚ Á¤ÀÇ »óǰ ¼Ó¼ºÀÇ °¢ ¾ð¾î¿¡ ´ëÇØ ¸ÞŸ µ¥ÀÌÅ͸¦ »ðÀÔÇϽʽÿÀ. NAME ¿­ÀÇ °ªÀº ATTRIBUTE Å×À̺íÀÇ NAME ¿­ÀÇ °ª°ú °°¾Æ¾ß ÇÕ´Ï´Ù.

    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);

  9. °¢ »ç¿ëÀÚ Á¤ÀÇ »óǰ ¼Ó¼ºÀÇ °¢ ¾ð¾î¿¡ ´ëÇØ ¸ÞŸ µ¥ÀÌÅ͸¦ »ðÀÔÇϽʽÿÀ. °¢ ¾ð¾î¿¡ ´ëÇØ DESCRIPTION ¿­À» ¹ø¿ªÇØ¾ß ÇÕ´Ï´Ù.

    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);

  10. CATENTRY¿¡¼­ ICT1À¸·Î µ¥ÀÌÅ͸¦ °¡Á®¿À½Ê½Ã¿À. ´ÙÀ½ SQL ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

    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"

  11. CATENTDESC¿¡¼­ ICTDESC1À¸·Î µ¥ÀÌÅ͸¦ °¡Á®¿À½Ê½Ã¿À. °¢ ¾ð¾î¿¡ ´ëÇØ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ´ÙÀ½ ¿¹´Â Çѱ¹¾î¿¡ ´ëÇØ ¸í·ÉÀ» ½ÇÇàÇÑ °ÍÀÔ´Ï´Ù. ´ÙÀ½ SQL ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

    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)))"

  12. °¢ ¾ð¾îÀÇ °¢ »ç¿ëÀÚ Á¤ÀÇ »óǰ ¼Ó¼º¿¡ ´ëÇØ ATTRVALUE¿¡¼­ ICTDESC1À¸·Î µ¥ÀÌÅ͸¦ °¡Á®¿À½Ê½Ã¿À. °¢ ¾ð¾î¿¡ ´ëÇØ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ´ÙÀ½ ¿¹´Â Çѱ¹¾î¿¡ ´ëÇØ ¸í·ÉÀ» ½ÇÇàÇÑ °ÍÀÔ´Ï´Ù. ´ÙÀ½ SQL ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

    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"

  13. »óǰ °¡°ÝÀ» OFFERPRICE Å×ÀÌºí¿¡¼­ ICTPRICES Å×À̺í·Î ÃßÃâÇϽʽÿÀ. °¢ ÅëÈ­ÀÇ ¸ðµç »óǰ¿¡ ´ëÇØ ÇϳªÀÇ °¡°ÝÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù.

    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'"

°ü·Ã °³³ä

°ü·Ã ŽºÅ©

IBM copyright