RE: pass parms to qry400

Shoot, this works. Even I got it to work. Already put it into a CL and onto
a users menu and solved an ongoing problem of her always asking for info she
could't get to.

It has it's limitations, but it's a heck of a step forward.

Thank you David.

That's a busy newsgroup there. Good resource. Another one for ya.


> -----Original Message-----
> From: Shaw, David [SMTP:dshaw@spartan.com]
> Sent: Friday, June 30, 2000 5:53 AM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      RE: pass parms to qry400
> 
> Al and anyone else who thinks that parameters can't be passed to
> Query/400:
> 
> Go to http://as400service.rochester.ibm.com .  Expand the "Tech Info &
> Databases" line in the left frame, then choose "Software Knowledge Base".
> Search for document number 6515952, "Passing Parameters to a Query/400
> Query".  This document has pretty straightforward step-by-step
> instructions,
> and should answer your questions.
> 
> I've posted these instructions for finding this document twice to
> comp.sys.ibm.as400.misc , and other people have posted detailed links that
> are supposed to go directly to the document, both here and there.  IT CAN
> BE
> DONE!
> 
> Dave Shaw
> Spartan International, Inc.
> Spartanburg, SC
> 
> > -----Original Message-----
> > From: Al Barsa, Jr. [mailto:barsa2@ibm.net]
> > Sent: Thursday, June 29, 2000 3:45 PM
> > To: MIDRANGE-L@midrange.com
> > Subject: Re: pass parms to qry400
> > 
> > 
> > At 09:31 AM 06/29/2000 -0400, you wrote:
> > >Does anyone know if you can do the following.
> > >
> > >cl pgm
> > >     dcl &item
> > >     dclf screen
> > >     rcvf screen
> > >     runqry xxxxx parm &item
> > >end pgm
> > 
> > Can't do it.  But you can with the Query Management/400 Product.
> > 
> > Al
> > 
> > 
> > 
> > 
> > +--------------------------------------------------+
> > | Please do not send private mail to this address. |
> > | Private mail should go to barsa@ibm.net.         |
> > +--------------------------------------------------+
> > 
> > Al Barsa, Jr. - Account for Midrange-L
> > Barsa Consulting, LLC.      
> > 400 > 390
> > 
> > Phone:              914-251-1234
> > Fax:                914-251-9406
> > http://www.barsaconsulting.com
> > http://www.taatool.com
> > 
> > +---
> > | This is the Midrange System Mailing List!
> > | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to 
> > MIDRANGE-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator: 
> > david@midrange.com
> > +---
> > 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---