ÀÌ ÇÔ¼ö´Â ´Ü¾î³ª ´Ü¾î ¼¼Æ®¸¦ ¼öÁ¤ÇÏ¿© ¹®ÀÚ¿ ÇÔ¼ö¸¦ º¸ÃæÇÕ´Ï´Ù. Net.Data´Â ´Ü¾î¸¦ °ø¹éÀ¸·Î ºÐ¸®µÇ´Â ¹®ÀÚ¿·Î ÇØ¼®Çϰųª, ¾çÂÊ¿¡ °ø¹éÀÌ ÀÖ´Â ¹®ÀÚ¿·Î ÇØ¼®ÇÕ´Ï´Ù. ¸î°¡Áö ¿¹´Â ´ÙÀ½°ú °°½À´Ï´Ù.
¹®ÀÚ¿ °ª | ´Ü¾î ¼ö |
---|---|
one two three | 3 |
one , two , three | 5 |
Part 2: Internet Sales Grow | 5 |
OS/390, OS/2, Windows NT ¹× UNIX¿¡ ´ëÇÑ MBCS Áö¿ø: DTW_MBMODE ±¸¼º °ªÀ» »ç¿ëÇÏ¿© ´Ü¾î ¹× ¹®ÀÚ¿ ÇÔ¼ö¿¡ ´ëÇÑ MBCS(´ÙÁß ¹ÙÀÌÆ® ¹®ÀÚ ¼¼Æ®) Áö¿øÀ» ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. Net.Data ÃʱâÈ ÆÄÀÏ¿¡¼ ÀÌ °ªÀ» ÁöÁ¤ÇϽʽÿÀ. »ý·«½Ã °ªÀº Áö¿øÇÏÁö ¾Ê´Â °ÍÀÔ´Ï´Ù. Net.Data ¸ÅÅ©·Î ÆÄÀÏ¿¡¼ DTW_MBMODE º¯¼ö¸¦ ¼³Á¤ÇÏ¿© ÃʱâÈ ÆÄÀÏÀÇ ÇØ´ç °ªÀ» ±³Ã¼ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº Net.Data Administration and Programming Guide ¿Í DTW_MBMODE¸¦ Âü°íÇϽʽÿÀ.
OS/400¿¡ ´ëÇÑ MBCS Áö¿ø: DBCS Áö¿øÀº ÀÚµ¿À¸·Î Á¦°øµÇ¸ç ÀÌ º¯¼ö¸¦ ¿ä±¸ÇÏÁö ¾Ê½À´Ï´Ù.
Net.Data°¡ Áö¿øÇÏ´Â ´Ü¾î ÇÔ¼ö´Â ´ÙÀ½°ú °°½À´Ï´Ù.
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÀÔ·Â ¹®ÀÚ¿ÀÇ ºÎ¼Ó ¹®ÀÚ¿À» ¸®ÅÏÇÕ´Ï´Ù. n ´Ü¾î¿¡¼ ½ÃÀÛÇÏ¿© length¿¡ ÀÇÇØ ÁöÁ¤µÈ ´Ü¾î¼ö ¸¸Å ´Ü¾î°¡ »èÁ¦µË´Ï´Ù.
Çü½Ä
@DTW_DELWORD(stringIn, n, length, stringOut)
@DTW_DELWORD(stringIn, n, stringOut)
@DTW_rDELWORD(stringIn, n, length)
@DTW_rDELWORD(stringIn, n)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | stringIn | IN | º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿. |
Á¤¼ö | n | IN | »èÁ¦µÉ ù¹øÂ° ´Ü¾îÀÇ ´Ü¾î À§Ä¡. |
Á¤¼ö | length | IN | »èÁ¦ÇÒ ´Ü¾î ¼ö. »ý·«½Ã °ªÀº n¿¡¼ stringIn ³¡±îÁö ¸ðµç ´Ü¾î¸¦ »èÁ¦ÇÏ´Â °ÍÀÔ´Ï´Ù. ¼±Åà °¡´É ¸Å°³º¯¼ö. |
¹®ÀÚ¿ | stringOut | OUT | ¼öÁ¤µÈ stringIn À¯ÇüÀÌ µé¾î ÀÖ´Â º¯¼ö. |
¿¹
¿¹Á¦ 1:
@DTW_DELWORD("Now is the time", "5", result)
¿¹Á¦ 2:
@DTW_DELWORD("Now is the time", "2", result)
¿¹Á¦ 3:
@DTW_DELWORD("Now is the time", "2", "2", result)
¿¹Á¦ 4:
@DTW_rDELWORD("Now is the time.", "3")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÀÔ·Â ¹®ÀÚ¿ÀÇ ºÎ¼Ó ¹®ÀÚ¿À» ¸®ÅÏÇÕ´Ï´Ù. ºÎ¼Ó ¹®ÀÚ¿Àº ´Ü¾î n¿¡¼ ½ÃÀ۵ǰí length¿¡¼ ÁöÁ¤ÇÏ´Â ´Ü¾îÀÇ ¼ö¸¸Å °è¼ÓµË´Ï´Ù.
Çü½Ä
@DTW_SUBWORD(stringIn, n, length, stringOut)
@DTW_SUBWORD(stringIn, n, stringOut)
@DTW_rSUBWORD(stringIn, n, length)
@DTW_rSUBWORD(stringIn, n)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | stringIn | IN | º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿. |
Á¤¼ö | n | IN | ºÎ¼Ó ¹®ÀÚ¿ ù¹øÂ° ´Ü¾îÀÇ ´Ü¾î À§Ä¡. ÀÌ °ªÀÌ stringInÀÇ ´Ü¾î ¼öº¸´Ù ´õ Å©¸é ³Î(NULL)ÀÌ ¸®Åϵ˴ϴÙ. |
Á¤¼ö | length | IN | ºÎ¼Ó ¹®ÀÚ¿¿¡ ÀÖ´Â ´Ü¾î ¼ö. ÀÌ °ªÀÌ n¿¡¼ stringIn ³¡±îÁöÀÇ ´Ü¾î ¼öº¸´Ù ´õ Å©¸é stringIn ³¡±îÁö ¸ðµç ´Ü¾î°¡ ¸®Åϵ˴ϴÙ. »ý·«½Ã °ªÀº n¿¡¼ stringIn ³¡±îÁö ¸ðµç ´Ü¾î¸¦ ¸®ÅÏÇÏ´Â °ÍÀÔ´Ï´Ù. |
¹®ÀÚ¿ | stringOut | OUT | n°ú length¿¡ ÀÇÇØ ÁöÁ¤µÈ stringInÀÇ ºÎ¼Ó ¹®ÀÚ¿ÀÌ Æ÷ÇÔµÈ º¯¼ö. |
¿¹
¿¹Á¦ 1:
@DTW_SUBWORD("Now is the time", "5", result)
¿¹Á¦ 2:
@DTW_SUBWORD("Now is the time", "2", result)
¿¹Á¦ 3:
@DTW_SUBWORD(Now is the time", "2", "2", result)
¿¹Á¦ 4:
@DTW_rSUBWORD("Now is the time", "3")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÀÔ·Â ¹®ÀÚ¿ÀÇ ÁöÁ¤µÈ À§Ä¡·ÎºÎÅÍ ´Ü¾î Çϳª¸¦ ¸®ÅÏÇÕ´Ï´Ù.
Çü½Ä
@DTW_WORD(stringIn, n, stringOut)
@DTW_rWORD(stringIn, n)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | stringIn | IN | º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿. |
Á¤¼ö | n | IN | ¸®ÅÏÇÒ ´Ü¾îÀÇ ´Ü¾î À§Ä¡. ÀÌ °ªÀÌ stringIn¿¡ ÀÖ´Â ´Ü¾î ¼öº¸´Ù ´õ Å©¸é ³Î(NULL)°ªÀÌ ¸®Åϵ˴ϴÙ. |
¹®ÀÚ¿ | stringOut | OUT | ´Ü¾î À§Ä¡ n¿¡ ´Ü¾î°¡ µé¾î ÀÖ´Â º¯¼ö. |
¿¹
¿¹Á¦ 1:
@DTW_WORD("Now is the time", "3", result)
¿¹Á¦ 2:
@DTW_WORD("Now is the time", "5", result)
¿¹Á¦ 3:
@DTW_rWORD("Now is the time", "4")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÀÔ·Â ¹®ÀÚ¿¿¡¼ n¹øÂ° ´Ü¾îÀÇ Ã¹¹øÂ° ¹®ÀÚÀÇ À§Ä¡¸¦ ¸®ÅÏÇÕ´Ï´Ù.
Çü½Ä
@DTW_WORDINDEX(stringIn, n, stringOut)
@DTW_rWORDINDEX(stringIn, n)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | stringIn | IN | º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿. |
Á¤¼ö | n | IN | »öÀÎÀ¸·Î ¸¸µé ´Ü¾îÀÇ À§Ä¡. ÀÌ °ªÀÌ ÀÔ·Â ¹®ÀÚ¿ÀÇ ´Ü¾î ¼öº¸´Ù Å« °æ¿ì 0ÀÌ ¸®Åϵ˴ϴÙ. |
¹®ÀÚ¿ | stringOut | OUT | stringInÀÇ n¹øÂ° ´Ü¾îÀÇ ¹®ÀÚ À§Ä¡¸¦ Æ÷ÇÔÇÏ´Â º¯¼ö. |
¿¹
¿¹Á¦ 1:
@DTW_WORDINDEX("Now is the time", "3", result)
¿¹Á¦ 2:
@DTW_WORDINDEX("Now is the time", "6", result)
¿¹Á¦ 3:
@DTW_rWORDINDEX("Now is the time", "2")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÀÔ·Â ¹®ÀÚ¿¿¡¼ n¹øÂ° ´Ü¾îÀÇ ±æÀ̸¦ ¸®ÅÏÇÕ´Ï´Ù.
Çü½Ä
@DTW_WORDLENGTH(stringIn, n, stringOut)
@DTW_rWORDLENGTH(stringIn, n)
°ª
Ç¥ 62. DTW_WORDLENGTH ¸Å°³º¯¼ö
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | stringIn | IN | º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿. |
Á¤¼ö | n | IN | ±æÀ̸¦ ¾Ë°íÀÚ ÇÏ´Â ´Ü¾îÀÇ À§Ä¡. ÀÌ °ªÀÌ ÀÔ·Â ¹®ÀÚ¿ÀÇ ´Ü¾î ¼öº¸´Ù Å« °æ¿ì 0ÀÌ ¸®Åϵ˴ϴÙ. |
¹®ÀÚ¿ | stringOut | OUT | stringInÀÇ n¹øÂ° ´Ü¾îÀÇ ±æÀ̸¦ Æ÷ÇÔÇÏ´Â º¯¼ö. |
¿¹
¿¹Á¦ 1:
@DTW_WORDLENGTH("Now is the time", "1", result)
¿¹Á¦ 2:
@DTW_rWORDLENGTH("Now is the time", "6")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
´Ù¸¥ ¹®ÀÚ¿¿¡¼ ¾î¶² ¹®ÀÚ¿ÀÌ Ã³À½ ³ª¿Ã ¶§ ±× ´Ü¾î ¼ö¸¦ ¸®ÅÏÇÕ´Ï´Ù. ¿©·¯ °ø¹éÀº ºñ±³¸¦ À§ÇØ ´ÜÀÏ °ø¹éÀ¸·Î Ãë±ÞµË´Ï´Ù. ºñ±³½Ã ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇÕ´Ï´Ù.
Çü½Ä
@DTW_WORDPOS(stringIn1, stringIn2, n, stringOut)
@DTW_WORDPOS(stringIn1, stringIn2, stringOut)
@DTW_rWORDPOS(stringIn1, stringIn2, n)
@DTW_rWORDPOS(stringIn1, stringIn2)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | stringIn1 | IN | º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿. |
¹®ÀÚ¿ | stringIn2 | IN | Ž»öÇÒ ¸®ÅÍ·² ¹®ÀÚ¿ ¶Ç´Â º¯¼ö. |
Á¤¼ö | n | IN | Ž»öÀ» ½ÃÀÛÇÒ stringIn2 ³»ÀÇ ´Ü¾î À§Ä¡. ÀÌ °ªÀÌ stringIn2¿¡ ÀÖÀº ´Ü¾î ¼öº¸´Ù ´õ Å©¸é 0ÀÌ ¸®Åϵ˴ϴÙ. »ý·«½Ã °ªÀº stringIn2ÀÇ ½ÃÀÛ ºÎºÐ¿¡¼ Ž»öÀ» ½ÃÀÛÇÏ´Â °ÍÀÔ´Ï´Ù. |
¹®ÀÚ¿ | stringOut | OUT | stringIn2¿¡¼ stringIn1ÀÇ ´Ü¾î À§Ä¡. |
¿¹
¿¹Á¦ 1:
@DTW_WORDPOS("the", "Now is the time", result)
¿¹Á¦ 2:
@DTW_WORDPOS("The", "Now is the time", result)
¿¹Á¦ 3:
@DTW_WORDPOS("The", "Now is the time", "5", result)
¿¹Á¦ 4:
@DTW_WORDPOS("is the", "Now is the time", result)
¿¹Á¦ 5:
@DTW_rWORDPOS("be", "To be or not to be", "3")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
¹®ÀÚ¿¿¡ ÀÖ´Â ´Ü¾î ¼ö¸¦ ¸®ÅÏÇÕ´Ï´Ù.
Çü½Ä
@DTW_WORDS(stringIn, stringOut)
@DTW_rWORDS(stringIn)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | stringIn | IN | º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿. |
¹®ÀÚ¿ | stringOut | OUT | stringIn¿¡ ÀÖ´Â ´Ü¾î ¼ö¸¦ Æ÷ÇÔÇÏ´Â º¯¼ö. |
¿¹
¿¹Á¦ 1:
@DTW_WORDS("Now is the time", result)
result = "4"
¿¹Á¦ 2:
@DTW_rWORDS(" ")