RE: Query

[Lynn DiRosa <LDiRosa@xxxxxxxxxxxxxx>]

I would love some details on this.  I need to pass parms, but have not had
time to convert from Query/400 to DB2 Query .....

> -----Original Message-----
> From: Rob Berendt [SMTP:rob@dekko.com]
> Sent: Tuesday, June 01, 1999 2:13 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      RE: Query
> 
> There are some steps you can do to pass parms to Query/400.
> 
> Method 1:
> Convert the Query/400 query into QM/400 and modify it.
> 
> Method 2:
> Set up your parameters in a separate file and join with this file.
> Details available upon request.
> 
> 
> 
> 
> 
> LDiRosa@GIBRALTAR1.COM on 06/01/99 01:04:11 PM
> Please respond to MIDRANGE-L@midrange.com@Internet
> To:   MIDRANGE-L@midrange.com@Internet
> cc:    
> Fax to:       
> Subject:      RE: Query
> 
> DB2 Query Manager for the AS/400 would be an excellent choice if you want
> to
> control user queries to only run in BATCH mode.  Another nice feature is
> that you can pass parameters to a query written in this app.  One downfall
> of AS/400 wrkqry, another potential choice for you, is that it cannot
> receive parms.  They both function very similar and can both take
> advantage
> of the predictive query govenor that comes with most AS/400's past V3R1.
> This query govenor can monitor a query and not allow it to take all the
> AS/400 resources.  Hope this helps.
> 
> Thanks,
> Lynn P. DiRosa
> Gibraltar Steel, Corporate 
> Information Services
> 
> 
> > -----Original Message-----
> > From:       Paul A Troup IV [SMTP:ptroup@gulftel.com]
> > Sent:       Tuesday, June 01, 1999 12:52 PM
> > To: MIDRANGE-L@midrange.com
> > Subject:    Query
> > 
> > I'm looking for a query program to run onÿthe 400.ÿ Does anyone have any
> > recommendations?ÿ 
> +---
> | 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.comm
> +---
> 
> 
> +---
> | 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
+---