RE: pass parms to qry400

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

Al,

Darn it, you're right again - I forgot that they were using STRQMQRY to run
the query.  Guess I was brain-dead yesterday - not the first time.  Thanks
for keeping me straight.

Dave Shaw
Spartan International, Inc.
Spartanburg, SC

> -----Original Message-----
> From: Al Barsa, Jr. [mailto:barsa2@ibm.net]
> 
> At 08:53 AM 06/30/2000 -0400, you wrote:
> 
> Dave,
> 
> I followed your reference, and got to this link:
> 
> http://as400service.rochester.ibm.com/supporthome.nsf/Document
> /10000051
> 
> I presume that this is where you want me to be.
> 
> After a relatively cursory review, this is moving me to Query 
> Manager/400 
> which is a part of SQL.  Am I wrong?
> 
> Al
> 
> PS:  Happy fourth to all.  I leave for London on the sixth of 
> July for the 
> baptism of a new nephew.  (My son Albert [13] will be the 
> godfather!)  So 
> my responses next week and until 7/13 will be somewhat 
> delayed.  Also I 
> will be without the benefit of a system to play with.
> 
> 
> >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
+---
| 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
+---