Re: SQL under the covers

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

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.