INFSCI 2710 - Database Management

Stefan Brass

Web-DB Interfaces: Example File for "DB2 WWW Connection"

More Information: http://www.software.ibm.com/data/db2/www/

Source File "course"


%{DEFINE
	DATABASE="sis"
	LOGIN="scott"
	PASSWORD="tiger"
}

%{SQL
	SELECT CRN, Title
	FROM   Course
	WHERE  Name = '$(Instructor)'
	%SQL_REPORT
		<UL>
		%ROW{ <LI> $(V2) ($(V1))}
		</UL>
	%}
%}

%{HTML_INPUT
	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
	<HTML>
	<HEAD>
	<TITLE>Course Database (Query Form)</TITLE>
	</HEAD>
	<BODY>
	<H1>Course Database (Query Form)</H1>
	<FORM METHOD="post" ACTION="/cgi-bin/db2www.exe/course/report">
	Please Enter Instructor Name: <INPUT NAME="Instructor" SIZE=20>
	<INPUT TYPE=SUBMIT VALUE="Execute Query">
	</FORM>
	</BODY>
	</HTML>
%}

%{HTML_REPORT
	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN"> 
	<HTML>   
	<HEAD>
	<TITLE>Course Database (Query Result)</TITLE>
	</HEAD>  
	<BODY> 
	<H1>Courses taught by $(Instructor)</H1>
	%EXEC_SQL
	<P>
	<A HREF="/cgi-bin/db2www.exe/course/input">New Query</A>
	</BODY> 
	</HTML>
%}

Stefan Brass (sbrass@sis.pitt.edu), April 23, 1999

Original URL: http://www2.sis.pitt.edu/~sbrass/db/webdb3.html [HTML 3.2 Checked]