º¹»ç ÀÛ¾÷ ³»¿ª ·¹º§, ±×·ì ·¹º§ ¶Ç´Â »ç¿ëÀÚ ·¹º§ÀÇ ¼öÆò ÇÊÅ͸µÀº SQLÀýÀ» »ç¿ëÇÏ¿© ¼Ò½º µ¥ÀÌÅÍ ¿øº»¿¡¼ µ¥ÀÌÅ͸¦ ¼±ÅÃÇÕ´Ï´Ù. SQLÀýÀÇ ³»¿ëÀº DB2 DataPropagator º¹»ç ÀÛ¾÷ ³»¿ª¿¡ ´ëÇÑ °í±Þ º¹»ç ÀÛ¾÷ ³»¿ª Á¤ÀÇ ³ëÆ®ºÏÀÇ Çà ÆäÀÌÁö¿Í JDBC º¹»ç ÀÛ¾÷ ³»¿ª¿¡ ´ëÇÑ °í±Þ º¹Á¦ º¹»ç ÀÛ¾÷ ³»¿ª ³ëÆ®ºÏÀÇ Çà ÆäÀÌÁö¿¡ ÀÇÇØ¼ Á¦¾îµË´Ï´Ù. ÀÌµé ³ëÆ®ºÏÀ» ¿·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
º¹»ç ÀÛ¾÷ ³»¿ª ·¹º§¿¡¼ µ¥ÀÌÅ͸¦ ÇÊÅÍÇÏ´Â ¹æ¹ý
º¹»ç ÀÛ¾÷ ³»¿ª ³ëÆ®ºÏÀÇ Çà ÆäÀÌÁö¿¡¼ ÇÊ¿äÇÑ ¸ðµç Çà »óÀÚ¿¡ SQLÀýÀ» ÀÔ·ÂÇϽʽÿÀ. ´ÙÀ½°ú °°Àº Çü½ÄÀ¸·Î Àüü SQL ÀýÀ» ÇÑ Çà¿¡ ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù.
city='myValue'
SQLÀýÀÇ ½ÃÀÛ ºÎºÐ¿¡ WHERE¸¦ ÀÔ·ÂÇÏÁö ¸¶½Ê½Ã¿À. WHERE´Â ÀÚµ¿À¸·Î »óÀÚ¿¡ ÀÔ·ÂµÈ Àý¿¡ Ãß°¡µË´Ï´Ù. ¿¹¸¦ µé¾î, ´ÙÀ½ÀÇ ÀýÀº Los Angeles¿Í µ¿ÀÏÇÑ µµ½Ã Ä÷³ °ªÀ» °¡Áø Ä÷³¸¸À» µ¿±âÈÇÕ´Ï´Ù.
city='Los Angeles, CA 90061'
±×·ì ·¹º§¿¡¼ µ¥ÀÌÅ͸¦ ÇÊÅÍÇÏ´Â ¹æ¹ý
city=':fcity.'
¿©±â¼, :fcity.´Â Ä÷³ °ª¿¡ ´ëÇÑ ¸Å°³º¯¼öÀÔ´Ï´Ù.
Ãß°¡ ÅØ½ºÆ®·Î ¸Å°³º¯¼ö À̸§À» °íÀ¯ÇÏ°Ô ½Äº°ÇÒ °ÍÀ» ±ÇÀåÇÕ´Ï´Ù. ¿¹¸¦ µé¸é, ÄÝ·Ð(:)À¸·Î ¸Å°³º¯¼ö À̸§À» ½ÃÀÛÇÏ¿© ¸¶Ä§Ç¥(.)·Î ¸¶Ä¡½Ê½Ã¿À.
Los Angeles, CA 90061
Ư¼ö °ªÀÌ »ç¿ëµÉ ¼öµµ ÀÖ½À´Ï´Ù. $USERNAME °ªÀ» »ç¿ëÇÏ¿© Sync Server »ç¿ëÀÚ ID¸¦ ¸Å°³º¯¼ö °ªÀ¸·Î »ðÀÔÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¸°Ô ÇÏ¿© »ç¿ëÀڴ ƯÁ¤ Çʵ忡 ÇØ´ç Sync Server »ç¿ëÀÚ ID·Î µ¥ÀÌÅÍ ¿øº»¿¡ »ðÀÔµÈ Æ¯Á¤ »ç¿ëÀÚ¿¡ ÀÇÇØ ÀÛ¼ºµÈ ÇàÀ» °¡Áý´Ï´Ù.
ÀÌ ±×·ì¿¡ ÁöÁ¤µÈ °¢ »ç¿ëÀÚ´Â Los Angeles, CA 90061°ú µ¿ÀÏÇÑ µµ½Ã Ä÷³ °ªÀ» °¡Áø VNPERSON Å×À̺í·ÎºÎÅ͸¸ ÇàÀ» ¼ö½ÅÇÕ´Ï´Ù. ´Ù¸¥ ±×·ìµéÀº ±¸¼ºµÈ ÇÊÅÍ¿¡ µû¶ó¼ Àüü VNPERSON Å×ÀÌºí ¶Ç´Â VNPERSON Å×À̺íÀÇ Æ¯Á¤ ºÎ¼Ó ÁýÇÕÀ» ¼ö½ÅÇÕ´Ï´Ù.
»ç¿ëÀÚ ·¹º§¿¡¼ µ¥ÀÌÅ͸¦ ÇÊÅÍÇÏ´Â ¹æ¹ý
µµ½Ã=':fcity.' and id=':fid.'
¿©±â¼, :fcity.´Â µµ½Ã Ä÷³ °ª¿¡ ´ëÇÑ ¸Å°³º¯¼öÀ̰í :fid.´Â id Ä÷³ °ª¿¡ ´ëÇÑ ¸Å°³º¯¼öÀÔ´Ï´Ù.
Los Angeles, CA 90061
900000401
»ç¿ëÀÚ´Â Los Angeles, CA 90061 µµ½Ã Ä÷³°ª°ú 900000401 ID Ä÷³°ªÀ» °¡Áø ·¹Äڵ常À» ¼ö½ÅÇÕ´Ï´Ù. ÀÌ °ªÀ» °¡Áø VNPERSON¿¡´Â ÇϳªÀÇ ·¹Äڵ尡 ÀÖ½À´Ï´Ù. µ¿ÀÏ ±×·ì¿¡ ÁöÁ¤µÈ ´Ù¸¥ »ç¿ëÀÚ´Â Los Angeles, CA 90061°ú µ¿ÀÏÇÑ µµ½Ã Ä÷³ °ª°ú ÇØ´ç µ¥ÀÌÅÍ ÇÊÅÍ¿¡ ÀÇÇØ ¼³Á¤µÈ »ç¿ëÀÚ Ä÷³ °ªÀ» °¡Áø VNPERSON Å×À̺í·ÎºÎÅ͸¸ ÇàÀ» ¼ö½ÅÇÕ´Ï´Ù. ´Ù¸¥ ±×·ìµéÀº ±¸¼ºµÈ ÇÊÅÍ¿¡ µû¶ó¼ Àüü VNPERSON Å×ÀÌºí ¶Ç´Â VNPERSON Å×À̺íÀÇ Æ¯Á¤ ºÎ¼Ó ÁýÇÕÀ» ¼ö½ÅÇÕ´Ï´Ù.
µ¥ÀÌÅͺ£À̽º ¹× »ç¿ëÀÚ °ü¸®ÀÇ ÀϺΠ»óȲ¿¡¼´Â ±×·ì ¶Ç´Â »ç¿ëÀÚ°¡ º¼ ¼ö ÀÖ´Â ÇàÀ» Á¦ÇÑÇϱâ À§ÇØ °³º° »ç¿ëÀÚÀÇ Çà ºÎ¼Ó ÁýÇÕ Çʵ忡 º¹ÀâÇÑ SQL WHERE ÀýÀ» Á¤ÀÇÇØ¾ß ÇÕ´Ï´Ù. ÇÊÅ͸¦ Á¤ÀÇÇÒ ¶§¿¡´Â ¹Ì·¯ µ¥ÀÌÅͺ£À̽º¿¡ Å×À̺íÀ» ÂüÁ¶Çϰųª ±×·ì ¶Ç´Â »ç¿ëÀÚ¿¡ ´ëÇÑ ¸Å°³º¯¼ö¸¦ »ç¿ëÇϰųª ÀÌ·¯ÇÑ ¹æ¹ýµéÀ» °áÇÕÇÏ¿© »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. °£´ÜÇÑ ¼öÆò ÇÊÅÍ ÀÛ¼ºÀÇ ±âº» ´Ü°è´Â °£´ÜÇÑ ¼öÆò ÇÊÅÍ Á¤ÀǸ¦ ÂüÁ¶ÇϽʽÿÀ.
DB2 Everyplace Sync Server´Â ÇÊÅÍ¿Í ÇÔ²² »ç¿ëÇÒ Ç¥ÁØ SQL WHERE ±¸ÇöÀÇ ºÎ¼Ó ÁýÇÕÀ» Á¦°øÇÕ´Ï´Ù. ºÎ¼Ó ÁýÇÕÀÇ ±¸¹®¿¡ ´ëÇØ¼´Â ÇÊÅÍ ±¸¹®¿¡¼ ÂüÁ¶ÇϽʽÿÀ.
´ÙÀ½ÀÇ ¿¹´Â ¹Ì·¯ µ¥ÀÌÅͺ£À̽º¿¡¼ ´Ù¸¥ Å×À̺íÀ» ÂüÁ¶ÇÏ°í ¼öÆò ÇÊÅ͸µÀ» À§ÇØ ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ´Â ¹æ¹ýÀ» ³ªÅ¸³À´Ï´Ù.
Ziptab ¹× Business¶ó°í ÇÏ´Â µÎ °³ÀÇ Å×À̺íÀ» °ü¸®ÇÏ¸ç µÑ ´Ù ¹Ì·¯ µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Ù°í °¡Á¤ÇÕ´Ï´Ù. Ziptab¿¡´Â ƯÁ¤ µµ½Ã¿¡ ´ëÇÑ ¿ìÆí¹øÈ£°¡ ÀÖÀ¸¸ç(Ç¥ 4 ÂüÁ¶), Business´Â ÀϺΠȸ»ç¿Í À̵éÀÇ ¿ìÆí¹øÈ£¸¦ ±â·ÏÇÕ´Ï´Ù(Ç¥ 5 ÂüÁ¶). San Jose, CaliforniaÀÇ »ç¿ëÀÚµéÀÌ ÀÚ½ÅÀÇ µµ½Ã¿¡ ÀÖ´Â »ç¾÷ü¸¸À» º¸°Ô ÇÏ·Á°í ÇÕ´Ï´Ù. ±×·ìÀ» ÀÛ¼ºÇÏ°í ±×·ì¿¡ ÀÌ·¯ÇÑ »ç¿ëÀÚ¸¦ ÁöÁ¤Çß½À´Ï´Ù.
½Ã | ¿ìÆí¹øÈ£ |
---|---|
San Jose | 95141 |
San Jose | 95123 |
Los Angeles | 93002 |
ȸ»ç | ¿ìÆí¹øÈ£ |
---|---|
IBM | 95141 |
My Company | 95123 |
Your Company | 93002 |
Another Company | 94888 |
Çà ÆäÀÌÁöÀÇ °³º° »ç¿ëÀÚÀÇ Çà ºÎ¼Ó ÁýÇÕ Çʵ忡 ´ÙÀ½ÀÇ ÀýÀ» ÀÔ·ÂÇÕ´Ï´Ù.
(Zip) IN (SELECT Zipcode FROM Ziptab WHERE City = ':fcity.')
:fcity.´Â µµ½Ã Ä÷³ °ª¿¡ ´ëÇÑ ¸Å°³º¯¼öÀÌ¸ç ±×·ì¿¡ ´ëÇØ San Jose·Î ¼³Á¤ÇÕ´Ï´Ù.
±×·± ´ÙÀ½, º¹»ç ÀÛ¾÷ ³»¿ª ÀÛ¼º ³ëÆ®ºÏÀ» ¿Ï·áÇÏ°í ´ÝÀ¸½Ê½Ã¿À. °á°úÀûÀ¸·Î,
µ¿±âÈ ÀÌÈÄ »ç¿ëÀÚ´Â ÀÚ½ÅÀÇ ÀåÄ¡¿¡¼ Business Å×ÀÌºí¿¡ ´ÙÀ½ÀÇ
ÇุÀÌ Ç¥½ÃµÊÀ» º¸°Ô µË´Ï´Ù.
Ç¥ 6. »ç¿ëÀÚ°¡ ÀÚ½ÅÀÇ ÀåÄ¡¿¡¼ º¼ Çà
ȸ»ç | ¿ìÆí¹øÈ£ |
---|---|
IBM | 95141 |
My Company | 95123 |
MDAC(Mobile Devices Administration Center)¿¡¼ º¹Á¦ º¹»ç ÀÛ¾÷ ³»¿ªÀ» ÀÛ¼ºÇÒ ¶§ °³º° »ç¿ëÀÚ¸¦ ÇÊÅ͸µÇϱâ À§ÇØ SQL¿¡ WHERE Àý°ú À¯»çÇÑ ÀýÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. DataPropagator º¹»ç ÀÛ¾÷ ³»¿ª¿¡ ´ëÇÑ °í±Þ º¹Á¦ º¹»ç ÀÛ¾÷ ³»¿ª ³ëÆ®ºÏÀ̳ª JDBC º¹»ç ÀÛ¾÷ ³»¿ª¿¡ ´ëÇÑ °í±Þ º¹Á¦ º¹»ç ÀÛ¾÷ ³»¿ª ³ëÆ®ºÏÀÇ °³º° »ç¿ëÀÚÀÇ Çà ºÎ¼Ó ÁýÇÕ Çʵ忡 ÀÌ ÀýÀ» ÀÔ·ÂÇϽʽÿÀ.
¾Æ·¡ÀÇ ±¸¹® ´ÙÀ̾î±×·¥À» »ç¿ëÇÒ ¶§´Â Á¦ÇÑ»çÇ×ÀÌ ÀÖ½À´Ï´Ù. Á¦ÇÑ»çÇ×Àº ´ÙÀ½°ú °°½À´Ï´Ù.
ÇÊÅÍ .-logic operator AND or OR-. V | >>---| dimension |------------+-------------------------------->< dimension |--+-column-name--IN--| subselect |-----------+-----------------| | .-,-----------. | | V | | +-(----column-name-+--)--IN--| subselect |-+ '-| simpleUnaryFilter |--------------------' subselect |--(--| selectClause |--| fromClause |--+-----------------+-----> '-| whereClause |-' >--)------------------------------------------------------------| selectClause .-,-----------. V | |--SELECT----column-name-+--------------------------------------| fromClause |--FROM--| tableReference |-------------------------------------| whereClause |--WHERE--| simpleFilter |--------------------------------------| tableReference |--+----------------+--table-name-------------------------------| '-schema-name--.-' simpleFilter .-logic operator AND or OR-. V | |----| simpleUnaryFilter |----+---------------------------------| simpleUnaryFilter |--+-NOT--| simpleUnaryFilter |-+-------------------------------| +-(--| simpleFilter |--)-----+ '-| simplePredicate |--------' simplePredicate |--| expression |--| simplePredicateEnd |-----------------------| expression |--+-| function |-+---------------------------------------------| +-column-name--+ '-| constant |-' function |--+----------------+--function-name--(-------------------------> '-schema-name--.-' >--+--------------------+--)------------------------------------| | .-,--------------. | | V | | '---| expression |-+-' simplePredicateEnd |--+-+-| operator |-+--| expression |----------------------+----| | '-IN-----------' | +-IS--+-----+--NULL-------------------------------------+ | '-NOT-' | '-+-----+--BETWEEN--| expression |--AND--| expression |-' '-NOT-' operator |--+-=----+-----------------------------------------------------| +-<>---+ +->----+ +-<----+ +->=---+ +-<=---+ +-!=---+ +-!<---+ +-!>---+ '-LIKE-'