RE: pass parms to qry400

["Shaw, David" <dshaw@xxxxxxxxxxx>]

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
+---