RE: SQL under the covers

["Reeve" <news@xxxxxxxxxx>]

I forgot about that one...thanks!

-rf

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
> bounces@xxxxxxxxxxxx] On Behalf Of Carel Teijgeler
> Sent: Monday, July 12, 2004 11:40 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: SQL under the covers
> 
> Reeve,
> 
> Perhaps the  command PRTSQLINF *PGM will give you the prepared
> statement the precompiler created.
> 
> Regards,
> Carel Teijgeler
> 
> *********** REPLY SEPARATOR  ***********
> 
> On 10-7-04 at 13:38 Reeve wrote:
> 
> >Is there any way to see the "created" SQL statement for something like
> >this:
> >
> >
> >
> >C+        Declare Input cursor for select
> >
> >C+                                       fhpro,
> >
> >C+                                       fhonm
> >
> >C+                                       fhfamt + fhjamt as qnetfee,
> >
> >C+                                       fhsua3
> >
> >C+                                       from frp001
> >
> >C+         Order by
> >
> >C+               case
> >
> >C+                when :qrfld = 'QQQ104' then fhpro
> >
> >C+                when :qrfld = 'QQQ105' then fhonm
> >
> >C+                when :qrfld = 'QQQ111' then fhsua3
> >
> >C+                 else null
> >
> >C+                  end,
> >
> >
> >
> >Looking at the generated SQL code (with the SQL includes, SQLCA,
> etc.)
> >doesn't tell me much.
> >
> >
> >
> >I have a reason for wanting to do this; it has something to do with
> >debugging.I think.
> >
> >
> >
> >Thanks,
> >
> >Reeve
> >
> >--
> >This is the Midrange Systems Technical Discussion (MIDRANGE-L)
> mailing list
> >To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> >To subscribe, unsubscribe, or change list options,
> >visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> >or email: MIDRANGE-L-request@xxxxxxxxxxxx
> >Before posting, please take a moment to review the archives
> >at http://archive.midrange.com/midrange-l.
> 
> 
> 
> 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.