If your needs are fairly basic you can easily roll your own.
Read up on Net.Data at
http://www.ignite400.org/html/macro_examples.htm
This will get you started:
************Beginning of data**************
%{ MACRO bc_select.mac -- demonstrates dynamic select box creation
This macro demonstrates different methods of displaying a dynamic
select box
using Net.Data
%}
%DEFINE {
SHOWSQL = "NO"
DATABASE = "*LOCAL"
seltbl = %TABLE
DTW_HTML_TABLE = "YES"
%}
%function(DTW_SQL) RUNSQL() {
$(sqlstring)
%}
%HTML(main) {
<HTML>
<head>
<title>Run System i Query</title>
</head>
<body bgcolor="white">
<h2 align="center">Run System i Query</h2>
<FORM method="POST" action="/cgi-bin/db2www/runqry.mac/showsql">
<center>
<strong><font face="Arial"><big><big>Enter SQL string
here:</big></big><br>
<table border="0" cellpadding="0" cellspacing="0" width="80%">
</tr>
<tr>
<textarea rows="5" name="sqlstring" cols="80"></textarea></td>
</tr>
</center>
<BR>
<input type="submit" value="Submit" >
</form>
<p>@DTW_rTIME()
%}
%HTML(showsql) {
<html>
<head>
<meta http-equiv="Expires" content="0">
<meta http-equiv="Pragma" content="no-cache">
<title>Run SQL Query V1.1</title>
</head>
<body bgcolor="white">
<H1 align="center">System i Query Output</h1>
@RUNSQL()
</center>
</body>
</html>
%}
************End of Data********************
Regards,
Scott Ingvaldson
Senior IBM Support Specialist
Fiserv Midwest
-----Original Message-----
From: Aaron Abreu [mailto:abreual@xxxxxxxxxxxxx]
Sent: Thursday, April 24, 2008 3:56 PM
To: midrange-l@xxxxxxxxxxxx
Subject: DB2 web query
I've read a lot of documents...
however.. does anyone have any real-life use pros/cons for db2/wq over
other reporting services to access your I box ??? suggestions on a
preferred ODBC to use with it would be helpful too..
or perhaps there is a list forum for this somewhere...
TIA
Aaron
midrange.com
