RE: SQL under the covers

["Reeve" <news@xxxxxxxxxx>]

Somewhere the statement is interpreted; I'm thinking specifically of an
evaluation of the CASE statements.

I build SELECT's in other programs; they're easy to diagnose.  But with the
ability to use CASE statements in ORDER BY in V5R2, I'm pushing my customer
to get to previous-release current.  As I develop more complex SQL logic,
I'll need a tool to show me how an SQL statement is formed (or malformed).

-rf   

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
> bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
> Sent: Saturday, July 10, 2004 4:18 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: SQL under the covers
> 
> I'm confused - what do you expect to see, other than what you already
> have?
> The only statement you have is
> 
> select fhpro, etc.
> 
> I'm curious as to what you mean by "created" SQL statement.
> 
> Thanks
> Vern
> 
> At 12:38 PM 7/10/2004, you 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.