ÀÌ º¯¼ö¸¦ »ç¿ëÇÏ¿© º¸°í¼¸¦ Á¶Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ º¯¼ö¸¦ »ç¿ëÇϱ⿡ ¾Õ¼ À̸¦ Á¤ÀÇÇØ¾ß ÇÕ´Ï´Ù.
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
Å×À̺í ó¸® º¯¼ö NLIST ¹× VLIST¿¡¼ »ç¿ëµÇ´Â ¸Ç ¾Õ ¹× ¸Ç µÚ °ø¹éÀ» Á¦¾îÇÕ´Ï´Ù. À̸¦ YES·Î ¼³Á¤Çϸé ALIGNÀº ȸ鿡 ¸Â°Ô Å×À̺í ó¸® º¯¼ö¸¦ Á¤·ÄÇϵµ·Ï °ø¹éÀ» ä¿ó´Ï´Ù. HTML Çü½ÄÀ¸·Î Á¶È¸ °á°ú¸¦ Æ÷ÇÔ½ÃŰ°Å³ª Á¶Ä¡ Çü½ÄÀ» ÁöÁ¤ÇÏ·Á¸é Net.Data°¡ ¸Ç ¾Õ ¹× ¸Ç µÚ °ø¹éÀ» report º¯¼ö¿¡ »ç¿ëÇÏÁö ¸øÇϵµ·Ï »ý·«½Ã °ª NO¸¦ »ç¿ëÇϽʽÿÀ.
DEFINE¹®À» »ç¿ëÇϰųª @DTW_ASSIGN() ÇÔ¼ö¸¦ ÅëÇØ ÀÌ º¯¼öÀÇ °ªÀ» ÁöÁ¤ÇϽʽÿÀ.
°ª
ALIGN="YES"|"NO"
°ª | ¼³¸í |
---|---|
YES | Net.Data´Â ȸ鿡 ¸Â°Ô º¯¼ö°¡ Á¤·ÄµÇµµ·Ï ¸Ç ¾Õ°ú ¸Ç µÚ¿¡ °ø¹éÀ» Ãß°¡ÇÏ¿© º¯¼ö¸¦ º¸°íÇÕ´Ï´Ù. |
NO | Net.Data´Â ¸Ç ¾ÕÀ̳ª ¸Ç µÚ¿¡ °ø¹éÀ» Ãß°¡ÇÏÁö ¾Ê½À´Ï´Ù. NO°¡ »ý·«½Ã °ªÀÔ´Ï´Ù. |
¿¹
¿¹Á¦ 1: ALIGN º¯¼ö¸¦ »ç¿ëÇÏ¿© °ø¹éÀ¸·Î °¢ Ä÷³ ±¸ºÐ
%DEFINE ALIGN="YES" <P>Your query was on these columns: $(NLIST)
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
NO·Î ¼³Á¤µÉ ¶§, REPORT ºí·ÏÀÌ ¾øÀ¸¸ç ºê¶ó¿ìÀú¿¡ °á°ú¸¦ Ç¥½ÃÇÏÁö ¾Ê´Â ÇÔ¼ö¿¡ ´ëÇØ Net.Data°¡ »ý¼ºÇÏ´Â »ý·«½Ã º¸°í¼¸¦ ¹«½ÃÇÕ´Ï´Ù. ¿¹¸¦ µé¾î Å×ÀÌºí º¯¼ö·Î ÇÔ¼ö È£ÃâÀÇ °á°ú¸¦ ¼ö½ÅÇϰí 󸮸¦ À§ÇØ ÀÌ °á°ú¸¦ ´Ù¸¥ ÇÔ¼ö·Î Àü´ÞÇÏ´Â °æ¿ì »ý·«½Ã º¸°í¼¸¦ ¹«½ÃÇÏ´Â °ÍÀÌ ÁÁ½À´Ï´Ù.
DEFINE¹®À» »ç¿ëÇϰųª @DTW_ASSIGN() ÇÔ¼ö¸¦ ÅëÇØ ÀÌ º¯¼öÀÇ °ªÀ» ÁöÁ¤ÇϽʽÿÀ.
°ª
DTW_DEFAULT_REPORT="YES"|"NO"
°ª | ¼³¸í |
---|---|
YES | Net.Data´Â REPORT ºí·Ï ¾øÀÌ ÇÔ¼ö¿¡ ´ëÇÑ »ý·«½Ã º¸°í¼¸¦ »ý¼ºÇÏ°í ºê¶ó¿ìÀú¿¡ ±× °á°ú¸¦ Ç¥½ÃÇÕ´Ï´Ù. YES°¡ »ý·«½Ã °ªÀÔ´Ï´Ù. |
NO | Net.Data´Â REPORT ºí·Ï ¾øÀÌ ÇÔ¼ö¿¡ ´ëÇÑ »ý·«½Ã º¸°í¼¸¦ ¹«½ÃÇÕ´Ï´Ù. |
¿¹
¿¹Á¦ 1: Net.Data¿¡ ÀÇÇØ »ý¼ºµÈ »ý·«½Ã º¸°í¼ ¹«½Ã
%DEFINE DTW_DEFAULT_REPORT="NO"
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÅØ½ºÆ® À¯Çü Çü½Ä¿¡ Å×À̺íÀ» Ç¥½ÃÇÏ´Â ´ë½Å HTML Å×ÀÌºí¿¡ °á°ú¸¦ Ç¥½ÃÇÕ´Ï´Ù(Áï, PRE ÅÂ±× ´ë½Å TABLE ÅÂ±× »ç¿ë).
»ý¼ºµÈ TABLE ű׿¡´Â °æ°è ¹× ¼¿ ÆÐµù ½ºÆåÀÌ Æ÷ÇԵ˴ϴÙ.
<TABLE BORDER CELLPADDING=2>
DEFINE¹®À» »ç¿ëÇϰųª @DTW_ASSIGN() ÇÔ¼ö¸¦ ÅëÇØ ÀÌ º¯¼öÀÇ °ªÀ» ÁöÁ¤ÇϽʽÿÀ.
°ª
DTW_HTML_TABLE="YES"|"NO"
°ª | ¼³¸í |
---|---|
YES | HTML Å×À̺í ű׸¦ »ç¿ëÇÏ¿© Å×À̺í ÀڷḦ Ç¥½ÃÇÕ´Ï´Ù. |
NO | PRE ű׸¦ »ç¿ëÇÏ¿© ÅØ½ºÆ® Çü½ÄÀ¸·Î Å×À̺í ÀڷḦ Ç¥½ÃÇÕ´Ï´Ù. NO°¡ »ý·«½Ã °ªÀÔ´Ï´Ù. |
¿¹
¿¹Á¦ 1: HTML ű׸¦ »ç¿ëÇÏ¿© SQL ÇÔ¼öÀÇ °á°ú¸¦ Ç¥½ÃÇÕ´Ï´Ù.
%DEFINE DTW_HTML_TABLE="YES" %FUNCTION(DTW_SQL){ SELECT NAME, ADDRESS FROM $(qTable) %}
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X | X | X | X | X | X |
¸ñÀû
ÇÔ¼ö REPORT ºí·Ï¿¡ ÀÇÇØ »ý¼ºµÈ Å×ÀÌºí¿¡ Ç¥½ÃµÇ´Â ÇàÀÇ ¼ö¸¦ ÁöÁ¤ÇÕ´Ï´Ù.
DEFINE¹®À» »ç¿ëÇϰųª @DTW_ASSIGN() ÇÔ¼ö¸¦ ÅëÇØ ÀÌ º¯¼öÀÇ °ªÀ» ÁöÁ¤ÇϽʽÿÀ.
OS/400, Windows NT, OS/2 ¹× UNIX »ç¿ëÀÚ: ÀÌ º¯¼ö¸¦ »ç¿ëÇÏ·Á¸é ÀÌ º¯¼ö°¡ »ç¿ë ÁßÀÎ µ¥ÀÌŸº£À̽º ¾ð¾î ȯ°æ¿¡ ´ëÇÑ ENVIRONMENT¹®¿¡ IN º¯¼ö·Î ÃʱâÈ ÆÄÀÏ¿¡ Æ÷ÇԵǾî ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ. µ¥ÀÌŸº£À̽º ¾ð¾î ȯ°æ ¸í·É¹®¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Net.Data Administration and Programming GuideÀÇ ±¸¼º ÀåÀ» Âü°íÇϽʽÿÀ.
°ª
RPT_MAX_ROWS="ALL"|"0"|"number"
°ª | ¼³¸í |
---|---|
ALL | ÇÔ¼ö È£Ãâ¿¡ ÀÇÇØ »ý¼ºµÈ Å×ÀÌºí¿¡ Ç¥½ÃµÉ Çà ¼ö¿¡ Á¦ÇÑÀÌ ¾øÀ½À» ÁöÁ¤ÇÕ´Ï´Ù. ¸ðµç ÇàÀÌ Ç¥½ÃµË´Ï´Ù. |
0 | Å×À̺íÀÇ ¸ðµç ÇàÀÌ Ç¥½ÃµÇµµ·Ï ÁöÁ¤ÇÕ´Ï´Ù. ÀÌ °ªÀº ALLÀ» ÁöÁ¤ÇÏ´Â °Í°ú °°½À´Ï´Ù. |
number | ÇÔ¼ö È£Ãâ¿¡ ÀÇÇØ »ý¼ºµÈ Å×ÀÌºí¿¡ Ç¥½ÃµÉ ÃÖ´ë Çà ¼ö¸¦ ³ªÅ¸³»´Â ¾çÀÇ Á¤¼ö.
FUNCTION ºí·Ï¿¡ REPORT ¹× ROW ºí·ÏÀÌ µé¾î ÀÖÀ¸¸é ÀÌ ¼ö´Â ROW ºí·ÏÀÌ ½ÇÇàµÇ´Â Ƚ¼ö¸¦ ÁöÁ¤ÇÕ´Ï´Ù. |
¿¹
¿¹Á¦ 1: DEFINE¹®¿¡ RPT_MAX_ROWS´Â Á¤ÀÇÇÕ´Ï´Ù.
%DEFINE RPT_MAX_ROWS="20"
À§ÀÇ ¸Þ¼µå´Â ÇÔ¼ö°¡ ¸®ÅÏÇÏ´Â ÇàÀÇ ¼ö¸¦ 20°³·Î Á¦ÇÑÇÕ´Ï´Ù.
¿¹Á¦ 2: HTML ÀÔ·ÂÀ» »ç¿ëÇÏ¿© HTML Çü½ÄÀ¸·Î º¯¼ö¸¦ Á¤ÀÇÇÕ´Ï´Ù.
Maximum rows to return (0 for no limit): <INPUT TYPE="text" NAME="RPT_MAX_ROWS" SIZE=3>
À§ ¿¹Á¦ÀÇ ÇàµéÀº FORM ű׿¡ ³õÀÏ ¼ö ÀÖÀ¸¹Ç·Î ÀÀ¿ë ÇÁ·Î±×·¥ »ç¿ëÀÚ´Â Á¶È¸·ÎºÎÅÍ ¸®Å쵃 ÇàÀÇ ¼ö¸¦ ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
AIX | HP-UX | OS/2 | OS/390 | OS/400 | SCO | SUN | Win NT |
X | X | X |
| X | X | X | X |
¸ñÀû
º¸°í¼¿¡ Net.Data Å×À̺íÀÇ °á°ú¸¦ Ç¥½ÃÇϱ⠽ÃÀÛÇÒ Çà ¹øÈ£¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ÀÌ º¯¼ö¸¦ RPT_MAX_ROWS¿Í ÇÔ²² »ç¿ëÇÏ¿© Å« °á°ú ¼¼Æ®¸¦ °¡Áø Á¶È¸¸¦ ´õ ÀÛÀº Å×À̺í·Î ºÐ¸®ÇÏ°í ´ÙÀ½ ¹öưÀ» »ç¿ëÇÏ¿© °á°ú Å×ÀÌºí °£¿¡ À̵¿ÇÒ ¼ö ÀÖ½À´Ï´Ù.
Á¦ÇÑ»çÇ×: ¼º´ÉÀ» À§ÇØ Net.Data´Â µ¥ÀÌŸº£À̽º ¾ð¾î ȯ°æÀÌ Àüü °á°ú ¼¼Æ®¸¦ Net.Data·Î ¸®ÅÏÇÏÁö ¸øÇϵµ·Ï ÀÌ ¾ð¾î ȯ°æ¿¡ START_ROW_NUMÀ» Á¦°øÇÕ´Ï´Ù. ÀÌ º¯¼ö¸¦ ÀÚµ¿À¸·Î Àü´ÞÇÏ·Á¸é ÃʱâÈ ÆÄÀÏÀÇ µ¥ÀÌŸº£À̽º ¾ð¾î ȯ°æ ENVIRONMENT¹®¿¡ IN º¯¼ö·Î Æ÷ÇÔ½ÃŰ½Ê½Ã¿À. ÀÌ º¯¼ö°¡ ENVIRONMENT¹®¿¡¼ »ý·«µÇ¸é °Ë»öÀÌ ½ÃÀÛµÉ Çà ¹øÈ£´Â °á°ú ¼¼Æ®¿¡¼ óÀ½ ÇàÀ¸·Î °¡Á¤µË´Ï´Ù.
DEFINE¹®À» »ç¿ëÇϰųª @DTW_ASSIGN() ÇÔ¼ö¸¦ ÅëÇØ ÀÌ º¯¼öÀÇ °ªÀ» ÁöÁ¤ÇϽʽÿÀ.
°ª
START_ROW_NUM="number"
°ª | ¼³¸í |
---|---|
number | º¸°í¼ Ç¥½Ã¸¦ ½ÃÀÛÇÒ Çà ¹øÈ£¸¦ ³ªÅ¸³»´Â ¾çÀÇ Á¤¼ö.
ÃʱâÈ ÆÄÀÏÀÇ µ¥ÀÌŸº£À̽º ¾ð¾î ȯ°æÀÇ È¯°æ ¸í·É¹®¿¡ START_ROW_NUM ÀÌ ÁöÁ¤µÇ¸é ÀÌ ¹øÈ£´Â µ¥ÀÌŸº£À̽º ¾ð¾î ȯ°æÀÌ Ã³¸®ÇÑ °á°ú ¼¼Æ®ÀÇ ÇØ´ç Çà ¹øÈ£¸¦ ÁöÁ¤ÇÕ´Ï´Ù.
START_ROW_NUMÀ» ¾ð¾î ȯ°æ¿¡ Á¦°øÇÏÁö ¾ÊÀ¸¸é ÀÌ ¼ö´Â º¸°í¼¸¦ Ç¥½ÃÇÏ´Â µ¥ »ç¿ëµÈ Net.Data Å×À̺íÀÇ Çà ¹øÈ£¸¦ ÁöÁ¤ÇÕ´Ï´Ù. |
¿¹Á¦ 1: HTML Çü½ÄÀÇ ´ÙÀ½ ¹× ÀÌÀü ¹öưÀ» »ç¿ëÇÏ¿© ȸé À̵¿
%define { DTW_HTML_TABLE = "YES" START_ROW_NUM = "1" RPT_MAX_ROWS = "10" totalSize = "" includeNext = "YES" includePrev = "YES" includeLast = "YES" includeFirst = "YES" %} %function(DTW_SQL) myQuery(){ select * from NETDATADEV.CUSTOMER %} %function(DTW_SQL) count(OUT size){ select count(*) from NETDATADEV.CUSTOMER %report{ %row{ @DTW_ASSIGN(size,V1) %} %} %} %html(report) { %{ get the total number of records if we haven't already %} %if (totalSize == "") @count(totalSize) %endif %{ set START_ROW_NUM based on the button user clicked %} %if (totalSize <= RPT_MAX_ROWS) %{ there's only one page of data %} @DTW_ASSIGN(START_ROW_NUM, "1") @DTW_ASSIGN(includeFirst, "NO") @DTW_ASSIGN(includeLast, "NO") @DTW_ASSIGN(includeNext, "NO") @DTW_ASSIGN(includePrev, "NO") %elif (submit == "First Page" || submit == "") %{ first time through or user selected "First Page" button %} @DTW_ASSIGN(START_ROW_NUM, "1") @DTW_ASSIGN(includePrev, "NO") @DTW_ASSIGN(includeFirst, "NO") %elif (submit == "Last Page") %{ user selected "Last Page" button %} @DTW_SUBTRACT(totalSize, RPT_MAX_ROWS, START_ROW_NUM) @DTW_ADD(START_ROW_NUM, "1", START_ROW_NUM) @DTW_ASSIGN(includeLast, "NO") @DTW_ASSIGN(includeNext, "NO") %elif (submit == "Next") %{ user selected "Next" button %} @DTW_ADD(START_ROW_NUM, RPT_MAX_ROWS, START_ROW_NUM) %if (@DTW_rADD(START_ROW_NUM, RPT_MAX_ROWS) > totalSize) @DTW_ASSIGN(includeNext,"NO") @DTW_ASSIGN(includeLast, "NO") %endif %elif (submit == "Previous") %{ user selected "Previous" button %} @DTW_SUBTRACT(START_ROW_NUM, RPT_MAX_ROWS, START_ROW_NUM) %if (START_ROW_NUM <= "1" ) @DTW_ASSIGN(START_ROW_NUM,"1") @DTW_ASSIGN(includePrev,"NO") @DTW_ASSIGN(includeFirst,"NO") %endif %endif %{ run the query to get the data %} @myQuery() %{ output the correct buttons at the bottom of the report %} <center> <form method="POST" action="report"> <input name="START_ROW_NUM" type="hidden" value="$(START_ROW_NUM)"> <input name="totalSize" type="hidden" value="$(totalSize)"> %if (includeFirst == "YES" ) <input name="submit" type="submit" value="First Page"> %endif %if (includePrev == "YES" ) <input name="submit" type="submit" value="Previous"> %endif %if (includeNext == "YES" ) <input name="submit" type="submit" value="Next"> %endif %if (includeLast == "YES" ) <input name="submit" type="submit" value="Last Page"> %endif </form> </center> %}