Re: WEB400 Digest, Vol 5, Issue 145

I recently had an issue where inconsistent results came up or getting a
generic SQl error. I found (somewhere, I think I ended the server instance
in questions, restarted it so I was only one or first one in it and in the
joblog for one of the QHTTPSVR sbs running it foudn that I was hitting the
qry time limit because due to policy/procedure changes were retrieving over
10x as many records as before (and legitmately now). I upped the
appropriate system value for qry time limits and it fixed.

On 8/13/07, Mike Eovino <meovino@xxxxxxxxx> wrote:

Is the SQL statement you're running not displaying?

On 8/13/07, jlowary@xxxxxxxxxxxxx <jlowary@xxxxxxxxxxxxx> wrote:

I did find where to turn on the SHOWSQL and also came across a field
passed back that tells me how many rows. I put these in to display in

my

html page, and below is what I'm getting. I have in the INI file

member:

DB2WWW This line:

DTW_SHOWSQL YES

but it is still not showing the sql. This is what I had to change the
macro to to get the SHOWSQL to be "YES"

%FUNCTION(DTW_SQL) sql1(IN productCategoryId) {
@DTW_ASSIGN(SHOWSQL,"YES")
select IVITEM, IVIDSC, IVPRGR
from LINVNT01
where IVPRGR = '$(productCategoryId)' for fetch only

even though I defined it as:
%DEFINE {
DATABASE = "*LOCAL"
DB_CASE="UPPER"
SHOWSQL="YES"
%}

It would still show up as "NO" unless I did the dtw_assign. Is there
something else I need to be changing the the INI file or setting

somewhere

to get the SQL to display?

This is the section of the html page that displays after may changes:

Manual Description
AC1CIG 1 INCH CURLING IRON

SQLSTATE=
SHOWSQL=YES
TOTAL_ROWS=45

Hope someone can point me in the right direction, seems like the data is
getting found just not displayed, but maybe I'm over looking something.
Also forgot to mention I have ended and restarted the server since

making

my changes (just incase!).

Thanks to all who've help me get this far!

Regards,

Jim Lowary
System Analyst, Salton Inc.
(573) 447-5500
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.