RE: Big, Honking SQL Statement

I always look at breaking big honking SQL statements into multiple User
Defined Functions (UDFs).  Usually combinations of scalar and table
UDFs.


HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
  

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> michael@xxxxxxxxxxxxxxxxxx
> Sent: Tuesday, December 06, 2005 1:19 PM
> To: midrange-l
> Subject: Big, Honking SQL Statement
> 
> Ok...here's my deal.
> 
> I have this big SQL statement...it does what I want it to do. 
> I need to pass in two parameters (a numeric date and an alpha 
> string). 
> I need to format the output nicely.
> 
> What's the best approach? Should I have an RPG program that 
> has the SQL
> statement as a variable and I use PREPARE with parameter 
> markers? Is QM
> a better idea?
> 
> Thoughts are appreciated...
> 
> 
> -- 
> 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.
> 
>