·Î´õ´Â ÇöÀç ½Ã°£¿¡ ±âÃÊÇÏ¿© ½Ã°£¼ÒÀÎ ¿¿¡ °ªÀ» »ðÀÔÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, WebSphere Commerce ÆÇ¸Å ¼³Á¤ÀÇ STARTDATE ¹× ENDDATE´Â Å×ÀÌºí¿¡ ÆÇ¸Å ¼³Á¤ÀÌ »ðÀÔµÈ ½Ã°£¿¡ ±âÃÊÇÑ °ªÀ» °¡Áú ¼ö ÀÖ½À´Ï´Ù. ÀÌ ±â´ÉÀ» Áö¿øÇϱâ À§ÇØ ·Î´õ ÆÐŰÁö´Â MLTIME Å×ÀÌºí¿¡ ½Ã°£¼ÒÀÎ ÀνºÅϽº¸¦ º¸°üÇÕ´Ï´Ù. ÀÌ Å×ÀÌºí¿¡ ´ëÇÑ ½ºÅ°¸¶´Â ´ÙÀ½°ú °°½À´Ï´Ù.
table MLTIME ( INSTANCEID BIGINT not null, MLTIMESTAMP TIMESTAMP )
·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏÀ» ¼öÁ¤Çϸé Å×ÀÌºí ¹× ÇØ´ç ¿ÀÇ À̸§À» »ç¿ëÀÚ Á¤ÀÇÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÀ½À» ¼öÇàÇÏ¿© À̸¦ È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.
![]()
![]()
![]()
![]()
MassLoadCustomizer.properties´Â MassLoader.zip ¾ÆÄ«À̺꿡 ÀÖ½À´Ï´Ù. ÀÌ ÆÄÀÏÀÇ ¾ÐÃàÀ» Ç®°í .properties È®ÀåÀÚ´Â À¯ÁöÇÏ¸é¼ À̸§À» ¹Ù²Û ´ÙÀ½ classpathÀÇ µð·ºÅ丮¿¡ µÎ½Ê½Ã¿À.
ISeries_LODWCSDTA_Customizer.properties ÆÄÀÏÀº
/QIBM/ProdData/WebCommerce/properties µð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù. ÀÌ ÆÄÀÏÀ» /instroot/xml µð·ºÅ丮¿¡ º¹»çÇϰí .properties
È®ÀåÀÚ´Â À¯ÁöÇÏ¸ç »õ ÆÄÀÏÀÇ À̸§À» ¹Ù²Û ÈÄ »õ ÆÄÀÏ¿¡ ÇÊ¿äÇÑ º¯°æÀ» ÇϽʽÿÀ. Áß¿ä:
¿øº» ISeries_LODWCSDTA_Customizer.properties ÆÄÀÏÀ» »èÁ¦Çϰųª ¼öÁ¤ÇÏÁö ¸¶½Ê½Ã¿À.
·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏÀÇ ´ÙÀ½ Ư¼ºÀ» º¯°æÇϸé Å×ÀÌºí ¹× ÇØ´ç ¿ÀÇ À̸§ÀÌ »ç¿ëÀÚ Á¤ÀÇµÉ ¼ö ÀÖ½À´Ï´Ù.
TimestampTableName = MLTIME TimestampIdColumn = INSTANCEID TimestampValueColumn = MLTIMESTAMP
ÇöÀç ½Ã°£¼ÒÀÎ °ªÀ» ÁöÁ¤Çϱâ À§ÇÑ ÀÔ·Â µ¥ÀÌÅÍ´Â ½Ã°£¼ÒÀÎ ¹®ÀÚ¿ ÆÐÅÏ¿¡ ±âÃÊÇÕ´Ï´Ù. ½Ã°£¼ÒÀÎ Áö¼Ó ±â°£À» ÁöÁ¤Çϱâ À§ÇØ ´ÙÀ½ ¸¶½ºÅ©°¡ »ç¿ëµË´Ï´Ù.
%D for days %M for months %Y for years %H for hours %m for minutes %s for seconds
·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼ ¸¶½ºÅ©¸¦ ¼öÁ¤Çϰųª Ãß°¡ÇÏ¿© ÇöÀç ½Ã°£¼ÒÀÎ Æ÷¸ËÀ» »ç¿ëÀÚ Á¤ÀÇÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÀ½ ÀÔ·Â ¸¶½ºÅ©°¡ Á¦°øµË´Ï´Ù.
InputCurrentTimestampFormat.1 = CURRENT TIMESTAMP InputCurrentTimestampFormat.2 = CURRENT TIMESTAMP %D DAYS InputCurrentTimestampFormat.3 = CURRENT TIMESTAMP %D DAYS %M MONTHS InputCurrentTimestampFormat.4 = CURRENT TIMESTAMP %D DAYS %M MONTHS %Y YEARS InputCurrentTimestampFormat.5 = CURRENT TIMESTAMP %Y YEARS %M MONTHS %D DAYS InputCurrentTimestampFormat.6 = SYSDATE InputCurrentTimestampFormat.7 = ADDDAYS(SYSDATE,%D) InputCurrentTimestampFormat.8 = ADDDAYS(ADDMONTHS(SYSDATE,%M),%D) InputCurrentTimestampFormat.9 = ADDDAYS(ADDMONTHS(ADDYEARS(SYSDATE,%Y),%M),%D)
ÇöÀç ½Ã°£¼ÒÀÎÀÇ ÀÔ·Â µ¥ÀÌÅÍ °ªÀº ÁöÁ¤µÈ ÆÐÅϰú ÀÏÄ¡ÇÕ´Ï´Ù. µ¥ÀÌÅͰ¡ ÁöÁ¤µÈ ÀÔ·Â ÆÐÅÏ¿¡ ¸Â´Â °æ¿ì, ÀÔ·Â µ¥ÀÌÅ͸¦ ºÐ¼®ÇÏ´Â µ¥ ÀÌ ÆÐÅÏÀÌ »ç¿ëµÇ¸ç ·Î´õ´Â µ¥ÀÌÅ͸¦ µ¥ÀÌÅͺ£À̽º¿¡ »ðÀÔÇϱâ Àü¿¡ ÇØ´çÇÏ´Â Ãâ·Â Æ÷¸ËÀ¸·Î º¯È¯ÇÕ´Ï´Ù. ½Åû ¹øÈ£°¡ ¼øÂ÷ÀûÀ¸·Î Á¤·ÄµÇ¾î ÀÖ´Â °æ¿ì À§ ¸ñ·Ï¿¡ »õ ÆÐÅÏÀ» Ãß°¡ÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÇöÀç ½Ã°£¼ÒÀÎÀ» ÁöÁ¤Çϱâ À§ÇÑ ´ë»ó Ãâ·Â Æ÷¸Ë¿¡´Â ´ÙÀ½ µÎ °¡Áö°¡ ÀÖ½À´Ï´Ù.
·Î´õÀÇ ±âº» ´ë»ó ÆÐÅÏÀº ´ÙÀ½°ú °°½À´Ï´Ù.
CurrentTimestampFormat.Load = CURRENT TIMESTAMP %Y YEARS %M MONTHS %D DAYS %h HOURS %m MINUTES %s SECONDS CurrentTimestampFormat.JDBC = CURRENT TIMESTAMP %Y YEARS %M MONTHS %D DAYS %h HOURS %m MINUTES %s SECONDS
·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼´Â ÀÌ·¯ÇÑ ÆÐÅÏÀÇ Æ¯¼º ¶ÇÇÑ, »ç¿ëÀÚ Á¤ÀÇÇÒ ¼ö ÀÖ½À´Ï´Ù. CurrentTimestampFormat.Load ¹× CurrentTimestampFormat.JDBC Ư¼ºÀ» »ç¿ëÀÚ Á¤ÀÇÇÒ ¶§ ¸í·É¹® °á°ú ±¸¹®ÀÌ ÁöÁ¤µÈ µ¥ÀÌÅͺ£À̽º °ü¸® ½Ã½ºÅÛ¿¡ ´ëÇØ ¿Ã¹Ù¸¥Áö È®ÀÎÇØ¾ß ÇÕ´Ï´Ù.
·Î´õ´Â CurrentTimestampLiteral Ư¼ºÀ» »ç¿ëÇÏ¿© ½Ã°£¼ÒÀÎ ¿ °ªÀÌ ÇöÀç ½Ã°£¼ÒÀÎ Æ÷¸ËÀÎÁö ¿©ºÎ¸¦ Ãʱ⿡ ÆÇº°ÇÔÀ¸·Î½á, °ªÀÌ ½Ã°£¼ÒÀÎÀÇ ¹®ÀÚ¿ Ç¥ÇöÀÌ ¾Æ´ÑÁö ÆÇº°Çϱâ À§ÇØ Èûµé°Ô °è»êÇÒ Çʿ䰡 ¾ø°Ô µË´Ï´Ù.
CurrentTimestampLiteral = CURRENT TIMESTAMP
DB2ÀÇ °æ¿ì, ÀÌ Æ¯¼ºÀÇ ±âº»°ªÀº CURRENT TIMESTAMPÀÔ´Ï´Ù.
Oracle µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ±âº»°ªÀº SYSDATEÀÔ´Ï´Ù.
ÇöÀç ½Ã°£¼ÒÀÎ ·Îµå ¿¹
OFFER_ID°¡ 10123ÀÎ ÆÇ¸Å ¼³Á¤À» °»½ÅÇϱâ À§ÇØ ·Î´õ·Î ¾Æ·¡ Á¤º¸°¡ Á¦°øµË´Ï´Ù. ½ÃÀÛ ³¯Â¥ °ªÀº CURRENT TIMESTAMPÀ̰í, Á¾·á ³¯Â¥ °ªÀº CURRENT TIMESTAMP + 14 DAYSÀÔ´Ï´Ù.
<OFFER OFFER_ID="10123" STARTDATE="CURRENT TIMESTAMP"> ENDDATE="CURRENT TIMESTAMP + 14 DAYS" />
·Î´õ´Â STARTDATE ¹× ENDDATE ¿ÀÌ µ¥ÀÌÅͺ£À̽ºÀÇ ½Ã°£¼ÒÀÎ µ¥ÀÌÅÍ À¯ÇüÀÓÀ» ÀνÄÇÕ´Ï´Ù. CurrentTimeStampLiteral Ư¼º¿¡ ±âÃÊÇÏ¿©, °ªÀº ÇöÀç ½Ã°£¼ÒÀÎ Æ÷¸Ë¿¡ ÁöÁ¤µÈ °ªÀ¸·Î ÆÇº°µË´Ï´Ù. STARTDATE °ªÀº InputCurrentTimeStampFormat.1 ÆÐÅÏ¿¡ ¸ÂÀ¸¸ç, CurrentTimeStampFormat.JDBC Ư¼º¿¡ ÀÇÇØ ÁöÁ¤µÈ ÆÐÅÏÀ¸·Î º¯È¯µË´Ï´Ù. ENDDATE °ªÀº InputCurrentTimeStampFormat.2 Ư¼º Æ÷¸Ë¿¡ ¸ÂÀ¸¸ç, ¿ª½Ã CurrentTimeStampFormat.JDBC Ư¼º¿¡ ÀÇÇØ ÁöÁ¤µÈ ÆÐÅÏÀ¸·Î º¯È¯µË´Ï´Ù.
ÇöÀç ½Ã°£¼ÒÀο¡ Áö¼Ó ±â°£ Ãß°¡ ¿¹
·Î´õ¸¦ »ç¿ëÇϸé ÇöÀç ½Ã°£¼ÒÀο¡ Áö¼Ó ±â°£À» Ãß°¡ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, ƯÁ¤ ³¯Â¥¸¦ ÀÔ·ÂÇÏÁö ¾Ê°í ÆÇ¸Å ¼³Á¤À» ·ÎµåÇϰíÀÚ ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì, ½ÃÀÛ ³¯Â¥ ÀÌÈÄ ¾ó¸¶°£ÀÇ Áö¼Ó ±â°£ÀÌ °æ°úÇϵµ·Ï Á¾·á ³¯Â¥¸¦ ÀÛ¼ºÇØ¾ß ÇÕ´Ï´Ù. ´ÙÀ½ ¿¹´Â DB2¸¦ »ç¿ëÇϸé Àß µ¿ÀÛÇÕ´Ï´Ù.
<Offer Startdate="Current Timestamp" Enddate="Current Timestamp +14 Days +4 Months +1 Year +0 Hours +0 Minutes +0 Seconds" />
±×·¯³ª Ç÷§Æû°ú »ó°ü¾øÀÌ ÇöÀç ½Ã°£¼ÒÀÎ Áö¼Ó ±â°£À» ó¸®ÇÏ·Á¸é, ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏÀÇ ¸¶½ºÅ©¸¦ ¼öÁ¤ÇÏ¿© ÇöÀç ½Ã°£¼ÒÀÎ Æ÷¸ËÀ» »ç¿ëÀÚ Á¤ÀÇÇØ¾ß ÇÕ´Ï´Ù. ´ÙÀ½Àº »ç¿ëÀÚ Á¤ÀÇµÈ ÇöÀç ½Ã°£¼ÒÀΠƯ¼º ½ºÆåÀÔ´Ï´Ù.
CurrentTimestampLiteral=Current Timestamp InputCurrentTimestampFormat.0=Current Timestamp InputCurrentTimestampFormat.1=Current Timestamp %D Days InputCurrentTimestampFormat.2=Current Timestamp %M Months InputCurrentTimestampFormat.3=Current Timestamp %Y Years InputCurrentTimestampFormat.4=Current Timestamp %D Days %M Months InputCurrentTimestampFormat.5=Current Timestamp %D Days %M Months %Y Years InputCurrentTimestampFormat.5=Current Timestamp %H Hours %m Minutes %s Seconds CurrentTimestampFormat.JDBC=Current Timestamp %D Days %M Months %Y Years %H Hours %m Minutes %s Seconds
ÆÇ¸Å ¼³Á¤ ¿¹ ¹× ÀÌ·¯ÇÑ Æ¯¼º ½ºÆåÀ» »ç¿ëÇÒ °æ¿ì, ÆÇ¸Å ¼³Á¤ Á¾·á ³¯Â¥´Â InputCurrentTimestampFormat.5 ÆÐÅÏ¿¡ ÀÏÄ¡ÇÕ´Ï´Ù. ±×·¯¸é CurrentTimestampFormat.JDBC¸¦ »ç¿ëÇÑ ´ÙÀ½ ÆÇ¸Å ¼³Á¤ Á¤º¸°¡ ³ªÅ¸³³´Ï´Ù.
<Offer Startdate="Current Timestamp" Enddate="Current Timestamp +14 Days +4 Months +1 Year +0 Hours +0 Minutes +0 Seconds" />
À§ÀÇ ¿¹¿¡¼´Â ·Î´õ°¡ ¿©·¯ ÇöÀç ½Ã°£¼ÒÀÎ Æ÷¸ËÀ» ÀÔ·ÂÇÏ°í ¹Ù¶÷Á÷ÇÑ Ãâ·Â Æ÷¸Ë¿¡ ¸Â°Ô Æ÷¸ËÇÏ´Â ¹æ½ÄÀ» º¸¿©ÁÝ´Ï´Ù. ´ÙÀ½ ¿¹¿¡¼´Â Ç÷§Æû¿¡ »ó°ü¾ø´Â Æ÷¸ËÀ» ó¸®ÇÏ°í ±× Æ÷¸ËÀ» Ç÷§Æû ƯÁ¤ Ãâ·Â Æ÷¸ËÀ¸·Î ¸ÊÇÎÇÏ´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù.
<Offer Startdate="Now" Enddate="Now +14D +4M +1Y" /> CurrentTimestampLiteral=Now InputCurrentTimestampFormat.0=Now InputCurrentTimestampFormat.1=Now %DD InputCurrentTimestampFormat.2=Now %MM InputCurrentTimestampFormat.3=Now %YY InputCurrentTimestampFormat.4=Now %DD %MM InputCurrentTimestampFormat.5=Now %DD %MM %YY InputCurrentTimestampFormat.5=Sysdate %HH %mm %ss CurrentTimestampFormat.JDBC=AddYears(AddMonths(AddDays(AddHours(AddMinutes(AddSeconds (Sysdate,%s),%m),%H),%D),%M),%Y)
ÁÖ: À§ÀÇ ¸í·É¹®Àº ¿¹ÀÔ´Ï´Ù. À̰ÍÀº °¡»óÀÇ µ¥ÀÌÅͺ£À̽º °ü¸® ½Ã½ºÅÛ¿¡ ´ëÇÑ »ç¿ëÀÚ Á¤ÀÇ ±â´ÉÀ» ¹¦»çÇÏ´Â ¸ñÀûÀ¸·Î¸¸ »ç¿ëÇÕ´Ï´Ù. DB2 ¶Ç´Â Oracle µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ¼´Â ¿Ã¹Ù¸£Áö ¾Ê½À´Ï´Ù.
ÆÇ¸Å ¼³Á¤ ¿¹ ¹× ÀÌ·¯ÇÑ Æ¯¼º ½ºÆåÀ» »ç¿ëÇÒ °æ¿ì, ÆÇ¸Å ¼³Á¤ Á¾·á ³¯Â¥´Â InputCurrentTimestampFormat.5 ÆÐÅÏ¿¡ ÀÏÄ¡ÇÕ´Ï´Ù. ±×·¯¸é CurrentTimestampFormat.JDBC¸¦ »ç¿ëÇÑ ´ÙÀ½ ÆÇ¸Å ¼³Á¤ Á¤º¸°¡ ³ªÅ¸³³´Ï´Ù.
<Offer Startdate="Current Timestamp" Enddate="AddYears(AddMonths(AddDays(AddMinutes(AddSeconds(Sysdate,0),0),0),14),4),1)" />
![]() |