RE: Big, Honking SQL Statement

How can I get an SQL statement into QM?

> -------- Original Message --------
> Subject: Re: Big, Honking SQL Statement
> From: FrankKany@xxxxxxxxxxx
> Date: Tue, December 06, 2005 1:40 pm
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> QM will let you get it done quick and easy.
> 
> Frank W. Kany IV
> Senior Programmer/Analyst 
> Unipres USA, Inc.
> (615) 325-8428 - Office
> (615) 517-1742 - Cell
> http://www.unipres.com
> 
> 
> 
> michael@xxxxxxxxxxxxxxxxxx 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 12/06/2005 12:18 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> midrange-l <midrange-l@xxxxxxxxxxxx>
> cc
> 
> 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.
> 
> 
> -- 
> 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.