Re: WEB400 Digest, Vol 5, Issue 145

[jlowary@xxxxxxxxxxxxx]

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