IBM Books

Net.Data ÂüÁ¶¼­


¼öÇÐ ÇÔ¼ö

ÀÌ ÇÔ¼ö¸¦ ÅëÇØ ¼öÇÐÀû °è»êÀ» ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.

UNIX, Windows NT ¹× OS/2¿¡ ´ëÇÑ ¼º´É ÆÁ: Net.Data ÃʱâÈ­ ÆÄÀÏÀ̳ª ¸ÅÅ©·Î ÆÄÀÏ¿¡¼­ DTW_OPTIMIZE_MATH ±¸¼º °ªÀ» YES·Î ¼³Á¤ÇÏ¿© ÀÌ ±¸¼º °ªÀ¸·Î ¼öÇÐ ÇÔ¼öÀÇ ¼º´ÉÀ» ÃÖÀûÈ­ÇÒ ¼ö ÀÖ½À´Ï´Ù.

ÀÌ º¯¼ö ±¸¼º ¹æ¹ý¿¡ ´ëÇØ¼­´Â Net.Data Administration and Programming GuideÀÇ ±¸¼º º¯¼ö ÀýÀ» Âü°íÇϽʽÿÀ.

DTW_ADD


AIX HP-UX OS/2 OS/390 OS/400 SCO SUN Win NT
X X X X X X X X

¸ñÀû

µÎ ¸Å°³º¯¼öÀÇ °ªµéÀ» Ãß°¡ÇÕ´Ï´Ù.

Çü½Ä

@DTW_ADD(number1, number2, precision, result)

@DTW_rADD(number1, number2, precision)

°ª

Ç¥ 37. DTW_ADD ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
ºÎµ¿ number1 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
ºÎµ¿ number2 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
Á¤¼ö precision IN °á°úÀÇ Á¤¹Ðµµ¸¦ ÁöÁ¤ÇÏ´Â Àüü ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. »ý·«½Ã °ªÀº 9ÀÔ´Ï´Ù.
ºÎµ¿ result OUT number1°ú number2ÀÇ ÇÕ°è°¡ µé¾î ÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1:

@DTW_ADD(NUM1, NUM2, "2", result)

¿¹Á¦ 2:

@DTW_rADD("12", NUM2,
"5")

DTW_DIVIDE


AIX HP-UX OS/2 OS/390 OS/400 SCO SUN Win NT
X X X X X X X X

¸ñÀû

ù¹øÂ° ¸Å°³º¯¼ö °ªÀ» µÎ¹øÂ° ¸Å°³º¯¼ö °ªÀ¸·Î ³ª´¯´Ï´Ù.

Çü½Ä

@DTW_DIVIDE(number1, number2, precision, result)

@DTW_rDIVIDE(number1, number2, precision)

°ª

Ç¥ 38. DTW_DIVIDE ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
ºÎµ¿ number1 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
ºÎµ¿ number2 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
Á¤¼ö precision IN °á°úÀÇ Á¤¹Ðµµ¸¦ ÁöÁ¤ÇÏ´Â Àüü ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. »ý·«½Ã °ªÀº 9ÀÔ´Ï´Ù.
ºÎµ¿ result OUT number1À» number2·Î ³ª´« °á°ú°¡ µé¾î ÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1:

@DTW_DIVIDE("8.0", NUM2,
result)

¿¹Á¦ 2:

@DTW_rDIVIDE("1", NUM2,
"5")

¿¹Á¦ 3:

@DTW_rDIVIDE(NUM1, "2",
"5")

DTW_DIVREM


AIX HP-UX OS/2 OS/390 OS/400 SCO SUN Win NT
X X X X X X X X

¸ñÀû

ù¹øÂ° ¸Å°³º¯¼ö¸¦ µÎ¹øÂ° ¸Å°³º¯¼ö·Î ³ª´« ³ª¸ÓÁö¸¦ ¸®ÅÏÇÕ´Ï´Ù. ³ª¸ÓÁö°¡ 0ÀÌ ¾Æ´Ñ °æ¿ì, ³ª¸ÓÁöÀÇ ºÎÈ£´Â ù¹øÂ° ¸Å°³º¯¼öÀÇ ºÎÈ£¿Í °°½À´Ï´Ù.

Çü½Ä

@DTW_DIVREM(number1, number2, precision, result)

@DTW_rDIVREM(number1, number2, precision)

°ª

Ç¥ 39. DTW_DIVREM ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
ºÎµ¿ number1 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
ºÎµ¿ number2 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
Á¤¼ö precision IN °á°úÀÇ Á¤¹Ðµµ¸¦ ÁöÁ¤ÇÏ´Â Àüü ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. »ý·«½Ã °ªÀº 9ÀÔ´Ï´Ù.
ºÎµ¿ result OUT number1À» number2·Î ³ª´« ³ª¸ÓÁö°¡ µé¾î ÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1:

@DTW_DIVREM(NUM1, NUM2,
result)

¿¹Á¦ 2:

@DTW_rDIVREM("10",
NUM2)

¿¹Á¦ 3:

@DTW_rDIVREM("3.6", "1.3")

¿¹Á¦ 4:

@DTW_rDIVREM("-10", "3")

DTW_FORMAT


AIX HP-UX OS/2 OS/390 OS/400 SCO SUN Win NT
X X X X X X X X

¸ñÀû

¼ýÀÚÀÇ Çü½ÄÀ» Á¶Á¤ÇÕ´Ï´Ù. number ¸Å°³º¯¼ö¸¸ ÁöÁ¤µÇ¸é °á°ú´Â @DTW_rADD(number,"0")°¡ ¼öÇàµÈ °Íó·³ Çü½ÄÈ­µË´Ï´Ù. ´Ù¸¥ ¿É¼ÇÀÌ ÁöÁ¤µÇ´Â °æ¿ì, ´ÙÀ½ ±ÔÄ¢¿¡ µû¶ó ¼ýÀÚ°¡ Çü½ÄÈ­µË´Ï´Ù.

Çü½Ä

@DTW_FORMAT(number, before, after, expp, expt, precision, result)

@DTW_rFORMAT(number, before, after, expp, expt, precision)

°ª

Ç¥ 40. DTW_FORMAT ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
ºÎµ¿ number IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
Á¤¼ö before IN ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. À̰ÍÀº ¼±ÅÃÀû ¸Å°³º¯¼öÀÔ´Ï´Ù. Ãß°¡ ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ·Á¸é ³Î(NULL) ¹®ÀÚ¿­("")À» ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù.
Á¤¼ö after IN ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. À̰ÍÀº ¼±ÅÃÀû ¸Å°³º¯¼öÀÔ´Ï´Ù. Ãß°¡ ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ·Á¸é ³Î(NULL) ¹®ÀÚ¿­("")À» ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù.
Á¤¼ö expp IN ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. Ãß°¡ ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ·Á¸é ³Î(NULL) ¹®ÀÚ¿­("")À» ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù.
Á¤¼ö expt IN ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. Ãß°¡ ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ·Á¸é ³Î(NULL) ¹®ÀÚ¿­("")À» ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù.
Á¤¼ö precision IN °á°úÀÇ Á¤¹Ðµµ¸¦ ÁöÁ¤ÇÏ´Â Àüü ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. »ý·«½Ã °ªÀº 9ÀÔ´Ï´Ù.
ºÎµ¿ result OUT ÁöÁ¤µÈ ¹Ý¿Ã¸² Çü½ÄÀ¸·Î µÈ ¼ýÀÚ°¡ µé¾îÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1:

@DTW_FORMAT(NUM, BEFORE,
result)

¿¹Á¦ 2:

@DTW_FORMAT("1.73", "4", "0", result)

¿¹Á¦ 3:

@DTW_FORMAT("1.73", "4", "3", result)

¿¹Á¦ 4:

@DTW_FORMAT(" - 12.73", "", "4", result)

¿¹Á¦ 5:

@DTW_FORMAT("12345.73", "", "", "2", "2", result)

¿¹Á¦ 6:

@DTW_FORMAT("1.234573", "", "3", "", "0", result)

¿¹Á¦ 7:

@DTW_rFORMAT(" - 12.73")

¿¹Á¦ 8:

@DTW_rFORMAT("0.000")

¿¹Á¦ 9:

@DTW_rFORMAT("12345.73", "", "", "3", "6")

¿¹Á¦ 10:

@DTW_rFORMAT("1234567e5", "", "3", "0")

¿¹Á¦ 11:

@DTW_rFORMAT("12345.73", "", "3", "", "0")

DTW_INTDIV


AIX HP-UX OS/2 OS/390 OS/400 SCO SUN Win NT
X X X X X X X X

¸ñÀû

ù¹øÂ° ¸Å°³º¯¼ö¸¦ µÎ¹øÂ° ¸Å°³º¯¼ö·Î ³ª´« ¸òÀÇ Á¤¼ö ºÎºÐÀ» ¸®ÅÏÇÕ´Ï´Ù.

Çü½Ä

@DTW_INTDIV(number1, number2, precision, result)

@DTW_rINTDIV(number1, number2, precision)

°ª

Ç¥ 41. DTW_INTDIV ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
ºÎµ¿ number1 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
ºÎµ¿ number2 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
Á¤¼ö precision IN °á°úÀÇ Á¤¹Ðµµ¸¦ ÁöÁ¤ÇÏ´Â Àüü ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. »ý·«½Ã °ªÀº 9ÀÔ´Ï´Ù.
ºÎµ¿ result OUT number1À» number2·Î ³ª´« ¸òÀÇ Á¤¼ö ºÎºÐÀÌ µé¾î ÀÖ´Â º¯¼ö.

¿¹


¿¹Á¦ 1:

@DTW_INTDIV(NUM1, NUM2,
result)

¿¹Á¦ 2:

@DTW_rINTDIV("2",
NUM2)

DTW_MULTIPLY


AIX HP-UX OS/2 OS/390 OS/400 SCO SUN Win NT
X X X X X X X X

¸ñÀû

µÎ ¸Å°³º¯¼ö¸¦ °öÇÏ¿© °á°ú¸¦ ¸®ÅÏÇÕ´Ï´Ù.

Çü½Ä

@DTW_MULTIPLY(number1, number2, precision, result)

@DTW_rMULTIPLY(number1, number2, precision)

°ª

Ç¥ 42. DTW_MULTIPLY ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
ºÎµ¿ number1 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
ºÎµ¿ number2 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
Á¤¼ö precision IN °á°úÀÇ Á¤¹Ðµµ¸¦ ÁöÁ¤ÇÏ´Â Àüü ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. »ý·«½Ã °ªÀº 9ÀÔ´Ï´Ù.
ºÎµ¿ result OUT number1°ú number2¸¦ °öÇÑ °ªÀÌ µé¾î ÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1:

@DTW_MULTIPLY(NUM1, NUM2, result)

¿¹Á¦ 2:

@DTW_rMULTIPLY("0.9",
NUM2)

DTW_POWER


AIX HP-UX OS/2 OS/390 OS/400 SCO SUN Win NT
X X X X X X X X

¸ñÀû

µÎ¹øÂ° ¸Å°³º¯¼öÀÇ Ã¹¹øÂ° ¸Å°³º¯¼ö ½ÂÀ» ±¸ÇÏ°í °á°ú¸¦ ¸®ÅÏÇÕ´Ï´Ù.

Çü½Ä

@DTW_POWER(number1, number2, precision, result)

@DTW_rPOWER(number1, number2, precision)

°ª

Ç¥ 43. DTW_POWER ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
ºÎµ¿ number1 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
ºÎµ¿ number2 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
Á¤¼ö precision IN °á°úÀÇ Á¤¹Ðµµ¸¦ ÁöÁ¤ÇÏ´Â Àüü ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. »ý·«½Ã °ªÀº 9ÀÔ´Ï´Ù.
ºÎµ¿ result OUT number2ÀÇ number1 ½ÂÀ» Æ÷ÇÔÇÏ´Â º¯¼ö.

¿¹

¿¹Á¦ 1:

@DTW_POWER(NUM1, NUM2,
result)

¿¹Á¦ 2:

@DTW_rPOWER("1.7", NUM2, precision)

DTW_SUBTRACT


AIX HP-UX OS/2 OS/390 OS/400 SCO SUN Win NT
X X X X X X X X

¸ñÀû

ù¹øÂ° ¸Å°³º¯¼ö °ª¿¡¼­ µÎ¹øÂ° ¸Å°³º¯¼ö °ªÀ» »©°í °á°ú¸¦ ¸®ÅÏÇÕ´Ï´Ù.

Çü½Ä

@DTW_SUBTRACT(number1, number2, precision, result)

@DTW_rSUBTRACT(number1, number2, precision)

°ª

Ç¥ 44. DTW_SUBTRACT ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
ºÎµ¿ number1 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
ºÎµ¿ number2 IN ¼ýÀÚ¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
Á¤¼ö precision IN °á°úÀÇ Á¤¹Ðµµ¸¦ ÁöÁ¤ÇÏ´Â Àüü ¾ç¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. »ý·«½Ã °ªÀº 9ÀÔ´Ï´Ù.
ºÎµ¿ result OUT number1°ú number2ÀÇ Â÷°¡ µé¾î ÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1:

@DTW_SUBTRACT(NUM1, NUM2, comp)
%IF(comp > "0")
<P>$(NUM1) is larger than  $(NUM2).
%ENDIF

ÀÌ ¿¹Á¦¿¡´Â Net.Data¿¡ ÀÖ´Â ¹®ÀÚ¿­¿¡ ÇØ´çÇÏ´Â ¼ýÀÚ °ªÀ» ºñ±³ÇÏ´Â ¹æ¹ýÀÌ Á¦°øµË´Ï´Ù.

¿¹Á¦ 2:

@DTW_SUBTRACT(NUM1, NUM2, result)

¿¹Á¦ 3:

@DTW_rSUBTRACT("1.3",
NUM2)


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