IBM Books

Net.Data ÂüÁ¶¼­


ÀÏ¹Ý ÇÔ¼ö

ÀÏ¹Ý ÇÔ¼ö´Â Net.Data¸¦ »ç¿ëÇÏ¿© À¥ ÆäÀÌÁö¸¦ °³¹ßÇÏ´Â µ¥ µµ¿òÀ» ÁÖ¸ç ´Ù¸¥ ¹üÁÖ¿¡´Â ¸ÂÁö ¾Ê½À´Ï´Ù. ÀÏ¹Ý ÇÔ¼ö´Â ´ÙÀ½°ú °°½À´Ï´Ù.

DTW_ADDQUOTE


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

¸ñÀû

ÀÔ·Â ¹®ÀÚ¿­ÀÇ ÀÛÀº µû¿ÈÇ¥ Çϳª¸¦ ÀÛÀº µû¿ÈÇ¥ µÎ °³·Î ±³Ã¼ÇÕ´Ï´Ù. ¹®ÀÚ¿­¿¡ ÀÛÀº µû¿ÈÇ¥°¡ Æ÷Ç﵃ ¶§ SQL¹®ÀÌ ¿Ã¹Ù¸£°Ô ó¸®µÉ ¼ö ÀÖµµ·Ï ±³Ã¼ÇÏ´Â °úÁ¤ÀÌ ÇÊ¿äÇÕ´Ï´Ù.

¸ðµç SQL INPUT ¸í·É¹®¿¡ ÀÌ ÇÔ¼ö¸¦ »ç¿ëÇØ º¸½Ê½Ã¿À. ¿¹¸¦ µé¾î, ´ÙÀ½ ¿¹¿¡¼­¿Í °°ÀÌ ¼ºÀ» O'BrienÀ¸·Î ÀÔ·ÂÇϸé ÀÛÀº µû¿ÈÇ¥·Î ÀÎÇØ ¿À·ù°¡ »ý±æ ¼ö ÀÖ½À´Ï´Ù.

INSERT INTO USER1.CUSTABLE (LNAME, FNAME)
VALUES ('O'Brien', 'Patrick')

´ÙÀ½°ú °°ÀÌ DTW_ADDQUOTE ÇÔ¼ö¸¦ »ç¿ëÇϸé SQL¹®ÀÌ º¯°æµÇ¾î ¿À·ù°¡ »ý±âÁö ¾Ê½À´Ï´Ù.

INSERT INTO USER1.CUSTABLE (LNAME, FNAME)
VALUES ('O''Brien', 'Patrick')

Çü½Ä

@DTW_ADDQUOTE(stringIn, stringOut)

@DTW_rADDQUOTE(stringIn)

@DTW_mADDQUOTE(stringMult, stringMult2, ..., stringMultn)

°ª

Ç¥ 25. DTW_ADDQUOTE ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ stringIn IN º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿­. DTW_mADDQUOTE¿¡´Â ¿©·¯ °³ÀÇ ÀÔ·Â ¹®ÀÚ¿­ÀÌ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù.
¹®ÀÚ¿­ stringOut OUT ¼öÁ¤µÈ stringIn À¯ÇüÀÌ µé¾î ÀÖ´Â º¯¼ö.
¹®ÀÚ¿­ stringMult INOUT

  • ÀÔ·Â: ¹®ÀÚ¿­ÀÌ µé¾î ÀÖ´Â º¯¼ö.

  • Ãâ·Â: °¢ ÀÛÀº µû¿ÈÇ¥(')°¡ µÎ °³ÀÇ ÀÛÀº µû¿ÈÇ¥·Î ±³Ã¼µÈ ÀÔ·Â ¹®ÀÚ¿­ÀÌ µé¾î ÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1: OUT ¸Å°³º¯¼ö¿¡ ÀÛÀº µû¿ÈÇ¥¸¦ Ãß°¡ÇÕ´Ï´Ù.

@DTW_ADDQUOTE(string1,string2)

¿¹Á¦ 2: ÇÔ¼ö È£Ãâ·ÎºÎÅÍ ¸®ÅÏµÈ °ª¿¡ ÀÛÀº µû¿ÈÇ¥¸¦ Ãß°¡ÇÕ´Ï´Ù.

@DTW_rADDQUOTE("The title of the article is 'Once upon a time'")

¿¹Á¦ 3: ÇÔ¼ö È£ÃâÀÇ °¢ INOUT ¸Å°³º¯¼ö¿¡ ÀÛÀº µû¿ÈÇ¥¸¦ Ãß°¡ÇÕ´Ï´Ù.

@DTW_mADDQUOTE(string1,string2)

¿¹Á¦ 4: DB2 Å×ÀÌºí¿¡ »ðÀԵǴ ÀÚ·á¿¡ ÀÛÀº µû¿ÈÇ¥¸¦ »ðÀÔÇÕ´Ï´Ù.

%FUNCTION(DTW_SQL) insertName(){
INSERT INTO USER1.CUSTABLE (LNAME,FNAME)
VALUES ('@DTW_rADDQUOTE(lastname)', '@DTW_rADDQUOTE(firstname)')
%}

DTW_CACHE_PAGE


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






¸ñÀû

¸ÅÅ©·Î ÆÄÀÏ¿¡¼­ ÇÔ¼ö ´ÙÀ½¿¡ ³ª¿À´Â ¸ðµç HTML Ãâ·ÂÀÇ Ä³½Ã ÀÛ¾÷À» ½ÃÀÛÇÕ´Ï´Ù. ÀÌ ÇÔ¼ö°¡ È£ÃâµÇ¸é ij½Ã·ÎºÎÅÍ ÁöÁ¤µÈ ÆäÀÌÁö¸¦ °Ë»öÇϰí ÀÌ ÆäÀÌÁö°¡ ¸ÅÅ©·Î·ÎºÎÅÍ »ý¼ºµÈ Ãâ·Â ÆäÀÌÁöÀÎ °Íó·³ À¥ ºê¶ó¿ìÀú·Î ¼Û½ÅÇÏ·Á ÇÕ´Ï´Ù. ÀÌ ÆäÀÌÁö¸¦ ã¾ÒÀ¸¸ç ¾ÆÁ÷ ¸¸±âµÇÁö ¾ÊÀº °æ¿ì Net.Data´Â ¸ÅÅ©·Î 󸮸¦ Áß´ÜÇÏ°í ¸ÅÅ©·Î ÆÄÀϷκÎÅÍ ºüÁ® ³ª°£ ´ÙÀ½ ij½Ã ÆäÀÌÁö¸¦ À¥ ºê¶ó¿ìÀú·Î ¼Û½ÅÇÕ´Ï´Ù.

¿äûµÈ ÆäÀÌÁö°¡ ij½Ã¿¡ ¾ø°Å³ª ±âÁ¸ ij½Ã ÆäÀÌÁö°¡ age °ªº¸´Ù ´õ ¿À·¡µÈ °æ¿ì Net.Data´Â »õ·Î¿î Ãâ·Â ÆäÀÌÁö¸¦ »ý¼ºÇÕ´Ï´Ù. ¸ÅÅ©·Î°¡ ¼º°øÀûÀ¸·Î ¿Ï·áµÇ¸é Net.Data´Â ºê¶ó¿ìÀú·Î »õ·Î¿î ÆäÀÌÁö¸¦ ¼Û½ÅÇϰí ÀÌ ÆäÀÌÁö¸¦ ij½Ã ó¸®ÇÕ´Ï´Ù.

¸ÅÅ©·Î ÆÄÀÏ¿¡¼­ DTW_CACHE_PAGE ÇÔ¼öÀÇ À§Ä¡ ÆÇº°:

Çü½Ä

@DTW_CACHE_PAGE(cacheid, url, age, status)

°ª

Ç¥ 26. DTW_CACHE_PAGE ¸Å°³º¯¼ö
¸Å°³º¯¼ö »ç¿ë ¼³¸í
cache_id IN ÆäÀÌÁö¸¦ ³ÖÀ» ij½Ã¸¦ ½Äº°ÇÏ´Â ¹®ÀÚ¿­ º¯¼ö.
cached_page_ID IN ÈÄ¼Ó DTW_CACHE_PAGE ij½Ã ¿äû¿¡¼­ ij½Ã ó¸®µÈ ÆäÀÌÁö¸¦ ã´Â µ¥ »ç¿ëµÇ´Â ½Äº°ÀÚ°¡ µé¾î ÀÖ´Â ¹®ÀÚ¿­ º¯¼ö. ÀÌ ¹®ÀÚ¿­Àº URLÀÏ ¼ö ÀÖ½À´Ï´Ù.
age IN ÃÊ ´ÜÀ§ÀÇ ½Ã°£À» Æ÷ÇÔÇÏ´Â ¹®ÀÚ¿­ º¯¼ö. ÀÌ ¸Å°³º¯¼ö´Â ÆäÀÌÁö°¡ ¸¸±âµÇ¾ú´ÂÁö ¿©ºÎ¸¦ °áÁ¤ÇÕ´Ï´Ù. ÀÌ ÆäÀÌÁö°¡ age º¸´Ù ´õ ¿À·¡µÈ °æ¿ì ºê¶ó¿ìÀú·Î ¼Û½ÅµÇÁö ¾Ê½À´Ï´Ù.

age°¡ -1·Î ÁöÁ¤µÇ°í ÇØ´ç ÆäÀÌÁö°¡ ij½Ã¿¡ ÀÖÀ¸¸é Net.Data´Â ±× »ç¿ë ±â°£¿¡ °ü°è¾øÀÌ Ä³½Ã¿¡¼­ À¥ ºê¶ó¿ìÀú·Î ÀÌ ÆäÀÌÁö¸¦ Á÷Á¢ ¼Û½ÅÇÕ´Ï´Ù. Net.Data´Â ij½ÃÀÇ ÆäÀÌÁö´Â ¹Ù²ÙÁö ¾Ê½À´Ï´Ù.

status OUT ij½Ã ÆäÀÌÁöÀÇ »óŸ¦ ³ªÅ¸³»´Â ¹®ÀÚ¿­ º¯¼ö. ´ÙÀ½°ú °°Àº ¼Ò¹®ÀÚ·Î µÈ °ªÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.

  • ok: ¸ÅÅ©·Î ½ÇÇàÀÌ Á¾·áµÉ ¶§ Ãâ·Â ÆäÀÌÁö°¡ ij½ÃµË´Ï´Ù.

  • new: ÆäÀÌÁö´Â ij½Ã¿¡ ¾ø½À´Ï´Ù.

  • renew: ÆäÀÌÁö°¡ ij½Ã¿¡ ÀÖÀ¸³ª ¸¸±âµÇ¾ú½À´Ï´Ù.

  • no_cache: ÁöÁ¤µÈ ij½Ã ½Äº°ÀÚ°¡ ¾ø½À´Ï´Ù. ÀÌ ½Äº°Àڴ ij½Ã ±¸¼º ÆÄÀÏ¿¡ Á¤ÀǵǾî¾ß ÇÕ´Ï´Ù. ÆäÀÌÁö ij½Ã ¾øÀÌ ¸ÅÅ©·Î¸¦ °è¼Ó ½ÇÇàÇÒ ¼ö ¾ø½À´Ï´Ù.

  • inactive: ÁöÁ¤ÇÑ Ä³½Ã°¡ ºñȰ¼ºÀ¸·Î Ç¥½ÃµÇ¾î ÀÖ½À´Ï´Ù. ÆäÀÌÁö ij½Ã ¾øÀÌ ¸ÅÅ©·Î¸¦ °è¼Ó ½ÇÇàÇÒ ¼ö ¾ø½À´Ï´Ù.

  • busy: ¸ÅÅ©·Î°¡ ÀÌ ½ÇÇà ÀÌÀü¿¡ DTW_CACHE_PAGE ³»Àå ÇÔ¼ö¸¦ ½ÇÇàÇß½À´Ï´Ù. ¸ÅÅ©·Î¸¦ °è¼Ó ½ÇÇàÇÒ ¼ö ¾ø½À´Ï´Ù.

  • error: ij½Ã¿Í Åë½ÅÇÏ´Â µµÁß ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù.

¿¹

¿¹Á¦ 1: ¸ðµç HTML Ãâ·ÂÀ» ĸóÇϵµ·Ï ¸ÅÅ©·Î ÆÄÀÏ ¸Ç ¾Õ¿¡ DTW_CACHE_PAGE ÇÔ¼ö¸¦ ³Ö½À´Ï´Ù.

%IF (customer_status == "Classic")
@DTW_CACHE_PAGE("mymacro.mac", "http://www.mypage.org", "-1", status)
%ENDIF
 % DEFINE { ...%}
 
...
 
%HTML(OUTPUT) {
 <title>This is the page title
 </head>
 <body>
 <center>
 This is the Main Heading
 <p>It is $(time). Have a nice day!
 </body>
</html>
 
%}

¿¹Á¦ 2: ij½Ã °áÁ¤Àº HTML Ãâ·ÂÀÇ ¿¹»ó Å©±â¿¡ µû¶ó ´Þ¶óÁö¹Ç·Î ÇÔ¼ö¸¦ HTML ij½Ã¿¡ ³Ö½À´Ï´Ù.

% DEFINE { ...%}
 
...
 
%FUNCTION(DTW_SQL) count_rows(){
  select count(*) from customer
%REPORT{
%ROW{
  @DTW_ASSIGN(ALL_ROWS, V1)
%}
%}
%}
 
%FUNCTION(DTW_SQL) all_customers(){
  select * from customer
%}
 
%HTML(OUTPUT) {
<html>
 <head>
 <title>This is the customer list
 </head>
 <body>
 
@count_rows()
 
 %IF ($(ALL_ROWS) > "100")
 @DTW_CACHE_PAGE("mymacro.mac", "http://www.mypage.org", "-1", status)
%ENDIF
 
@all_customers()
 
 </body>
</html>
%}

ÀÌ ¿¹Á¦¿¡¼­ ÆäÀÌÁö´Â HTML Ãâ·ÂÀÇ ¿¹»ó Å©±â¸¦ ±âÃʷΠij½ÃµÇ°Å³ª °Ë»öµË´Ï´Ù. HTML Ãâ·Â ÆäÀÌÁö´Â µ¥ÀÌŸº£À̽º Å×ÀÌºí¿¡ 100°³°¡ ³Ñ´Â ÇàÀÌ µé¾î ÀÖÀ» ¶§¸¸ ij½ÃÇÒ °¡Ä¡°¡ ÀÖ´Â °ÍÀ¸·Î °£Áֵ˴ϴÙ. Net.Data´Â OUTPUT ºí·Ï, This is the customer listÀÇ ÅØ½ºÆ®¸¦ Ç×»ó ¸ÅÅ©·Î¸¦ ½ÇÇàÇÑ ÈÄ¿¡ ºê¶ó¿ìÀú·Î ¼Û½ÅÇϹǷΠÀÌ ÅØ½ºÆ®´Â ij½Ã 󸮵ÇÁö ¾Ê½À´Ï´Ù. ÀÌ ÇÔ¼ö È£Ãâ ´ÙÀ½ Çà, @count_rows()Àº IF ºí·ÏÀÇ Á¶°ÇÀÌ ¸¸Á·µÉ ¶§ ij½Ã 󸮵ǰųª °Ë»öµË´Ï´Ù. µÎ ºÎºÐÀÌ ÇÔ²² ¿Ï¼ºµÈ Net.Data ÆäÀÌÁö¸¦ Çü¼ºÇÕ´Ï´Ù.

¿¹Á¦ 3: ij½Ã ID¿Í ij½Ã ÆäÀÌÁö ID¸¦ µ¿ÀûÀ¸·Î °Ë»öÇÕ´Ï´Ù.

%HTML(OUTPUT) {
 %IF (customer == "Joe Smith")
 
@DTW_CACHE_PAGE(@DTW_rGETENV("DTW_MACRO_FILENAME"), @DTW_rGETENV("URL"),"-1", status)
 
%ENDIF
 
...
 
<html>
 <head>
 <title>This is the page title</title>
 </head>
 <body>
 <center>
 <h3>This is the Main Heading</h3>
 <p>It is @DTW_rDATE(). Have a nice day!
 </body>
</html>
 
%}

DTW_DATE


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

¸ñÀû

ÁöÁ¤µÈ Çü½ÄÀ¸·Î ÇöÀç ½Ã½ºÅÛ ³¯Â¥¸¦ ¸®ÅÏÇÕ´Ï´Ù.

Çü½Ä

@DTW_DATE(format, stringOut)

@DTW_DATE(stringOut)

@DTW_rDATE(format)

@DTW_rDATE()

°ª

Ç¥ 27. DTW_DATE ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ format IN ÀÚ·á Çü½ÄÀ» ÁöÁ¤ÇÏ´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. À¯È¿ÇÑ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

D - ¿¬ Áß ÀÏ (001-366)

E - À¯·´ ³¯Â¥ Çü½Ä (dd/mm/yy)

N - ÀÏ¹Ý ³¯Â¥ Çü½Ä (dd mon yyyy)

O - ¼ø¼­È­µÈ ³¯Â¥ Çü½Ä (yy/mm/dd)

S - Ç¥ÁØ ³¯Â¥ Çü½Ä (yyyymmdd)

U - ¹Ì±¹ ³¯Â¥ Çü½Ä (mm/dd/yy)

»ý·«½Ã °ªÀº NÀÔ´Ï´Ù.

¹®ÀÚ¿­ stringOut OUT ÁöÁ¤µÈ Çü½ÄÀ¸·Î µÈ ³¯Â¥°¡ µé¾îÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1: ÀÏ¹Ý ³¯Â¥ Çü½Ä

@DTW_DATE(results)

¿¹Á¦ 2: À¯·´ ³¯Â¥ Çü½Ä

@DTW_DATE("E", results)

¿¹Á¦ 3: ¹Ì±¹ ³¯Â¥ Çü½Ä

%HTML(report){
<P>This report created on @DTW_rDATE("U").

DTW_EXIT


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

X X X

¸ñÀû

¸ÅÅ©·Î¸¦ Áï½Ã ³ª°¡µµ·Ï ÁöÁ¤ÇÕ´Ï´Ù. Net.Data´Â Áö±Ý±îÁö ¸ÅÅ©·Î°¡ ÀÛ¼ºÇÑ ÆäÀÌÁö¸¦ ºê¶ó¿ìÀú·Î ¼Û½ÅÇϵµ·Ï ÇÕ´Ï´Ù.

¼º´É ÆÁ: Net.Data°¡ Àüü ÆÄÀÏÀ» ó¸®ÇØ¾ß ÇÏ´Â ½Ã°£À» ÀúÀåÇϱâ À§ÇØ Ãâ·ÂÀÌ »ý¼ºµÇ¾úÀ» ¶§ ¸ÅÅ©·Î ÆÄÀÏÀÇ Ã³¸®¸¦ Áß´ÜÇÏ·Á¸é DTW_EXIT¸¦ »ç¿ëÇϽʽÿÀ.

Çü½Ä

@DTW_EXIT()

¿¹

¿¹Á¦ 1: ¸ÅÅ©·Î ³ª°¨

%HTML(cache_example) {
 
<html>
 <head>
 <title>This is the page title</title>
 </head>
 <body>
 <center>
 <h3>This is the Main Heading</h3>
 <!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!>
 <! Joe Smith sees a very short page                   !>
 <!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!>
 %IF (customer == "Joe Smith")
 
@DTW_EXIT()
 
%ENDIF
 
...
 
</body>
</html>
 %}

DTW_GETENV


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

¸ñÀû

ÁöÁ¤µÈ ȯ°æ º¯¼öÀÇ °ªÀ» ¸®ÅÏÇÕ´Ï´Ù. ENVVAR¸¦ »ç¿ëÇÏ¿© ȯ°æ º¯¼ö °ªÀ» ÂüÁ¶ÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº ENVVAR ¸í·É¹®À» Âü°íÇϽʽÿÀ.

Çü½Ä

@DTW_GETENV(envVarName, envVarValue)

@DTW_rGETENV(envVarName)

°ª

Ç¥ 28. DTW_GETENV ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ envVarName IN º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿­.
¹®ÀÚ¿­ envVarValue OUT envVarName¿¡ ÁöÁ¤µÈ ȯ°æ º¯¼öÀÇ °ª. ÀÌ °ªÀÌ ¾øÀ¸¸é ³Î(NULL) ¹®ÀÚ¿­ÀÌ ¸®Åϵ˴ϴÙ.

¿¹

¿¹Á¦ 1: OUT ¸Å°³º¯¼ö¿¡ ´ëÇØ PATH¹®¿¡ ´ëÇÑ °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.

@DTW_GETENV(myEnvVarName, myEnvVarValue)

¿¹Á¦ 2: PATH¹®¿¡ ´ëÇÑ °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.

@DTW_rGETENV(myPath)

¿¹Á¦ 3: ¼­¹öÀÇ À̸§¿¡ ´ëÇÑ °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.

The server is @DTW_rGETENV("SERVER_NAME").

DTW_GETINIDATA


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

¸ñÀû

ÁöÁ¤µÈ ±¸¼º º¯¼öÀÇ °ªÀ» ¸®ÅÏÇÕ´Ï´Ù. °ªÀÌ ¾øÀ¸¸é ³Î(NULL) ¹®ÀÚ¿­ÀÌ ¸®Åϵ˴ϴÙ.

Á¦ÇÑ»çÇ×: ºñ OS/400 ¿î¿µÃ¼Á¦ÀÇ °æ¿ì, ENVIRONMENT¹® »Ó ¾Æ´Ï¶ó ±¸¼º °æ·Î º¯¼ö(MACRO_PATH, EXEC_PATH ¹× INCLUDE_PATH)´Â ÀÌ È£Ãâ·ÎºÎÅÍ °Ë»öÇÒ ¼ö ¾ø½À´Ï´Ù. OS/400 ¿î¿ë ½Ã½ºÅÛ¿¡¼­´Â, ÀÌ·¯ÇÑ Á¦ÇÑÀÌ ENVIRONMENT¹®¿¡¸¸ Àû¿ëµË´Ï´Ù.

Çü½Ä

@DTW_GETINIDATA(iniVarName, iniVarValue)

@DTW_rGETINIDATA(iniVarName)

°ª

Ç¥ 29. DTW_GETINIDATA ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ iniVarName IN º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿­.
¹®ÀÚ¿­ iniVarValue OUT iniVarName¿¡ ÁöÁ¤µÈ ±¸¼º º¯¼öÀÇ °ª.

¿¹

¿¹Á¦ 1: Net.Data °æ·Î º¯¼ö °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.

@DTW_GETINIDATA(myEnvVarName, myEnvVarValue)

DTW_HTMLENCODE


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

¸ñÀû

Ç¥ÁØ HTML ½ÊÁø escape Äڵ带 »ç¿ëÇÏ¿© ¹®ÀÚ¸¦ ÄÚµåÈ­ÇÏ´Â µ¥, ¸ðµç ¹®ÀÚ¸¦ ÄÚµåÈ­ÇÏ´Â °ÍÀº ¾Æ´Õ´Ï´Ù. ÀÌ ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© À¥ ºê¶ó¿ìÀú°¡ HTML·Î ÇØ¼®ÇÏÁö ¾Ê°Ô ÇÏ·Á´Â ÀڷḦ ÄÚµåÈ­ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î ÀûÀýÇÑ escape ¹®ÀÚ¸¦ »ç¿ëÇÏ¿©, º¸Åë HTML ű׷Π¿¹¾àµÇ¾î ÀÖ´Â º¸´Ù ÀÛÀ½(<) ¹× º¸´Ù Å­(>) ±âÈ£¸¦ Ç¥½ÃÇÒ ¼ö ÀÖ½À´Ï´Ù.

´Ù¸¥ ¿¹Á¦¿¡¼­, HTML·Î µÈ ´ÙÀ½ ¹®ÀÚ¿­Àº °¢ ¹øÈ£ »çÀÌ¿¡ ÇϳªÀÇ °ø¹é¸¸ ³ªÅ¸³À´Ï´Ù.

1    2     3

DTW_HTMLENCODE¸¦ »ç¿ëÇÏ¿© °ø¹éÀÇ ¼ö¸¦ ¸Â°Ô Ç¥½ÃÇϽʽÿÀ.

Ç¥ 30¿¡´Â DTW_HTMLENCODE ÇÔ¼ö¿¡ ÀÇÇØ ÄÚµåÈ­µÈ ¹®ÀÚ°¡ ³ªÅ¸³³´Ï´Ù.

Ç¥ 30. HTML ½ÊÁø escape ¹®ÀÚ
¹®ÀÚ À̸§ ÄÚµå
SPACE °ø°£ &#32;
" Å« µû¿ÈÇ¥ &#34;
# ¼ýÀÚ ±âÈ£ &#35;
% ÆÛ¼¾Æ® &#37;
& ¾ÚÆÛ»÷µå &#38;
\ ¿ª½½·¡½¬ &#92;
: ÄÝ·Ð &#58;
; ¼¼¹ÌÄÝ·Ð &#59;
< º¸´Ù ÀÛÀ½ &#60;
= °°À½ &#61:
> º¸´Ù Å­ &#62:
? ¹°À½Ç¥ &#63:
@ À§Ä¡ ±âÈ£ &#64;
[ ¿©´Â ´ë°ýÈ£ &#40;
/ ½½·¡½¬ &#47;
] ´Ý´Â ´ë°ýÈ£ &#41;
^ ij·µ &#94;
{ ¿©´Â Áß°ýÈ£ &#123;
| Á÷¼± &#124;
} ´Ý´Â Áß°ýÈ£ &#125;
~ Æ¿µå &#126;

Çü½Ä

@DTW_HTMLENCODE(stringIn, stringOut)

@DTW_rHTMLENCODE(stringIn)

°ª

Ç¥ 31. DTW_HTMLENCODE ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ stringIn IN º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿­.
¹®ÀÚ¿­ stringOut OUT ƯÁ¤ ¹®ÀÚ°¡ ÄÚµåÈ­µÈ HTML escape ¹®ÀÚ·Î ´ëüµÈ ¼öÁ¤µÈ ÀÔ·Â ¹®ÀÚ¿­ÀÌ µé¾î ÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1: °ø¹é ¹®ÀÚ¸¦ ÄÚµåÈ­ÇÕ´Ï´Ù.

@DTW_HTMLENCODE(string1,string2)

¿¹Á¦ 2: °ø¹é, º¸´Ù ÀÛÀ½ ±âÈ£ ¹× °°À½ ±âÈ£¸¦ ÄÚµåÈ­ÇÕ´Ï´Ù.

@DTW_rHTMLENCODE("X <= 10")

DTW_QHTMLENCODE


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

¸ñÀû

@DTW_HTMLENCODE¿Í °°Àº ÇÔ¼ö¸¦ ¼öÇàÇϰí ÀÛÀº µû¿ÈÇ¥(')¸¦ &#39;·Î ÄÚµåÈ­ÇÕ´Ï´Ù. DTW_QHTMLENCODE°¡ »ç¿ëÇÏ´Â HTML ½ÊÁø escape ¹®Àڴ ǥ 30¿¡ ³ª¿É´Ï´Ù.

Çü½Ä

@DTW_QHTMLENCODE(stringIn, stringOut)

@DTW_rQHTMLENCODE(stringIn)

°ª

Ç¥ 32. DTW_QHTMLENCODE ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ stringIn IN º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿­.
¹®ÀÚ¿­ stringOut OUT ƯÁ¤ ¹®ÀÚ°¡ ÄÚµåÈ­µÈ HTML escape ¹®ÀÚ·Î ´ëüµÈ ¼öÁ¤µÈ ¾ç½ÄÀÇ stringInÀ» Æ÷ÇÔÇÏ´Â º¯¼ö.

¿¹

¿¹Á¦ 1: ¾îÆ÷½ºÆ®·ÎÇÇ¿Í °ø¹éÀ» ÄÚµåÈ­ÇÕ´Ï´Ù.

@DTW_QHTMLENCODE(string1,string2)

¿¹Á¦ 2: ¾îÆ÷½ºÆ®·ÎÇÇ, °ø¹é ¹× ¾ÚÆÛ»÷µå¸¦ ÄÚµåÈ­ÇÕ´Ï´Ù.

@DTW_rQHTMLENCODE("John's & Jane's")

DTW_SETENV


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

¸ñÀû

ÁöÁ¤µÈ °ªÀ¸·Î ȯ°æ º¯¼ö¸¦ ÁöÁ¤Çϰí ÀÌÀü °ªÀ» ¸®ÅÏÇÕ´Ï´Ù. ÀÌÀü °ªÀÌ ¾ø´Â °æ¿ì ³Î(NULL) ¹®ÀÚ¿­ÀÌ ¸®Åϵ˴ϴÙ.

Çü½Ä

@DTW_SETENV(envVarName, envVarValue, prevValue)

@DTW_rSETENV(envVarName, envVarValue)

°ª

Ç¥ 33. DTW_SETENV ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ envVarName IN ȯ°æ º¯¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö.
¹®ÀÚ¿­ envVarValue OUT ȯ°æ º¯¼ö°¡ ÁöÁ¤µÈ °ªÀ» Æ÷ÇÔÇÏ´Â º¯¼ö ¶Ç´Â ¸®ÅͳΠ¹®ÀÚ¿­.
¹®ÀÚ¿­ prevValue OUT ȯ°æ º¯¼öÀÇ ÀÌÀü °ªÀÌ µé¾î ÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1: ÀÌÀü °æ·Î¿¡ ´ëÇÑ °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.

@DTW_SETENV("PATH", "myPath", prevValue)

¿¹Á¦ 2: ÀÌÀü °æ·Î¿¡ ´ëÇÑ °ªÀ» ¸®ÅÏÇϰí PATH¹®¿¡ ´ëÇÑ °ªÀ» ÁöÁ¤ÇÕ´Ï´Ù.

@DTW_rSETENV("PATH", "myPath")

DTW_TIME


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

¸ñÀû

ÁöÁ¤µÈ Çü½ÄÀ¸·Î ÇöÀç ½Ã½ºÅÛ ½Ã°£À» ¸®ÅÏÇÕ´Ï´Ù.

Çü½Ä

@DTW_TIME(stringIn, stringOut)

@DTW_TIME(stringOut)

@DTW_rTIME(stringIn)

@DTW_rTIME()

°ª

Ç¥ 34. DTW_TIME ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ stringIn IN ½Ã°£ Çü½ÄÀ» ÁöÁ¤ÇÏ´Â ¸®ÅÍ·² ¹®ÀÚ¿­ ¶Ç´Â º¯¼ö. À¯È¿ÇÑ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.

C - »ó¿ë ½Ã°£ (12½Ã°£ ½Ã°è¸¦ »ç¿ëÇÏ´Â hh:mmAM/PM)

L - ÇöÁö ½Ã°£ (hh:mm:ss)

N - ÀÏ¹Ý ½Ã°£ (24½Ã°£ ½Ã°è¸¦ »ç¿ëÇÏ´Â hh:mm:ss). »ý·«½Ã °ªÀÓ

H - ÀÚÁ¤ ÀÌÈÄ ½Ã°£

M - ÀÚÁ¤ ÀÌÈÄ ºÐ

S - ÀÚÁ¤ ÀÌÈÄ ÃÊ

¹®ÀÚ¿­ stringOut OUT ÁöÁ¤µÈ Çü½ÄÀ¸·Î µÈ ½Ã°£ÀÌ µé¾î ÀÖ´Â º¯¼ö.

¿¹

¿¹Á¦ 1: 24½Ã°£ Çü½Ä

@DTW_TIME(results)

¿¹Á¦ 2: »ó¿ë ½Ã°£ Çü½Ä

@DTW_TIME("C", results)

¿¹Á¦ 3: ÇÔ¼ö È£ÃâÀ» »ç¿ëÇÏ¿© ÀÚÁ¤ ÀÌÈÄÀÇ ºÐ ¼ö¸¦ ¸®ÅÏÇÕ´Ï´Ù.

@DTW_rTIME("M")

¿¹Á¦ 4: ÇÔ¼ö È£ÃâÀ» »ç¿ëÇÏ¿© »ý·«½Ã ½Ã°£ ¹× ÀÚ·á Çü½ÄÀ» ¸®ÅÏÇÕ´Ï´Ù.

%REPORT{
<P>This report was created at @DTW_rTIME(), @DTW_rDATE().
%}

DTW_URLESCSEQ


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

¸ñÀû

URL¿¡¼­ Çã¿ëµÇÁö ¾Ê´Â ¹®ÀÚ¸¦ URL ÄÚµåÈ­ °ªÀ¸·Îµµ ¾Ë·ÁÁø escape °ªÀ¸·Î ´ëüÇÕ´Ï´Ù. Ç¥ 35¿¡ Ç¥½ÃµÈ ¹®ÀÚ¸¦ ´Ù¸¥ ¸ÅÅ©·Î ÆÄÀÏÀ̳ª HTML ºí·ÏÀ¸·Î Àü´ÞÇÏ·Á¸é ÀÌ ÇÔ¼ö¸¦ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù.

Ç¥ 35. URL¿¡¼­ Çã¿ëµÇÁö ¾Ê´Â ¹®ÀÚ
¹®ÀÚ À̸§ ÄÚµå
SPACE °ø°£ %20
" Å« µû¿ÈÇ¥ %22
# ¼ýÀÚ ±âÈ£ %23
% ÆÛ¼¾Æ® %25
& ¾ÚÆÛ»÷µå %26
\ ¿ª½½·¡½¬ %2F
: ÄÝ·Ð %3A
; ¼¼¹ÌÄÝ·Ð %3B
< º¸´Ù ÀÛÀ½ %3C
= °°À½ %3D
> º¸´Ù Å­ %3E
? ¹°À½Ç¥ %3F
@ À§Ä¡ ±âÈ£ %40
[ ¿©´Â ´ë°ýÈ£ %5B
/ ½½·¡½¬ %5C
] ´Ý´Â ´ë°ýÈ£ %5D
^ ij·µ %5E
{ ¿©´Â Áß°ýÈ£ %7B
| Á÷¼± %7C
} ´Ý´Â Áß°ýÈ£ %7D
~ Æ¿µå %7E

Çü½Ä

@DTW_URLESCSEQ(stringIn, stringOut)

@DTW_rURLESCSEQ(stringIn)

°ª

Ç¥ 36. DTW_URLESCSEQ ¸Å°³º¯¼ö
ÀÚ·á À¯Çü ¸Å°³º¯¼ö »ç¿ë ¼³¸í
¹®ÀÚ¿­ stringIn IN º¯¼ö ¶Ç´Â ¸®ÅÍ·² ¹®ÀÚ¿­.
¹®ÀÚ¿­ stringOut OUT URL¿¡¼­ Çã¿ëµÇÁö ¾Ê¾Æ 16Áø escape °ªÀ¸·Î ±³Ã¼µÈ ¹®ÀÚ°¡ ÀÖ´Â ÀÔ·Â ¹®ÀÚ¿­ÀÌ Æ÷ÇÔµÈ º¯¼ö.

¿¹

¿¹Á¦ 1: string1ÀÇ °ø¹é ¹× ¾ÚÆÛ»÷µå¸¦ URL escape ÄÚµå·Î ´ëüÇÏ°í °á°ú¸¦ string2·Î ÁöÁ¤ÇÕ´Ï´Ù.

@DTW_URLESCSEQ(string1,string2)

¿¹Á¦ 2: °ø¹é ¹× ¾ÚÆÛ»÷µå¸¦ URL ÄÚµåÈ­ Çü½ÄÀ¸·Î º¯È¯ÇÕ´Ï´Ù.

@DTW_rURLESCSEQ("Guys & Dolls")

¿¹Á¦ 3: ROW ºí·Ï¿¡¼­ DTW_rURLESCSEQ¸¦ »ç¿ëÇÏ°í °ø¹é°ú at ±âÈ£¸¦ URL ÄÚµåÈ­ Çü½ÄÀ¸·Î º¯È¯ÇÕ´Ï´Ù.

%ROW{
<P><a href="fullRpt.mac/input?name=@DTW_rURLESCSEQ(V1)&email=@DTW_rULRESCSEQ(V2)">
$(V1)</a>
%}

ÀÀ¿ë ÇÁ·Î±×·¥ »ç¿ëÀÚ°¡ À̸§À» Ŭ¸¯ÇÒ ¶§ À̸§°ú ÀüÀÚ¿ìÆí ÁÖ¼Ò°¡ º¯¼ö name ¹× email·Î ÄÚµåÈ­µÈ °ª°ú ÇÔ²² Net.Data ¸ÅÅ©·Î fullrpt.macÀÇ ÀÔ·Â ºí·ÏÀ¸·Î ¼Û½ÅµË´Ï´Ù.


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