RE: Big, Honking SQL Statement

Thanks Rob...that seems to be working for me.

> -------- Original Message --------
> Subject: RE: Big, Honking SQL Statement
> From: rob@xxxxxxxxx
> Date: Tue, December 06, 2005 2:40 pm
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> If you do not actually have QM you could always paste that into a source 
> member.  Then do a CRTQMQRY.  From there you can do a STRQMQRY.  The 
> STRQMQRY is where you put in the values.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> michael@xxxxxxxxxxxxxxxxxx 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 12/06/2005 02:14 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> cc
> 
> Fax to
> 
> Subject
> 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.
> 
> -- 
> 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.