Re: Reveal SQL Code

[Peter.Colpaert@xxxxxxxxxx]

Juan Carlos,

I didn't know there was an other way to PREPARE an SQL statement other 
than from a field... Is there?

Wonderingly, 

Peter Colpaert
Application Developer
Massive - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----




Juan Carlos Paredes <jcarlos@xxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
29/06/2005 10:28
Please respond to RPG programming on the AS400 / iSeries

 
        To:     rpg400-l@xxxxxxxxxxxx
        cc: 
        Subject:        Re: Reveal SQL Code


If it's static SQL you can use the PRTSQLINF command. It shows every SQL
statement in the program. If it's dynamic SQL your program should put the
sql statement into a field to PREPARE and EXECUTE it. So you can EVAL this
field to see the statement.

Juan Carlos.