Re: WEB400 Digest, Vol 5, Issue 145

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