ÀÏ¹Ý ÇÔ¼ö´Â Net.Data¸¦ »ç¿ëÇÏ¿© À¥ ÆäÀÌÁö¸¦ °³¹ßÇÏ´Â µ¥ µµ¿òÀ» ÁÖ¸ç ´Ù¸¥ ¹üÁÖ¿¡´Â ¸ÂÁö ¾Ê½À´Ï´Ù. ÀÏ¹Ý ÇÔ¼ö´Â ´ÙÀ½°ú °°½À´Ï´Ù.
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)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | 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)') %}
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½Ã ÆäÀÌÁöÀÇ »óŸ¦ ³ªÅ¸³»´Â ¹®ÀÚ¿ º¯¼ö. ´ÙÀ½°ú °°Àº ¼Ò¹®ÀÚ·Î
µÈ °ªÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
|
¿¹
¿¹Á¦ 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> %}
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()
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | format | IN | ÀÚ·á Çü½ÄÀ» ÁöÁ¤ÇÏ´Â ¸®ÅÍ·² ¹®ÀÚ¿ ¶Ç´Â º¯¼ö. À¯È¿ÇÑ Çü½ÄÀº
´ÙÀ½°ú °°½À´Ï´Ù.
»ý·«½Ã °ªÀº NÀÔ´Ï´Ù. |
¹®ÀÚ¿ | stringOut | OUT | ÁöÁ¤µÈ Çü½ÄÀ¸·Î µÈ ³¯Â¥°¡ µé¾îÀÖ´Â º¯¼ö. |
¿¹
¿¹Á¦ 1: ÀÏ¹Ý ³¯Â¥ Çü½Ä
@DTW_DATE(results)
¿¹Á¦ 2: À¯·´ ³¯Â¥ Çü½Ä
@DTW_DATE("E", results)
¿¹Á¦ 3: ¹Ì±¹ ³¯Â¥ Çü½Ä
%HTML(report){ <P>This report created on @DTW_rDATE("U").
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> %}
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)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | 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").
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)
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 ÇÔ¼ö¿¡ ÀÇÇØ ÄÚµåȵÈ
¹®ÀÚ°¡ ³ªÅ¸³³´Ï´Ù.
¹®ÀÚ | À̸§ | ÄÚµå |
SPACE | °ø°£ |   |
" | Å« µû¿ÈÇ¥ | " |
# | ¼ýÀÚ ±âÈ£ | # |
% | ÆÛ¼¾Æ® | % |
& | ¾ÚÆÛ»÷µå | & |
\ | ¿ª½½·¡½¬ | \ |
: | ÄÝ·Ð | : |
; | ¼¼¹ÌÄÝ·Ð | ; |
< | º¸´Ù ÀÛÀ½ | < |
= | °°À½ | =: |
> | º¸´Ù Å | >: |
? | ¹°À½Ç¥ | ?: |
@ | À§Ä¡ ±âÈ£ | @ |
[ | ¿©´Â ´ë°ýÈ£ | ( |
/ | ½½·¡½¬ | / |
] | ´Ý´Â ´ë°ýÈ£ | ) |
^ | ij·µ | ^ |
{ | ¿©´Â Áß°ýÈ£ | { |
| | Á÷¼± | | |
} | ´Ý´Â Áß°ýÈ£ | } |
~ | Æ¿µå | ~ |
Çü½Ä
@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")
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
@DTW_HTMLENCODE¿Í °°Àº ÇÔ¼ö¸¦ ¼öÇàÇϰí ÀÛÀº µû¿ÈÇ¥(')¸¦ '·Î ÄÚµåÈÇÕ´Ï´Ù. 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")
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)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | envVarName | IN | ȯ°æ º¯¼ö¸¦ ³ªÅ¸³»´Â ¸®ÅÍ·² ¹®ÀÚ¿ ¶Ç´Â º¯¼ö. |
¹®ÀÚ¿ | envVarValue | OUT | ȯ°æ º¯¼ö°¡ ÁöÁ¤µÈ °ªÀ» Æ÷ÇÔÇÏ´Â º¯¼ö ¶Ç´Â ¸®ÅͳΠ¹®ÀÚ¿. |
¹®ÀÚ¿ | prevValue | OUT | ȯ°æ º¯¼öÀÇ ÀÌÀü °ªÀÌ µé¾î ÀÖ´Â º¯¼ö. |
¿¹
¿¹Á¦ 1: ÀÌÀü °æ·Î¿¡ ´ëÇÑ °ªÀ» ¸®ÅÏÇÕ´Ï´Ù.
@DTW_SETENV("PATH", "myPath", prevValue)
¿¹Á¦ 2: ÀÌÀü °æ·Î¿¡ ´ëÇÑ °ªÀ» ¸®ÅÏÇϰí PATH¹®¿¡ ´ëÇÑ °ªÀ» ÁöÁ¤ÇÕ´Ï´Ù.
@DTW_rSETENV("PATH", "myPath")
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()
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | stringIn | IN | ½Ã°£ Çü½ÄÀ» ÁöÁ¤ÇÏ´Â ¸®ÅÍ·² ¹®ÀÚ¿ ¶Ç´Â º¯¼ö. À¯È¿ÇÑ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
|
¹®ÀÚ¿ | 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(). %}
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)
°ª
ÀÚ·á À¯Çü | ¸Å°³º¯¼ö | »ç¿ë | ¼³¸í |
---|---|---|---|
¹®ÀÚ¿ | 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> %}
<P><a href="fullrpt.mac/input?name=Patrick%20O'Brien&email="obrien%40ibm.com"> Patrick O'Brien</a>
ÀÀ¿ë ÇÁ·Î±×·¥ »ç¿ëÀÚ°¡ À̸§À» Ŭ¸¯ÇÒ ¶§ À̸§°ú ÀüÀÚ¿ìÆí ÁÖ¼Ò°¡ º¯¼ö name ¹× email·Î ÄÚµåÈµÈ °ª°ú ÇÔ²² Net.Data ¸ÅÅ©·Î fullrpt.macÀÇ ÀÔ·Â ºí·ÏÀ¸·Î ¼Û½ÅµË´Ï´Ù.