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 ÇÔ¼ö¿¡ Á¦°øÇÕ´Ï´Ù.