IBM Books

Net.Data ÂüÁ¶¼­

Table º¯¼ö


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

Table º¯¼ö¿¡´Â °ªÀÇ ¹è¿­°ú ¿¬°üµÈ Ä÷³¸íÀÌ µé¾î ÀÖ½À´Ï´Ù. ¹è¿­ÀÇ °¢ ¿ä¼Ò´Â ÇàÀ» ³ªÅ¸³À´Ï´Ù. ±×·ì °ªÀ» ÇÔ¼ö¿¡ Àü´ÞÇÏ·Á¸é Å×ÀÌºí º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ. ÇÔ¼öÀÇ REPORT ºí·Ï¿¡¼­ Å×À̺íÀÇ °³º° ¿ä¼Ò(Çà)¸¦ ÂüÁ¶ÇÒ ¼ö ÀÖ½À´Ï´Ù. Table º¯¼ö´Â SQL ÇÔ¼öÀÇ Ãâ·Â°ú º¸°í¼­ ÀԷ¿¡ »ç¿ëµÇÁö¸¸ ÀÌµé º¯¼ö¸¦ IN, OUT ¶Ç´Â INOUT ¸Å°³º¯¼ö·Î ºñSQL ÇÔ¼ö¿¡ Á¦°øÇÒ ¼öµµ ÀÖ½À´Ï´Ù. Å×À̺íÀº SQL ÇÔ¼ö¿¡ OUT ¸Å°³º¯¼ö·Î Àü´ÞÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ±¸¹® ¹× ÀÚ¼¼ÇÑ Á¤º¸¸¦ º¸·Á¸é TABLE ¸í·É¹®À» Âü°íÇϽʽÿÀ.

¿¹Á¦ 1: REXX ÇÁ·Î±×·¥¿¡ Á¦°øµÈ SQL °á°ú ¼¼Æ®

%DEFINE{
        DATABASE = "iddata"
        MyTable = %TABLE(ALL)
        DTW_DEFAULT_REPORT = "NO"
%}
 
%FUNCTION(DTW_SQL) Query(OUT table) {
select * from survey
%}
 
%FUNCTION(DTW_REXX) showTable(INOUT table) {
  Say 'Number of Rows: 'table_ROWS
  Say 'Number of Columns: 'table_COLS
  do j=1 to table_COLS
    Say "Here are all of the values for column " table_N.j ":"
    do i = 1 to table_ROWS
       Say "<B>"i"</B>: " table_V.i.j
  end
  end
%}
 
%HTML(report){
<HTML>
<PRE>
@Query(MyTable)
<p>
@showTable(MyTable)
</PRE>
</HTML>
%}

HTML REPORT ºí·ÏÀº SQL Á¶È¸¸¦ È£ÃâÇϰí, table º¯¼ö¿¡ ±× °á°ú¸¦ ÀúÀåÇÑ ´ÙÀ½ ÀÌ º¯¼ö¸¦ REXX ÇÔ¼ö¿¡ Á¦°øÇÕ´Ï´Ù.


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