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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.