[Main Page]      [Literature]      [Software]      [People]      [Conferences]      [Courses]      [Web-DB]

 

UNIVERSITY OF PITTSBURGH
School of Information Sciences

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]