<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="portlet" uri="http://java.sun.com/portlet" %>
<%-- TODO: Check if datasource is created --%>
<%-- Datasource --%>
<%-- Datasource --%>
<%-- Create the connection manually --%>
<%-- Select statement --%>
<%-- Set select statement depending on the view table type --%>
select TABLENAME from SYS.SYSTABLES where TABLETYPE='T'
select TABLENAME from SYS.SYSTABLES where TABLETYPE='S' and TABLENAME!='SYSDUMMY1'
DB:
Tables
<%-- Check if there are tables to display --%>
*** No tables ***
<%-- Get the value of each column while iterating over rows --%>