Net.Data´Â ´Ù¸¥ ¾ð±ÞÀÌ ¾ø´Â °æ¿ì REPORT ¹× ROW ºí·Ï¿¡¼ »ç¿ëÇϵµ·Ï ÀÌµé º¯¼ö¸¦ Á¤ÀÇÇÕ´Ï´Ù. Á¶È¸°¡ ¸®ÅÏÇÏ´Â °ªÀ» ÂüÁ¶ÇÏ·Á¸é ÀÌ º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ.
Á¦ÇÑ»çÇ×: DEFINE Àý¿¡´Â ÀÌ·¯ÇÑ º¯¼ö °ªÀ» Á¤ÀÇÇÏÁö ¾Êµµ·Ï ÇϽʽÿÀ.
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÇÔ¼ö È£ÃâÀ̳ª Ä÷³ n¿¡ ´ëÇÑ Á¶È¸¿¡ ÀÇÇØ ¸®ÅÏµÈ Ä÷³¸í. NnÀº REPORT ¹× ROW ºí·Ï¿¡¼ À¯È¿ÇÕ´Ï´Ù.
Net.Data´Â Å×À̺íÀÇ °¢ Ä÷³¿¡ ´ëÇÑ º¯¼ö¸¦ ÁöÁ¤ÇÕ´Ï´Ù. µû¶ó¼ ÀÌ º¯¼ö¸¦ º¯¼ö ÂüÁ¶¿¡ »ç¿ëÇϰí ÂüÁ¶ÇÏ·Á´Â Ä÷³ÀÇ À̸§À» ÁöÁ¤ÇϽʽÿÀ.
¿¹
¿¹Á¦ 1: Ä÷³¸í¿¡ ´ëÇÑ º¯¼ö ÂüÁ¶
The name of column 2 is $(N2).
¿¹Á¦ 2: DTW_ASSIGNÀ» »ç¿ëÇÏ¿© REPORT ºí·Ï ¿ÜºÎ¿¡¼ »ç¿ëÇÒ Ä÷³¸íÀÇ °ªÀ» ÀúÀåÇÕ´Ï´Ù.
%define col1="" ... %function (DTW_SQL) myfunc() { select * from atable %report { @dtw_assign(col1, N1) %row{ %} %} %} %html(report) { @myfunc() The column name for for the first column is $(col1) %}
ÀÌ ¿¹Á¦´Â DTW_ASSIGNÀ» »ç¿ëÇÏ¿© REPORT ºí·Ï ¿ÜºÎ¿¡¼ ÇØ´ç º¯¼ö¸¦ »ç¿ëÇÒ ¼ö ÀÖ´Â ¹æ¹ýÀ» º¸¿©ÁÝ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº DTW_ASSIGNÀ» Âü°íÇϽʽÿÀ.
¿¹Á¦ 3: Ä÷³¸íÀ» Á¤ÀÇÇϱâ À§ÇÑ HTML Å×ÀÌºí ³»ÀÇ Nn
%REPORT{ <H2>Product directory</H2> <TABLE BORDER=1 CELLPADDING=3> <TR><TD>$(N1)</TD><TD>$(N2)</TD><TD>$(N5)</TD> %ROW{ <TR><TD>$(V1)</TD><TD>$(V2)</TD><TD>$(V3)</TD> %} </TABLE> %}
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÇÔ¼ö È£Ãâ ¶Ç´Â Á¶È¸ÀÇ °á°ú·Î ¸®ÅÏµÈ ¸ðµç Ä÷³¸í ¸ñ·ÏÀ» Æ÷ÇÔÇÕ´Ï´Ù. »ý·«½Ã ºÐ¸®ÀÚ´Â °ø¹éÀÔ´Ï´Ù.
ÀÌ º¯¼ö´Â »çÀü Á¤ÀÇµÈ º¯¼öÀÌ¸ç ±× °ªÀº ¼öÁ¤ÇÒ ¼ö ¾ø½À´Ï´Ù. ÀÌ º¯¼ö¸¦ º¯¼ö ÂüÁ¶·Î »ç¿ëÇϽʽÿÀ.
¿¹
¿¹Á¦ 1: ALIGNÀ» »ç¿ëÇÑ Ä÷³¸í ¸ñ·Ï
%DEFINE ALIGN="YES" ... %FUNCTION (DTW_SQL) myfunc() { select * from MyTable %report{ Your query was on these columns: $(NLIST). %row { ... %} %} %}
Ä÷³¸í ¸ñ·ÏÀº ALIGNÀÌ YES·Î ¼³Á¤µÈ Ä÷³¸í »çÀÌ¿¡ °ø¹éÀ» »ç¿ëÇÕ´Ï´Ù.
¿¹Á¦ 2: ºÐ¸®ÀÚ¸¦ " | "·Î º¯°æÇÏ´Â %LIST º¯¼ö
%DEFINE %LIST " | " NLIST ... %FUNCTION (DTW_SQL) myfunc() { select * from MyTable %report{ Your query was on these columns: $(NLIST). %row { ... %} %} %}
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
Net.Data°¡ º¸°í¼ ºí·Ï¿¡¼ ó¸®Çϰí ÀÖ´Â Å×À̺í Ä÷³ÀÇ ¹øÈ£. À̵é Ä÷³Àº ÇÔ¼ö È£ÃâÀ̳ª Á¶È¸¿¡ ÀÇÇØ ¸®Åϵ˴ϴÙ.
ÀÌ º¯¼ö´Â »çÀü Á¤ÀÇµÈ º¯¼öÀÌ¸ç ±× °ªÀº ¼öÁ¤ÇÒ ¼ö ¾ø½À´Ï´Ù. ÀÌ º¯¼ö¸¦ º¯¼ö ÂüÁ¶·Î »ç¿ëÇϽʽÿÀ.
¿¹
¿¹Á¦ 1: NLIST¿Í ÇÔ²² º¯¼ö ÂüÁ¶·Î »ç¿ëµÇ´Â NUM_COLUMNS
%REPORT{ Your query result has $(NUM_COLUMNS) columns: $(NLIST). ... %}
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
|
|
|
| X |
|
|
|
¸ñÀû
Net.Data°¡ REPORT ºí·Ï¿¡¼ ó¸®Çϰí ÀÖ´Â Å×À̺íÀÇ Çà ¼ö. ÇàÀÇ ¼ö´Â ÀڷḦ º¸À¯Çϰí ÀÖ´Â Net.Data Å×ÀÌºí¿¡ ´ëÇØ Á¤ÀÇµÈ upper limit ¸Å°³º¯¼öÀÇ °ª¿¡ µû¶ó ´Þ¶óÁý´Ï´Ù. ¿¹¸¦ µé¾î upper limit°¡ 30À¸·Î ¼³Á¤µÇ³ª SELECT¹®ÀÌ 1000°³ÀÇ ÇàÀ» ¸®ÅÏÇϸé NUM_ROWS °ªÀº 30ÀÌ µË´Ï´Ù. ¶ÇÇÑ upper limit°¡ 30À¸·Î ¼³Á¤µÇ°í SELECT¹®ÀÌ 20°³ÀÇ ÇàÀ» ¸®ÅÏÇϰí NUM_ROWS´Â 20ÀÌ µË´Ï´Ù. TABLE¹® ¹× upper limit ¸Å°³º¯¼ö¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº TABLE ¸í·É¹®À» Âü°íÇϽʽÿÀ.
NUM_ROWS´Â START_ROW_NUMÀÌ ¾ð¾î ȯ°æ¿¡ Á¦°øµÇÁö ¾Ê´Â ÇÑ °ª START_ROW_NUM¿¡ ÀÇÇØ ¿µÇâ¹ÞÁö ¾Ê½À´Ï´Ù. ¿¹¸¦ µé¾î START_ROW_NUMÀÌ 5(À¥ ÆäÀÌÁö¿¡ Ç¥½ÃµÈ Å×À̺íÀÌ Çà 5·ÎºÎÅÍ Ã¤¿öÁ®¾ß ÇÔÀ» ³ªÅ¸³¿)·Î ¼³Á¤µÇ°í SELECT¹®ÀÌ 25°³ÀÇ ÇàÀ» ¸®ÅÏÇϸé NUM_ROWS´Â 21ÀÌ ¾Æ´Ñ 25·Î ¼³Á¤µË´Ï´Ù. óÀ½ ³× °³ÀÇ ÇàÀÌ Å×ÀÌºí¿¡¼ »èÁ¦µÇ³ª °ª NUM_ROWS¿¡ Æ÷ÇԵ˴ϴÙ. ±×·¯³ª START_ROW_NUMÀÌ ¾ð¾î ȯ°æ¿¡ Á¦°øµÇ¸é START_ROW_NUM¿¡¼ ÁöÁ¤ÇÏ´Â Çà¿¡¼ ½ÃÀÛÇÏ´Â Çà ¼ö¸¸ NUM_ROWS¿¡ Æ÷ÇԵ˴ϴÙ. À§ÀÇ ¿¹Á¦¿¡¼ NUM_ROWS´Â 21·Î ¼³Á¤µË´Ï´Ù.
NUM_ROWS´Â REPORT ¹× ROW ºí·Ï¿¡¼ À¯È¿ÇÕ´Ï´Ù.
ÀÌ º¯¼ö´Â »çÀü Á¤ÀÇµÈ º¯¼öÀÌ¸ç ±× °ªÀº ¼öÁ¤ÇÒ ¼ö ¾ø½À´Ï´Ù. ÀÌ º¯¼ö¸¦ º¯¼ö ÂüÁ¶·Î »ç¿ëÇϽʽÿÀ.
¿¹
¿¹Á¦ 1: REPORT ºí·Ï¿¡¼ ó¸® ÁßÀÎ À̸§ÀÇ ¼ö¸¦ Ç¥½ÃÇÕ´Ï´Ù.
%DEFINE DTW_SET_TOTAL_ROWS="YES" %REPORT{ <H2>E-mail directory</H2> <UL> %ROW{ <LI>Name: <a href="mailto:$(V1)">$(V2)</a><BR> Location: $(V3) %} </UL> Names displayed: $(NUM_ROWS)<BR> Names found: $(TOTAL_ROWS) %}
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
Net.Data Å×ÀÌºí¿¡¼ ÇàÀÌ Ã³¸®µÉ ¶§¸¶´Ù Net.Data°¡ ±× °ªÀ» Áõ°¡½ÃŰ´Â Å×ÀÌºí º¯¼ö. ÀÌ º¯¼ö´Â Ä«¿îÅÍ·Î ÀÛµ¿ÇÏ¸ç ±× °ªÀº ó¸® ÁßÀÎ ÇöÀç ÇàÀÇ ¹øÈ£¸¦ ³ªÅ¸³À´Ï´Ù.
ÀÌ º¯¼ö´Â »çÀü Á¤ÀÇµÈ º¯¼öÀÌ¸ç ±× °ªÀº ¼öÁ¤ÇÒ ¼ö ¾ø½À´Ï´Ù. ÀÌ º¯¼ö¸¦ º¯¼ö ÂüÁ¶·Î »ç¿ëÇϽʽÿÀ.
RPT_MAX_ROWS´Â °ª ROW_NUM¿¡ ¿µÇâÀ» ¹ÌÄ¥ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î Å×ÀÌºí¿¡ ÇàÀÌ 100°³ ÀÖ°í RPT_MAX_ROWS°¡ 20À¸·Î ¼³Á¤µÇ¸é Çà 20ÀÌ ¸¶Áö¸·À¸·Î ó¸®µÈ ÇàÀ̹ǷΠROW_NUMÀÇ ¸¶Áö¸· °ªÀº 20ÀÌ µË´Ï´Ù.
ROW_NUMÀº ROW ºí·Ï¿¡¼¸¸ À¯È¿ÇÕ´Ï´Ù.
¿¹
¿¹Á¦ 1: ROW_NUMÀ» »ç¿ëÇÏ¿© Å×À̺íÀÇ °¢ Çà¿¡ ·¹À̺íÀ» ºÙ¿©¼ HTML Ãâ·ÂÀ¸·Î Ä÷³À» ä¿ó´Ï´Ù.
%REPORT{ <TABLE BORDER=1> <TR><TD> Row Number </TD> <TD> Customer </TD> %ROW{ <TR><TD> $(ROW_NUM) </TD> <TD> $(V_custname) </TD> %} </TABLE> %}
REPORT ºí·ÏÀº ¾Æ·¡¿¡ ³ªÅ¸³ª´Â °Í°ú °°Àº Å×À̺íÀ» »ý¼ºÇÕ´Ï´Ù.
Çà ¹øÈ£ | °í°´ |
---|---|
1 | Jane Smith |
2 | Jon Chiu |
3 | Frank Nguyen |
4 | Mary Nichols |
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X |
| X | X | X | X |
¸ñÀû
TABLE ¾ð¾î ±¸¼º¿¡ ´ëÇÑ °ª upper_limit¿¡ °ü°è¾øÀÌ Á¶È¸°¡ ¸®ÅÏÇÏ´Â ÇàÀÇ ÃÑ ¼ö. ¿¹¸¦ µé¾î RPT_MAX_ROWS°¡ ÃÖ´ë 20ÇàÀ» Ç¥½ÃÇϵµ·Ï ¼³Á¤µÇ¾î ÀÖÀ¸³ª Á¶È¸°¡ 100°³ÀÇ ÇàÀ» ¸®ÅÏÇϸé ÀÌ º¯¼ö´Â ROW ó¸® ÈÄ¿¡ 100À¸·Î ¼³Á¤µË´Ï´Ù.
ÀÌ º¯¼ö´Â »çÀü Á¤ÀÇµÈ º¯¼öÀÌ¸ç ±× °ªÀº ¼öÁ¤ÇÒ ¼ö ¾ø½À´Ï´Ù. ÀÌ º¯¼ö¸¦ º¯¼ö ÂüÁ¶·Î »ç¿ëÇϽʽÿÀ.
¿î¿µÃ¼Á¦ÀÇ Â÷ÀÌÁ¡:
Çʼö: ÀÌ º¯¼ö¸¦ »ç¿ëÇÏ·Á¸é DTW_SET_TOTAL_ROWS¸¦ YES·Î ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº DTW_SET_TOTAL_ROWS¸¦ Âü°íÇϽʽÿÀ.
¿¹
¿¹Á¦ 1: ¹ß°ßµÈ ÃÑ À̸§ÀÇ ¼ö¸¦ Ç¥½ÃÇÕ´Ï´Ù.
%DEFINE DTW_SET_TOTAL_ROWS="YES" %REPORT{ <H2>E-mail directory</H2> <UL> %ROW{ <LI>Name: <a href="mailto:$(V1)">$(V2)</a><BR> Location: $(V3) %} </UL> Names displayed: $(NUM_ROWS)<BR> Names found: $(TOTAL_ROWS) %}
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÇöÀç Çà¿¡ ´ëÇØ ÁöÁ¤µÈ Ä÷³¸í¿¡ ´ëÇÑ °ª. ÀÌ º¯¼ö´Â Á¤ÀǵÇÁö ¾ÊÀº Ä÷³¸í¿¡ ´ëÇØ¼´Â ¼³Á¤µÇÁö ¾Ê½À´Ï´Ù. µ¿ÀÏÇÑ À̸§À» °¡Áø µÎ °³ÀÇ Ä÷³¸íÀÌ µé¾î ÀÖ´Â Á¶È¸¿¡¼´Â ¿¹»óÄ¡ ¾ÊÀº °á°ú°¡ ³ªÅ¸³³´Ï´Ù. Áߺ¹µÈ Ä÷³¸íÀÇ À̸§À» º¯°æÇÏ·Á¸é SQL¿¡ AS ÀýÀ» »ç¿ëÇϽʽÿÀ. ROW ºí·Ï¿¡¼´Â V_columnName¸¸ À¯È¿ÇÕ´Ï´Ù.
ÀÌ º¯¼öÀÇ °ªÀ» º¯¼ö ÂüÁ¶·Î »ç¿ëÇÏ¿© ÁöÁ¤Çϰí Ä÷³ÀÇ ½ÇÁ¦ À̸§À» ´ëüÇϽʽÿÀ.
°ª
V_columnName
°ª | ¼³¸í |
---|---|
columnName | µ¥ÀÌŸº£À̽º Å×À̺íÀÇ ÇöÀç ÇàÀÇ Ä÷³¸í. |
¿¹
¿¹Á¦ 1: V_columnNameÀ» º¯¼ö ÂüÁ¶·Î »ç¿ë
You have selected $(V_destcity).
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ROW ºí·Ï¿¡¼ ó¸® ÁßÀÎ ÇöÀç Çà¿¡ ´ëÇÑ ¸ðµç ÇÊµå °ª ¸ñ·Ï. VLIST´Â ROW ºí·Ï¿¡¼¸¸ À¯È¿ÇÕ´Ï´Ù. »ý·«½Ã ºÐ¸®ÀÚ´Â °ø¹éÀÔ´Ï´Ù.
ÀÌ º¯¼ö´Â »çÀü Á¤ÀÇµÈ º¯¼öÀÌ¸ç ±× °ªÀº ¼öÁ¤ÇÒ ¼ö ¾ø½À´Ï´Ù. ÀÌ º¯¼ö¸¦ º¯¼ö ÂüÁ¶·Î »ç¿ëÇϽʽÿÀ.
¿¹
¿¹Á¦ 1: ¸ñ·Ï ű׸¦ »ç¿ëÇÏ¿© Á¶È¸ °á°ú Ç¥½Ã
%DEFINE ALIGN="YES" %REPORT{ Here are the results of your query: <OL> %ROW{ <LI>$(VLIST) %} </OL> %}
¿¹Á¦ 2: list º¯¼ö¸¦ »ç¿ëÇÏ¿© ºÐ¸®ÀÚ¸¦ <P>·Î º¯°æ
%DEFINE %LIST "<P>" VLIST %REPORT{ Here are the results of your query: %ROW{ <HR>$(VLIST) %} %}
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÇÔ¼ö È£ÃâÀ̳ª 1¿¡¼ n±îÁöÀÇ Çʵ忡 ´ëÇÑ SQL Á¶È¸¿¡ ÀÇÇØ ¸®ÅÏµÈ °¢ Çà¿¡ ´ëÇÑ Çʵ尪. VnÀº ROW ºí·Ï¿¡¼¸¸ Àνĵ˴ϴÙ.
Net.Data´Â Å×À̺íÀÇ °¢ Çʵ忡 ´ëÇÑ º¯¼ö¸¦ ÁöÁ¤ÇÕ´Ï´Ù. µû¶ó¼ ÀÌ º¯¼ö¸¦ º¯¼ö ÂüÁ¶¿¡ »ç¿ëÇϰí ÂüÁ¶ÇÒ Ä÷³ÀÇ À̸§À» ÁöÁ¤ÇϽʽÿÀ. ºí·Ï ¿ÜºÎ¿¡¼ ÀÌ º¯¼ö¸¦ »ç¿ëÇÏ·Á¸é °ª VnÀ» ÀÌÀü¿¡ ÁöÁ¤µÈ Àü¿ª º¯¼ö³ª OUT ¶Ç´Â INOUT ÇÔ¼ö ¸Å°³º¯¼ö¿¡ ÁöÁ¤ÇϽʽÿÀ.
¿¹
¿¹Á¦ 1: HTML Å×À̺íÀ» Ç¥½ÃÇÏ´Â º¸°í¼
%REPORT{ <H2>E-mail directory</H2> <TABLE BORDER=1 CELLPADDING=3> <TR><TD>Name</TD><TD>E-mail address</TD><TD>Location</TD> %ROW{ <TR><TD>$(V1)</TD> <TD><a href="mailto:$(V2)">$(V2)</a></TD> <TD>$(V3)</TD> %} </TABLE> Found $(NUM_ROWS) models matching your description. %}
µÎ ¹øÂ° Ä÷³Àº ÀüÀÚ ¸ÞÀÏ ÁÖ¼Ò¸¦ ³ªÅ¸³À´Ï´Ù. ¸µÅ©¸¦ Ŭ¸¯ÇÏ¿© »ç¶÷¿¡°Ô ¸Þ¼¼Áö¸¦ ¼Û½ÅÇÒ ¼ö ÀÖ½À´Ï´Ù.