RE: Big, Honking SQL Statement

Thanks to all for the suggestions. I've implemented a QM query for my
immediate (tomorrow) need, and will investigate UDFs for the longer
term. This QM stuff is pretty cool.


> -------- Original Message --------
> Subject: RE: Big, Honking SQL Statement
> From: michael@xxxxxxxxxxxxxxxxxx
> Date: Tue, December 06, 2005 2:47 pm
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 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.
> 
> -- 
> 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.