IBM Books

Net.Data ÂüÁ¶¼­


Net.Data º¸°í¼­ º¯¼ö

ÀÌ º¯¼ö¸¦ »ç¿ëÇÏ¿© º¸°í¼­¸¦ Á¶Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ º¯¼ö¸¦ »ç¿ëÇϱ⿡ ¾Õ¼­ À̸¦ Á¤ÀÇÇØ¾ß ÇÕ´Ï´Ù.

ALIGN


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"

Ç¥ 5. ALIGN °ª
°ª ¼³¸í
YES Net.Data´Â È­¸é¿¡ ¸Â°Ô º¯¼ö°¡ Á¤·ÄµÇµµ·Ï ¸Ç ¾Õ°ú ¸Ç µÚ¿¡ °ø¹éÀ» Ãß°¡ÇÏ¿© º¯¼ö¸¦ º¸°íÇÕ´Ï´Ù.
NO Net.Data´Â ¸Ç ¾ÕÀ̳ª ¸Ç µÚ¿¡ °ø¹éÀ» Ãß°¡ÇÏÁö ¾Ê½À´Ï´Ù. NO°¡ »ý·«½Ã °ªÀÔ´Ï´Ù.

¿¹

¿¹Á¦ 1: ALIGN º¯¼ö¸¦ »ç¿ëÇÏ¿© °ø¹éÀ¸·Î °¢ Ä÷³ ±¸ºÐ

%DEFINE ALIGN="YES"
<P>Your query was on these columns: $(NLIST)

DTW_DEFAULT_REPORT


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"

Ç¥ 6. DTW_DEFAULT_REPORT °ª
°ª ¼³¸í
YES Net.Data´Â REPORT ºí·Ï ¾øÀÌ ÇÔ¼ö¿¡ ´ëÇÑ »ý·«½Ã º¸°í¼­¸¦ »ý¼ºÇÏ°í ºê¶ó¿ìÀú¿¡ ±× °á°ú¸¦ Ç¥½ÃÇÕ´Ï´Ù. YES°¡ »ý·«½Ã °ªÀÔ´Ï´Ù.
NO Net.Data´Â REPORT ºí·Ï ¾øÀÌ ÇÔ¼ö¿¡ ´ëÇÑ »ý·«½Ã º¸°í¼­¸¦ ¹«½ÃÇÕ´Ï´Ù.

¿¹

¿¹Á¦ 1: Net.Data¿¡ ÀÇÇØ »ý¼ºµÈ »ý·«½Ã º¸°í¼­ ¹«½Ã

%DEFINE DTW_DEFAULT_REPORT="NO"

DTW_HTML_TABLE


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"

Ç¥ 7. DTW_HTML_TABLE °ª
°ª ¼³¸í
YES HTML Å×À̺í ű׸¦ »ç¿ëÇÏ¿© Å×À̺í ÀڷḦ Ç¥½ÃÇÕ´Ï´Ù.
NO PRE ű׸¦ »ç¿ëÇÏ¿© ÅØ½ºÆ® Çü½ÄÀ¸·Î Å×À̺í ÀڷḦ Ç¥½ÃÇÕ´Ï´Ù. NO°¡ »ý·«½Ã °ªÀÔ´Ï´Ù.

¿¹

¿¹Á¦ 1: HTML ű׸¦ »ç¿ëÇÏ¿© SQL ÇÔ¼öÀÇ °á°ú¸¦ Ç¥½ÃÇÕ´Ï´Ù.

%DEFINE DTW_HTML_TABLE="YES"
 
%FUNCTION(DTW_SQL){
SELECT NAME, ADDRESS FROM $(qTable)
%}

RPT_MAX_ROWS


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"

Ç¥ 8. RPT_MAX_ROWS °ª
°ª ¼³¸í
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 ű׿¡ ³õÀÏ ¼ö ÀÖÀ¸¹Ç·Î ÀÀ¿ë ÇÁ·Î±×·¥ »ç¿ëÀÚ´Â Á¶È¸·ÎºÎÅÍ ¸®Å쵃 ÇàÀÇ ¼ö¸¦ ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.

START_ROW_NUM


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"

Ç¥ 9. START_ROW_NUM °ª
°ª ¼³¸í
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>
%}


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