RE: Reveal SQL Code

I don't think so. That's why I told in dynamic sql he can see the field in
an EVAL debugging the program. And if it's static sql he can see the
statements with the PRTSQLINF command.


> -----Mensaje original-----
> De:   Peter.Colpaert@xxxxxxxxxx [SMTP:Peter.Colpaert@xxxxxxxxxx]
> Enviado el:   miércoles, 29 de junio de 2005 10:32
> Para: RPG programming on the AS400 / iSeries
> Asunto:       Re: Reveal SQL Code
> 
> 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.
> 
> -- 
> 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.6/33 - Release Date: 28/06/2005
>  
> 
> 
> 
> -- 
> 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.6/33 - Release Date: 28/06/2005
>  
>