RE: Returning Passed SQL Statements from Debug

Thanks to everyone who responded.  I will definitely be looking into
this again when I am going through SQL code.

Thanks!

Brian.

-----Original Message-----
From: kempenich [mailto:kempej01@xxxxxxxxx] 
Sent: Wednesday, March 22, 2006 7:12 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Returning Passed SQL Statements from Debug


I don't know if this was brought up . .

A technique would be to build the complete SQL statement in a RPG
Variable (with using the actual values instead of parameter fields) and
PREPARE the contents of that variable.  There is very little downside
for this approach (because of the SQL Optimizer, caching, etc) and then
the complete variable can be displayed through debug and/or sent to the
job log.

Joe Kempenich


_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way  your home on the Web - http://www.myway.com