IBM Books

Net.Data ÂüÁ¶¼­


´Ü¾î ÇÔ¼ö

ÀÌ ÇÔ¼ö´Â ´Ü¾î³ª ´Ü¾î ¼¼Æ®¸¦ ¼öÁ¤ÇÏ¿© ¹®ÀÚ¿­ ÇÔ¼ö¸¦ º¸ÃæÇÕ´Ï´Ù. 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°¡ Áö¿øÇÏ´Â ´Ü¾î ÇÔ¼ö´Â ´ÙÀ½°ú °°½À´Ï´Ù.

DTW_DELWORD


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)

°ª

Ç¥ 58. DTW_DELWORD ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ 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")

DTW_SUBWORD


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)

°ª

Ç¥ 59. DTW_SUBWORD ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ 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")

DTW_WORD


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)

°ª

Ç¥ 60. DTW_WORD ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ 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")

DTW_WORDINDEX


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)

°ª

Ç¥ 61. DTW_WORDINDEX ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ 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")

DTW_WORDLENGTH


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

DTW_WORDPOS


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)

°ª

Ç¥ 63. DTW_WORDPOS ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ 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")

DTW_WORDS


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)

°ª

Ç¥ 64. DTW_WORDS ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ stringIn IN º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿­.
¹®ÀÚ¿­ stringOut OUT stringIn¿¡ ÀÖ´Â ´Ü¾î ¼ö¸¦ Æ÷ÇÔÇÏ´Â º¯¼ö.

¿¹

¿¹Á¦ 1:

@DTW_WORDS("Now is the time", result)

¿¹Á¦ 2:

@DTW_rWORDS(" ")


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]