·Î´õ ÆÐŰÁö¸¦ »ç¿ëÇÏ¸é ´ÙÀ½À» ¼öÇàÇÏ¿© ·Î´õ¸¦ »ç¿ëÀÚ Á¤ÀÇÇÒ ¼ö ÀÖ½À´Ï´Ù.
´ÙÀ½ ¼öÇàÇÏ¿© ·Î´õÀÇ ÀÌ·¯ÇÑ ±â´ÉÀ» »ç¿ëÀÚ Á¤ÀÇÇÒ ¼ö ÀÖ½À´Ï´Ù.
![]()
![]()
![]()
![]()
MassLoadCustomizer.properties´Â MassLoader.zip ¾ÆÄ«À̺꿡 ÀÖ½À´Ï´Ù. ÀÌ ÆÄÀÏÀÇ ¾ÐÃàÀ» Ç®°í .properties È®ÀåÀÚ´Â À¯ÁöÇÏ¸é¼ À̸§À» ¹Ù²Û ´ÙÀ½ classpathÀÇ µð·ºÅ丮¿¡ µÎ½Ê½Ã¿À.
ISeries_LODWCSDTA_Customizer.properties ÆÄÀÏÀº
/QIBM/ProdData/WebCommerce/properties µð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù. ÀÌ ÆÄÀÏÀ» /instroot/xml µð·ºÅ丮¿¡ º¹»çÇϰí .properties
È®ÀåÀÚ´Â À¯ÁöÇÏ¸ç »õ ÆÄÀÏÀÇ À̸§À» ¹Ù²Û ÈÄ »õ ÆÄÀÏ¿¡ ÇÊ¿äÇÑ º¯°æÀ» ÇϽʽÿÀ. Áß¿ä:
¿øº» ISeries_LODWCSDTA_Customizer.properties ÆÄÀÏÀ» »èÁ¦Çϰųª ¼öÁ¤ÇÏÁö ¸¶½Ê½Ã¿À.
±¸¼º¿ä¼Ò ´ëü
·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏÀÇ ´ÙÀ½ ¿ä¼Ò¿¡´Â ±âº» ±¸ÇöÀ» ´ëüÇÏ·Á´Â Ŭ·¡½º °ªÀ» ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
- ParserName
- »ç¿ëÇÒ ±¸¹® ºÐ¼®±â À̸§
- ValidatorName
- »ç¿ëÇÒ °ËÁõ±â À̸§
- FormatterName
- »ç¿ëÇÒ Æ÷¸ËÅÍ À̸§
- JDBCFormatterName
- SQL ¹ÝÀÔ ¹æ¹ýÀ» »ç¿ëÇÒ °æ¿ì Æ÷¸ËÅÍ À̸§
- WriterName
- »ç¿ëÇÒ ÀÛ¼ºÀÚ À̸§
- JDBCWriterName
- SQL ¹ÝÀÔ ¹æ¹ýÀ» »ç¿ëÇÒ °æ¿ì ÀÛ¼ºÀÚ À̸§
¿¹¸¦ µé¾î, ·Î´õÀÇ ±âº» ÀÛ¼ºÀÚ(DefaultWriter)¸¦ ÀÛ¼ºÀÚ com.abc.writer.SpecialWriter·Î ´ëüÇÏ·Á¸é, ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡ ´ÙÀ½À» ÁöÁ¤ÇϽʽÿÀ.
WriterName = com.abc.writer.SpecialWriter
·Î´õ´Â "com.abc.writer.SpecialWriter"¸¦ »ç¿ëÇÏ¿© ¾²±â ±â´ÉÀ» ¼öÇàÇÕ´Ï´Ù.
ÀÔ·Â ÆÄÀÏÀÇ ¿ä¼Ò¸¦ ¹«½ÃÇϵµ·Ï ·Î´õ ¼³Á¤
ÀÔ·Â ÆÄÀÏ¿¡ ´ë»ó µ¥ÀÌÅͺ£À̽º¿¡ ¸ÊÇεÇÁö ¾ÊÀº ¿ä¼Ò°¡ ÀÖ´Â °æ¿ì, ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼ ·Î´õ°¡ ÇØ´ç ¿ä¼Ò¸¦ ¹«½ÃÇϵµ·Ï ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¹«½ÃÇÒ ¿ä¼Ò¸¦ ÁöÁ¤ÇÏ·Á¸é IgnoreElements¸¦ »ç¿ëÇÏ°í ¼¼¹ÌÄÝ·Ð(;)À¸·Î ±¸ºÐÇϽʽÿÀ. ¿¹¸¦ µé¾î, import, literals, ProductRepository ¿ä¼Ò¸¦ ¹«½ÃÇÏ·Á¸é, ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡ ´ÙÀ½À» ÁöÁ¤ÇϽʽÿÀ.
IgnoreElements = import;literals;ProductRepository
À̺¥Æ® Å¥ °ü¸®
·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏÀÇ ¼³Á¤À» ¼öÁ¤ÇÏ¿© À̺¥Æ® Å¥¸¦ °ü¸®ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.
QueueLowCount = 35 QueueHighCount = 90
Å¥ÀÇ ¿ä¼Ò ¼ö°¡ ÇѰ踦 ÃʰúÇÒ °æ¿ì Å¥¸¦ ä¿ì´Â À̺¥Æ® ¼Ò½º°¡ ºÀ¼âµÊÀ¸·Î½á À̺¥Æ®°¡ ´õ ÀÌ»ó Å¥¿¡ ³Ö¾îÁöÁö ¾Ê°Ô µË´Ï´Ù. Å¥ÀÇ ¿ä¼Ò ¼ö°¡ ÇÏÇѼ± ¹ØÀ¸·Î ¶³¾îÁö¸é Å¥´Â À̺¥Æ®¸¦ ´Ù½Ã ½ÂÀÎÇϱ⠽ÃÀÛÇÕ´Ï´Ù.
·Î´õ°¡ ´Ù¸¥ µ¥ÀÌÅͺ£À̽º ¼ÒÇÁÆ®¿þ¾î ¹× ¿î¿µÃ¼Á¦¿¡¼ ½ÇÇàµÇµµ·Ï ¼³Á¤
·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼ ´ÙÀ½ ¿ä¼Ò¿¡ ´ëÇÑ ¸Å°³º¯¼ö¸¦ ¼öÁ¤ÇÏ¿© ´Ù¸¥ µ¥ÀÌÅͺ£À̽º ¼ÒÇÁÆ®¿þ¾î ¹× ¿î¿µÃ¼Á¦¸¦ ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÀÌ·¯ÇÑ Ç׸ñ Áß Çϳª¸¦ »ç¿ëÀÚ Á¤ÀÇÇÏ·Á¸é, ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼ ¸í·É ¾Õ¿¡ ÀÖ´Â ÀÌÁß ½½·¡½Ã ÁÖ¼® ¹®ÀÚ¸¦ Á¦°ÅÇÏ°í ±âº»°ªÀ» ¼öÁ¤ÇϽʽÿÀ.
±âº»°ª(DB2¸¦ »ç¿ëÇÑ´Ù°í °¡Á¤)À» ¼öÁ¤ÇÏ·Á´Â °æ¿ì µ¥ÀÌÅͺ£À̽º ¿¬°á ¸í·É ¸Å°³º¯¼ö¸¦ º¯°æÇÏ¸é µË´Ï´Ù.
DBConnectCommand = connect to {0} user {1} using {2};¿©±â¼,
0 = µ¥ÀÌÅͺ£À̽º À̸§
1 = µ¥ÀÌÅͺ£À̽º »ç¿ëÀÚ
2 = »ç¿ëÀÚ ¾ÏÈ£
±âº»°ªÀ» ¼öÁ¤ÇÏ·Á´Â °æ¿ì µ¥ÀÌÅͺ£À̽º ·Îµå Å×ÀÌºí ¸í·É ¸Å°³º¯¼ö¸¦ º¯°æÇÏ¸é µË´Ï´Ù.
DBLoadTableCommand = load from {0} of del modified by coldel{1} chardel{2} insert into {3} ({4});¿©±â¼,
0 = ÆÄÀÏ À̸§
1 = ¿ ºÐ¸®¹®ÀÚ
2 = ¹®ÀÚ ºÐ¸®¹®ÀÚ
3 = Å×À̺í À̸§
4 = ¿ À̸§, ÄÞ¸¶ º°°Å(,)
±âº»°ªÀ» ¼öÁ¤ÇÏ·Á´Â °æ¿ì µ¥ÀÌÅͺ£À̽º ¹ÝÀÔ ¸í·É ¸Å°³º¯¼ö¸¦ º¯°æÇÏ¸é µË´Ï´Ù.
DBImportCommand = import from {0} of del modified by coldel{1} chardel{2} insert_update into {3} ({4});¿©±â¼,
0 = ÆÄÀÏ À̸§
1 = ¿ ºÐ¸®¹®ÀÚ
2 = ¹®ÀÚ ºÐ¸®¹®ÀÚ
3 = Å×À̺í À̸§
4 = ¿ À̸§, ÄÞ¸¶ º°°Å(,)
±âº»°ªÀ» ¼öÁ¤ÇÏ·Á´Â °æ¿ì ·Îµå¸¦ ½ÇÇàÇÏ´Â ½Ã½ºÅÛ ¸í·É ¸Å°³º¯¼ö¸¦ º¯°æÇÏ¸é µË´Ï´Ù. ÀÌ ¸í·ÉÀº ·Î´õ°¡ »ý¼ºÇÑ ¿ø½Ã load ¹× import ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÕ´Ï´Ù.
DBLoadCommand = db2clpex DB2 -z {0} -astvf {1}
¿©±â¼,
0 = ·Î±× ÆÄÀÏ À̸§
1 = ¸í·É ÆÄÀÏ À̸§AIX¿¡¼ ½ÇÇà ÁßÀÎ DB2ÀÇ °æ¿ì, DBLoadCommand property °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.
db2 -tvf {1} -z {0}
![]()
![]()
![]()
DBLoadCommand = sqlldr log={0} control={1} USERID={2}
¿©±â¼,
0 = ·Î±× ÆÄÀÏ À̸§
1 = ¸í·É ÆÄÀÏ À̸§
2 = µ¥ÀÌÅͺ£À̽º »ç¿ëÀÚ À̸§
¿©·¯ µ¥ÀÌÅͺ£À̽º ¹× ¿î¿µÃ¼Á¦ Á¶ÇÕ¿¡ ´ëÇØ ´ÙÀ½ ¼³Á¤À» »ç¿ëÇϽʽÿÀ.
![]()
sqlimport, ·Îµå, ¹ÝÀÔ ¶Ç´Â »èÁ¦ ¹æ¹ýÀ» »ç¿ëÇÏ¿© Windows NT ¶Ç´Â Windows 2000¿¡¼ ½ÇÇàµÇ´Â DB2ÀÇ °æ¿ì, classpath ½Ã½ºÅÛ È¯°æ º¯¼ö°¡ db2/dbconnect.zipÀ» Æ÷ÇÔÇϵµ·Ï ¼³Á¤ÇϽʽÿÀ.
![]()
![]()
![]()
AIX, Solaris ¶Ç´Â Linux ȯ°æ¿¡¼ DB2¸¦ ½ÇÇà ÁßÀÎ °æ¿ì, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
- sqlimport, ·Îµå, ¹ÝÀÔ ¶Ç´Â »èÁ¦ ¹æ¹ýÀ» »ç¿ëÇÏ¿© db2/dbconnect.zipÀ» Æ÷ÇÔÇϵµ·Ï classpath ½Ã½ºÅÛ È¯°æ º¯¼ö¸¦ ¼³Á¤ÇϽʽÿÀ.
- ·Îµå ¶Ç´Â ¹ÝÀÔ ¹æ¹ýÀ» »ç¿ëÇÏ¿© ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼ ´ÙÀ½ Ư¼ºÀ» ¼öÁ¤ÇϽʽÿÀ.
/** * Connection command. (Default is for DB2) * parameter 0 = dbName * parameter 1 = dbUser * parameter 2 = userPasswd */ DBConnectCommand = connect to {0} user {1} using {2}; /** * Load Data into Table command. (Default is for DB2) * parameter 0 = filename * parameter 1 = column delimiter * parameter 2 = character delimiter * parameter 3 = name of the table * parameter 4 = name of the columns, separated by comma(,)s */ DBLoadTableCommand = load from {0} of del modified by coldel{1} insert into {3} ({4}); /** * Insert Data into Table command. (Default is for DB2) * parameter 0 = filename * parameter 1 = column delimiter * parameter 2 = character delimiter * parameter 3 = name of the table * parameter 4 = name of the columns, separated by comma(,)s */ DBUpdateTableCommand = import from {0} of del modified by coldel{1} insert_update into {3} ({4}); /** * System command to invoke load (Default is for DB2) * parameter 0 = logFileName * parameter 1 = commandFileName */ DBLoadCommand = db2 -z {0} -tf {1}
![]()
sqlimport, ·Îµå, ¹ÝÀÔ ¶Ç´Â »èÁ¦ ¹æ¹ýÀ» »ç¿ëÇÏ¿© iSeries¿¡¼ ½ÇÇà ÁßÀÎ DB2ÀÇ °æ¿ì, ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼ ´ÙÀ½ Ư¼ºÀ» ¼öÁ¤ÇϽʽÿÀ.
/** * ¿¬°á ¹®ÀÚ¿ */ ConnectStringID = jdbc:db2:// /** * JDBC µå¶óÀ̹ö Á¤º¸ */ JDBCDriverName = com.ibm.db2.jdbc.app.DB2Driver DbVendorName=DB2/iSeries /** * ·Îµå/¹ÝÀÔ ¹æ¹ýÀÇ »ç¿ëÀÚ Á¤ÀÇ ÀÛ¼º±â */ WriterName=com.ibm.wca.MassLoader.Writer.ISeriesWriter
![]()
![]()
![]()
![]()
![]()
sqlimport, ·Îµå, ¹ÝÀÔ ¶Ç´Â »èÁ¦ ¹æ¹ýÀ» »ç¿ëÇÏ¿© Windows NT, Windows 2000, AIX, Solaris ¶Ç´Â Linux ȯ°æ¿¡¼ ½ÇÇà ÁßÀÎ Oracle µ¥ÀÌÅͺ£À̽ºÀÇ °æ¿ì, classpath ½Ã½ºÅÛ È¯°æ º¯¼ö°¡ oracle/dbconnect.zipÀ» Æ÷ÇÔÇϵµ·Ï ¼³Á¤ÇϽʽÿÀ.
·Î´õ°¡ ¿¿¡ ³Î(Null)°ª »ðÀÔ °¡´É
·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼ EnableNULLCheck Ư¼ºÀ» "true"·Î ¼³Á¤ÇÏ¿© ·Î´õ°¡ ³Î(Null)°ªÀ» ¿¿¡ »ðÀÔÇÒ ¼ö ÀÖ°Ô ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹:
EnableNULLCheck = true
¼º´É »óÀÇ ÀÌÀ¯·Î ÀÌ ±â´ÉÀº ±âº»°ªÀ¸·Î »ç¿ëÇÏÁö ¾Ê½À´Ï´Ù.
NULLStringLiteral Ư¼ºÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅÍ ³»ÀÇ ³Î(Null)°ª¿¡ ´ëÇÑ ¹®ÀÚ¿ Ç¥ÇöÀ» °áÁ¤ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ³Î(Null)°ªÀ» Ç¥ÇöÇϴµ¥ "-" ¹®ÀÚ¿À» »ç¿ëÇϵµ·Ï ·Î´õ¸¦ ¼³Á¤ÇÏ·Á¸é ·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡ ´ÙÀ½ Ư¼º°ú °ªÀ» ÁöÁ¤ÇϽʽÿÀ.
NULLStringLiteral = -
±âº»ÀûÀ¸·Î ÀÌ Æ¯¼º °ªÀº (µû¿ÈÇ¥ ¾ø´Â) "NULL"ÀÔ´Ï´Ù.
½Ã°£¼ÒÀÎ ¸¶½ºÅ© ¼³Á¤
·Î´õ »ç¿ëÀÚ Á¤ÀÇ Æ¯¼º ÆÄÀÏ¿¡¼ ½Ã°£¼ÒÀÎ ¸¶½ºÅ©¸¦ ¼öÁ¤Çϰųª Ãß°¡ÇÏ´Â µ¥ ´ëÇÑ Á¤º¸´Â ¾Æ·¡ÀÇ °ü·Ã "ÇöÀç ½Ã°£¼ÒÀÎ ·Îµå" ¹× "½Ã°£¼ÒÀÎ ¹× ³¯Â¥ µ¥ÀÌÅÍ ·Îµå" ŽºÅ©¸¦ ÂüÁ¶ÇϽʽÿÀ.
![]() |