Re: Display a prepared statement

At 04:04 PM 10/7/2005, Franco Biaggi wrote:

tballen@xxxxxxxxxx wrote:

> I really just want to be able to see the actual statement in the
> debugger.
> In my case I am using WSAD.
>
> I did not see any variables that showed the SQL statement after the
> parameter substitution took place.
>
> Am I missing something?
>
> Thanks,
> Todd
>
>
> At 06:31 PM 10/6/2005, you wrote:
>
>> Try running a database monitor (STRDBMON)
>>
>> -----Original Message-----
>> From: java400-l-bounces@xxxxxxxxxxxx
>> [mailto:java400-l-bounces@xxxxxxxxxxxx]
>> On Behalf Of tballen@xxxxxxxxxx
>> Sent: Thursday, October 06, 2005 5:05 PM
>> To: Java Programming on and around the iSeries / AS400
>> Subject: Display a prepared statement
>>
>>
>> Is there a way to display an SQL prepared statement after the
>> parameter placeholders have been replaced with actual values?
>> I have not seen anything while debugging.
>>
>> Thanks.
>
>
>
Hi,
after starting the DB monitor,
you can look the generated statements (and some useful informations)
with the iSeries Navigator.